ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D6D8173D27CF97E06362FB09051F3DY select null action_, null status_, null message_, null modified_columns_, null request_id_, chartorowid(null) row_id, to_number(null) group_id, 'Vision Operations (USA)' ledger_name, 'Operations' organization, 'CORPORATE 2000' budget, 'Spreadsheet' source, 'Adjustment' category, 'Yes' check_if_journal_balanced, 'Dummy' batch_name, 'Dummy' approval_status, 'Dummy' batch_description, 'Dummy' journal_name, 'Dummy' journal_description, 'Dummy' journal_reference, 'GBP' currency, sysdate accounting_date, 'Jan-99' period, to_char(null) account_alias, to_char(null) concatenated_segments, to_char(null) gl_segment1, to_char(null) gl_segment2, to_char(null) gl_segment3, to_char(null) gl_segment4, to_char(null) gl_segment5, to_char(null) gl_segment6, to_char(null) gl_segment7, to_char(null) gl_segment8, to_char(null) gl_segment9, to_char(null) gl_segment10, to_char(null) gl_segment11, to_char(null) gl_segment12, to_char(null) gl_segment13, to_char(null) gl_segment14, to_char(null) gl_segment15, 0 debit, 0 credit, 0 stat_amount, 'Yes' reverse_journal, 'Jan-99' reversal_period, 'User' conversion_type, sysdate conversion_date, 1 conversion_rate, 'Dummy' line_description, 'A' actual_flag, 'INV' encumbrance_type, null attach_upload_file, null status, sysdate date_created, to_number(null) created_by, to_number(null) user_id, null summary_flag, null post_to_suspense_flag, null submit_approval, null submit_posting, null line_dff_context, null gl_je_line_attribute1, null gl_je_line_attribute2, null gl_je_line_attribute3, null gl_je_line_attribute4, null gl_je_line_attribute5, null gl_je_line_attribute6, null gl_je_line_attribute7, null gl_je_line_attribute8, null gl_je_line_attribute9, null gl_je_line_attribute10, null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_, 0 upload_row from dual where 1=1 and 1=0 and :p_actual_flag=:p_actual_flag and nvl(:p_foreign_currency_flag,'No')=nvl(:p_foreign_currency_flag,'No') and :p_create_summary_jnl=:p_create_summary_jnl and :p_post_to_suspense_flag=:p_post_to_suspense_flag U A xxen_gl_upload.populate_budget_interface US Gl Journal Upload: Test 1=1 :p_actual_flag :p_create_summary_jnl :p_foreign_currency_flag :p_post_to_suspense_flag 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 5 REQUEST_ID_ Char varchar2 6 ROW_ID Rowid rowid Y 7 GROUP_ID Number number 8 LEDGER_NAME Char varchar2 9 ORGANIZATION Char varchar2 10 BUDGET Char varchar2 11 SOURCE Char varchar2 12 CATEGORY Char varchar2 13 CHECK_IF_JOURNAL_BALANCED Char varchar2 14 BATCH_NAME Char varchar2 15 APPROVAL_STATUS Char varchar2 16 BATCH_DESCRIPTION Char varchar2 17 JOURNAL_NAME Char varchar2 18 JOURNAL_DESCRIPTION Char varchar2 19 JOURNAL_REFERENCE Char varchar2 20 CURRENCY Char varchar2 21 ACCOUNTING_DATE Date date 22 PERIOD Char varchar2 23 ACCOUNT_ALIAS Char varchar2 24 CONCATENATED_SEGMENTS Char varchar2 25 GL_SEGMENT1 Char varchar2 26 GL_SEGMENT2 Char varchar2 27 GL_SEGMENT3 Char varchar2 28 GL_SEGMENT4 Char varchar2 29 GL_SEGMENT5 Char varchar2 30 GL_SEGMENT6 Char varchar2 31 GL_SEGMENT7 Char varchar2 32 GL_SEGMENT8 Char varchar2 33 GL_SEGMENT9 Char varchar2 34 GL_SEGMENT10 Char varchar2 35 GL_SEGMENT11 Char varchar2 36 GL_SEGMENT12 Char varchar2 37 GL_SEGMENT13 Char varchar2 38 GL_SEGMENT14 Char varchar2 39 GL_SEGMENT15 Char varchar2 40 DEBIT Number number 41 CREDIT Number number 42 STAT_AMOUNT Number number 43 REVERSE_JOURNAL Char varchar2 44 REVERSAL_PERIOD Char varchar2 45 CONVERSION_TYPE Char varchar2 46 CONVERSION_DATE Date date 47 CONVERSION_RATE Number number 48 LINE_DESCRIPTION Char varchar2 49 ACTUAL_FLAG Char varchar2 50 ENCUMBRANCE_TYPE Char varchar2 51 ATTACH_UPLOAD_FILE Char varchar2 52 STATUS Char varchar2 53 DATE_CREATED Date date 54 CREATED_BY Number number 55 USER_ID Number number 56 SUMMARY_FLAG Char varchar2 57 POST_TO_SUSPENSE_FLAG Char varchar2 58 SUBMIT_APPROVAL Char varchar2 59 SUBMIT_POSTING Char varchar2 60 LINE_DFF_CONTEXT Char varchar2 61 GL_JE_LINE_ATTRIBUTE1 Char varchar2 62 GL_JE_LINE_ATTRIBUTE2 Char varchar2 63 GL_JE_LINE_ATTRIBUTE3 Char varchar2 64 GL_JE_LINE_ATTRIBUTE4 Char varchar2 65 GL_JE_LINE_ATTRIBUTE5 Char varchar2 66 GL_JE_LINE_ATTRIBUTE6 Char varchar2 67 GL_JE_LINE_ATTRIBUTE7 Char varchar2 68 GL_JE_LINE_ATTRIBUTE8 Char varchar2 69 GL_JE_LINE_ATTRIBUTE9 Char varchar2 70 GL_JE_LINE_ATTRIBUTE10 Char varchar2 71 ATTACHMENT_CATEGORY_ Char varchar2 72 ATTACHMENT_TITLE_ Char varchar2 73 ATTACHMENT_DESCRIPTION_ Char varchar2 74 ATTACHMENT_TYPE_ Char varchar2 75 ATTACHMENT_CONTENT_ Char varchar2 76 ATTACHMENT_FILE_ID_ Char varchar2 77 UPLOAD_ROW Number number U 1 p_ledger_id in Number U 2 p_budget_name in Char LEDGER_NAME U 3 p_budget_entity_name in Char U 4 p_currency_code in Char CURRENCY U 5 p_fiscal_year in Char U 6 p_update_logic_type in Char U 7 p_account in Char U 8 p_period1_amount in Number U 9 p_period2_amount in Number U 10 p_period3_amount in Number U 11 p_period4_amount in Number U 12 p_period5_amount in Number U 13 p_period6_amount in Number U 14 p_period7_amount in Number U 15 p_period8_amount in Number U 16 p_period9_amount in Number U 17 p_period10_amount in Number U 18 p_period11_amount in Number U 19 p_period12_amount in Number U 20 p_period13_amount in Number U 21 p_period14_amount in Number U 22 p_period15_amount in Number U 23 p_period16_amount in Number U 24 p_period17_amount in Number U 25 p_period18_amount in Number U 26 p_period19_amount in Number U 27 p_period20_amount in Number U 28 p_period21_amount in Number U 29 p_period22_amount in Number U 30 p_period23_amount in Number U 31 p_period24_amount in Number U 32 p_period25_amount in Number U 33 p_period26_amount in Number U 34 p_period27_amount in Number U 35 p_period28_amount in Number U 36 p_period29_amount in Number U 37 p_period30_amount in Number U 38 p_period31_amount in Number U 39 p_period32_amount in Number U 40 p_period33_amount in Number U 41 p_period34_amount in Number U 42 p_period35_amount in Number U 43 p_period36_amount in Number U 44 p_period37_amount in Number U 45 p_period38_amount in Number U 46 p_period39_amount in Number U 47 p_period40_amount in Number U 48 p_period41_amount in Number U 49 p_period42_amount in Number U 50 p_period43_amount in Number U 51 p_period44_amount in Number U 52 p_period45_amount in Number U 53 p_period46_amount in Number U 54 p_period47_amount in Number U 55 p_period48_amount in Number U 56 p_period49_amount in Number U 57 p_period50_amount in Number U 58 p_period51_amount in Number U 59 p_period52_amount in Number U 60 p_period53_amount in Number U 61 p_period54_amount in Number U 62 p_period55_amount in Number U 63 p_period56_amount in Number U 64 p_period57_amount in Number U 65 p_period58_amount in Number U 66 p_period59_amount in Number U 67 p_period60_amount in Number U 68 p_user_je_category_name in Char U 69 p_user_je_source_name in Char U 70 status_ out Char STATUS_CODE_ U 71 message_ out Char MESSAGE_ U 72 row_id_ out Char ROW_ID Error SQL Success SQL