eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_CLEAR1 dependencies on DBMS_SQL

Line 3104: cursor_id := DBMS_SQL.open_cursor;

3100: insert_stmt VARCHAR2(3000);
3101: cursor_id INTEGER;
3102: exec_id INTEGER;
3103: BEGIN
3104: cursor_id := DBMS_SQL.open_cursor;
3105: insert_stmt := 'INSERT INTO ce_available_transactions_tmp ' ||
3106: '(ROW_ID, MULTI_SELECT, BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, ' ||
3107: 'BANK_ACCOUNT_NUM, BANK_NAME, BANK_BRANCH_NAME, '||
3108: 'TRX_ID, TRX_TYPE, TYPE_MEANING, TRX_NUMBER, CHECK_NUMBER, ' ||

Line 3142: DBMS_SQL.Parse(cursor_id,

3138: 'RECEIPT_METHOD_ID, RECEIPT_CLASS_NAME, DEPOSIT_DATE, VALUE_DATE, ' ||
3139: 'REVERSED_RECEIPT_FLAG, LEGAL_ENTITY_ID, ORG_ID FROM ' || X_table ||
3140: ' WHERE ' || X_where_clause;
3141:
3142: DBMS_SQL.Parse(cursor_id,
3143: insert_stmt,
3144: DBMS_SQL.v7);
3145: if (X_asset_code_combination_id is not null) then
3146: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',

Line 3144: DBMS_SQL.v7);

3140: ' WHERE ' || X_where_clause;
3141:
3142: DBMS_SQL.Parse(cursor_id,
3143: insert_stmt,
3144: DBMS_SQL.v7);
3145: if (X_asset_code_combination_id is not null) then
3146: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',
3147: X_asset_code_combination_id);
3148: end if;

Line 3146: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',

3142: DBMS_SQL.Parse(cursor_id,
3143: insert_stmt,
3144: DBMS_SQL.v7);
3145: if (X_asset_code_combination_id is not null) then
3146: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',
3147: X_asset_code_combination_id);
3148: end if;
3149: if (X_bank_account_id is not null) then
3150: DBMS_SQL.bind_variable(cursor_id, ':bank_account_id',

Line 3150: DBMS_SQL.bind_variable(cursor_id, ':bank_account_id',

3146: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',
3147: X_asset_code_combination_id);
3148: end if;
3149: if (X_bank_account_id is not null) then
3150: DBMS_SQL.bind_variable(cursor_id, ':bank_account_id',
3151: X_bank_account_id);
3152: end if;
3153: if (X_org_id is not null) then
3154: DBMS_SQL.bind_variable(cursor_id, ':org_id',

Line 3154: DBMS_SQL.bind_variable(cursor_id, ':org_id',

3150: DBMS_SQL.bind_variable(cursor_id, ':bank_account_id',
3151: X_bank_account_id);
3152: end if;
3153: if (X_org_id is not null) then
3154: DBMS_SQL.bind_variable(cursor_id, ':org_id',
3155: X_org_id);
3156: elsif (X_legal_entity_id is not null) then
3157: DBMS_SQL.bind_variable(cursor_id, ':legal_entity_id',
3158: X_legal_entity_id);

Line 3157: DBMS_SQL.bind_variable(cursor_id, ':legal_entity_id',

3153: if (X_org_id is not null) then
3154: DBMS_SQL.bind_variable(cursor_id, ':org_id',
3155: X_org_id);
3156: elsif (X_legal_entity_id is not null) then
3157: DBMS_SQL.bind_variable(cursor_id, ':legal_entity_id',
3158: X_legal_entity_id);
3159: end if;
3160: if (X_from_number is not null AND X_from_number <> '%') then
3161: DBMS_SQL.bind_variable(cursor_id, ':from_number', X_from_number);

Line 3161: DBMS_SQL.bind_variable(cursor_id, ':from_number', X_from_number);

3157: DBMS_SQL.bind_variable(cursor_id, ':legal_entity_id',
3158: X_legal_entity_id);
3159: end if;
3160: if (X_from_number is not null AND X_from_number <> '%') then
3161: DBMS_SQL.bind_variable(cursor_id, ':from_number', X_from_number);
3162: end if;
3163: if (X_to_number is not null AND X_to_number <> '%') then
3164: DBMS_SQL.bind_variable(cursor_id, ':to_number', X_to_number);
3165: end if;

Line 3164: DBMS_SQL.bind_variable(cursor_id, ':to_number', X_to_number);

3160: if (X_from_number is not null AND X_from_number <> '%') then
3161: DBMS_SQL.bind_variable(cursor_id, ':from_number', X_from_number);
3162: end if;
3163: if (X_to_number is not null AND X_to_number <> '%') then
3164: DBMS_SQL.bind_variable(cursor_id, ':to_number', X_to_number);
3165: end if;
3166: if (X_status is not null) then
3167: DBMS_SQL.bind_variable(cursor_id, ':status', X_status);
3168: end if;

Line 3167: DBMS_SQL.bind_variable(cursor_id, ':status', X_status);

3163: if (X_to_number is not null AND X_to_number <> '%') then
3164: DBMS_SQL.bind_variable(cursor_id, ':to_number', X_to_number);
3165: end if;
3166: if (X_status is not null) then
3167: DBMS_SQL.bind_variable(cursor_id, ':status', X_status);
3168: end if;
3169: if (X_currency_code is not null) then
3170: DBMS_SQL.bind_variable(cursor_id, ':currency_code', X_currency_code);
3171: end if;

Line 3170: DBMS_SQL.bind_variable(cursor_id, ':currency_code', X_currency_code);

3166: if (X_status is not null) then
3167: DBMS_SQL.bind_variable(cursor_id, ':status', X_status);
3168: end if;
3169: if (X_currency_code is not null) then
3170: DBMS_SQL.bind_variable(cursor_id, ':currency_code', X_currency_code);
3171: end if;
3172: if (X_reference_id is not null) then
3173: DBMS_SQL.bind_variable(cursor_id, ':reference_id', X_reference_id);
3174: end if;

Line 3173: DBMS_SQL.bind_variable(cursor_id, ':reference_id', X_reference_id);

3169: if (X_currency_code is not null) then
3170: DBMS_SQL.bind_variable(cursor_id, ':currency_code', X_currency_code);
3171: end if;
3172: if (X_reference_id is not null) then
3173: DBMS_SQL.bind_variable(cursor_id, ':reference_id', X_reference_id);
3174: end if;
3175: if (X_from_batch_name is not null AND X_from_batch_name <> '%') then
3176: DBMS_SQL.bind_variable(cursor_id, ':from_batch_name', X_from_batch_name);
3177: end if;

Line 3176: DBMS_SQL.bind_variable(cursor_id, ':from_batch_name', X_from_batch_name);

3172: if (X_reference_id is not null) then
3173: DBMS_SQL.bind_variable(cursor_id, ':reference_id', X_reference_id);
3174: end if;
3175: if (X_from_batch_name is not null AND X_from_batch_name <> '%') then
3176: DBMS_SQL.bind_variable(cursor_id, ':from_batch_name', X_from_batch_name);
3177: end if;
3178: if (X_to_batch_name is not null AND X_to_batch_name <> '%') then
3179: DBMS_SQL.bind_variable(cursor_id, ':to_batch_name', X_to_batch_name);
3180: end if;

Line 3179: DBMS_SQL.bind_variable(cursor_id, ':to_batch_name', X_to_batch_name);

3175: if (X_from_batch_name is not null AND X_from_batch_name <> '%') then
3176: DBMS_SQL.bind_variable(cursor_id, ':from_batch_name', X_from_batch_name);
3177: end if;
3178: if (X_to_batch_name is not null AND X_to_batch_name <> '%') then
3179: DBMS_SQL.bind_variable(cursor_id, ':to_batch_name', X_to_batch_name);
3180: end if;
3181: if (X_from_remit_num is not null AND X_from_remit_num <> '%') then
3182: DBMS_SQL.bind_variable(cursor_id, ':from_remit_num', X_from_remit_num);
3183: end if;

Line 3182: DBMS_SQL.bind_variable(cursor_id, ':from_remit_num', X_from_remit_num);

3178: if (X_to_batch_name is not null AND X_to_batch_name <> '%') then
3179: DBMS_SQL.bind_variable(cursor_id, ':to_batch_name', X_to_batch_name);
3180: end if;
3181: if (X_from_remit_num is not null AND X_from_remit_num <> '%') then
3182: DBMS_SQL.bind_variable(cursor_id, ':from_remit_num', X_from_remit_num);
3183: end if;
3184: if (X_to_remit_num is not null AND X_to_remit_num <> '%') then
3185: DBMS_SQL.bind_variable(cursor_id, ':to_remit_num', X_to_remit_num);
3186: end if;

Line 3185: DBMS_SQL.bind_variable(cursor_id, ':to_remit_num', X_to_remit_num);

3181: if (X_from_remit_num is not null AND X_from_remit_num <> '%') then
3182: DBMS_SQL.bind_variable(cursor_id, ':from_remit_num', X_from_remit_num);
3183: end if;
3184: if (X_to_remit_num is not null AND X_to_remit_num <> '%') then
3185: DBMS_SQL.bind_variable(cursor_id, ':to_remit_num', X_to_remit_num);
3186: end if;
3187: if (X_from_date is not null) then
3188: DBMS_SQL.bind_variable(cursor_id, ':from_date', X_from_date);
3189: end if;

Line 3188: DBMS_SQL.bind_variable(cursor_id, ':from_date', X_from_date);

3184: if (X_to_remit_num is not null AND X_to_remit_num <> '%') then
3185: DBMS_SQL.bind_variable(cursor_id, ':to_remit_num', X_to_remit_num);
3186: end if;
3187: if (X_from_date is not null) then
3188: DBMS_SQL.bind_variable(cursor_id, ':from_date', X_from_date);
3189: end if;
3190: if (X_to_date is not null) then
3191: DBMS_SQL.bind_variable(cursor_id, ':to_date', X_to_date);
3192: end if;

Line 3191: DBMS_SQL.bind_variable(cursor_id, ':to_date', X_to_date);

3187: if (X_from_date is not null) then
3188: DBMS_SQL.bind_variable(cursor_id, ':from_date', X_from_date);
3189: end if;
3190: if (X_to_date is not null) then
3191: DBMS_SQL.bind_variable(cursor_id, ':to_date', X_to_date);
3192: end if;
3193: if (X_from_maturity_date is not null) then
3194: DBMS_SQL.bind_variable(cursor_id, ':from_maturity_date',
3195: X_from_maturity_date);

Line 3194: DBMS_SQL.bind_variable(cursor_id, ':from_maturity_date',

3190: if (X_to_date is not null) then
3191: DBMS_SQL.bind_variable(cursor_id, ':to_date', X_to_date);
3192: end if;
3193: if (X_from_maturity_date is not null) then
3194: DBMS_SQL.bind_variable(cursor_id, ':from_maturity_date',
3195: X_from_maturity_date);
3196: end if;
3197: if (X_to_maturity_date is not null) then
3198: DBMS_SQL.bind_variable(cursor_id, ':to_maturity_date',

Line 3198: DBMS_SQL.bind_variable(cursor_id, ':to_maturity_date',

3194: DBMS_SQL.bind_variable(cursor_id, ':from_maturity_date',
3195: X_from_maturity_date);
3196: end if;
3197: if (X_to_maturity_date is not null) then
3198: DBMS_SQL.bind_variable(cursor_id, ':to_maturity_date',
3199: X_to_maturity_date);
3200: end if;
3201: if (X_customer_id is not null) then
3202: DBMS_SQL.bind_variable(cursor_id, ':customer_id', X_customer_id);

Line 3202: DBMS_SQL.bind_variable(cursor_id, ':customer_id', X_customer_id);

3198: DBMS_SQL.bind_variable(cursor_id, ':to_maturity_date',
3199: X_to_maturity_date);
3200: end if;
3201: if (X_customer_id is not null) then
3202: DBMS_SQL.bind_variable(cursor_id, ':customer_id', X_customer_id);
3203: end if;
3204: if (X_receipt_class_id is not null) then
3205: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3206: X_receipt_class_id);

Line 3205: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',

3201: if (X_customer_id is not null) then
3202: DBMS_SQL.bind_variable(cursor_id, ':customer_id', X_customer_id);
3203: end if;
3204: if (X_receipt_class_id is not null) then
3205: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3206: X_receipt_class_id);
3207: end if;
3208: if (X_receipt_method_id is not null) then
3209: DBMS_SQL.bind_variable(cursor_id, ':receipt_method_id',

Line 3209: DBMS_SQL.bind_variable(cursor_id, ':receipt_method_id',

3205: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3206: X_receipt_class_id);
3207: end if;
3208: if (X_receipt_method_id is not null) then
3209: DBMS_SQL.bind_variable(cursor_id, ':receipt_method_id',
3210: X_receipt_method_id);
3211: end if;
3212: if (X_deposit_date_from is not null) then
3213: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_from',

Line 3213: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_from',

3209: DBMS_SQL.bind_variable(cursor_id, ':receipt_method_id',
3210: X_receipt_method_id);
3211: end if;
3212: if (X_deposit_date_from is not null) then
3213: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_from',
3214: X_deposit_date_from);
3215: end if;
3216: if (X_deposit_date_to is not null) then
3217: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_to', X_deposit_date_to);

Line 3217: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_to', X_deposit_date_to);

3213: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_from',
3214: X_deposit_date_from);
3215: end if;
3216: if (X_deposit_date_to is not null) then
3217: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_to', X_deposit_date_to);
3218: end if;
3219: if (X_receipt_class_id is not null) then
3220: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3221: X_receipt_class_id);

Line 3220: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',

3216: if (X_deposit_date_to is not null) then
3217: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_to', X_deposit_date_to);
3218: end if;
3219: if (X_receipt_class_id is not null) then
3220: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3221: X_receipt_class_id);
3222: end if;
3223: if (X_supplier_id is not null) then
3224: DBMS_SQL.bind_variable(cursor_id, ':supplier_id', X_supplier_id);

Line 3224: DBMS_SQL.bind_variable(cursor_id, ':supplier_id', X_supplier_id);

3220: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3221: X_receipt_class_id);
3222: end if;
3223: if (X_supplier_id is not null) then
3224: DBMS_SQL.bind_variable(cursor_id, ':supplier_id', X_supplier_id);
3225: end if;
3226: if (X_reference_type is not null) then
3227: DBMS_SQL.bind_variable(cursor_id, ':reference_type', X_reference_type);
3228: end if;

Line 3227: DBMS_SQL.bind_variable(cursor_id, ':reference_type', X_reference_type);

3223: if (X_supplier_id is not null) then
3224: DBMS_SQL.bind_variable(cursor_id, ':supplier_id', X_supplier_id);
3225: end if;
3226: if (X_reference_type is not null) then
3227: DBMS_SQL.bind_variable(cursor_id, ':reference_type', X_reference_type);
3228: end if;
3229: if (X_period_name is not null) then
3230: DBMS_SQL.bind_variable(cursor_id, ':period_name', X_period_name);
3231: end if;

Line 3230: DBMS_SQL.bind_variable(cursor_id, ':period_name', X_period_name);

3226: if (X_reference_type is not null) then
3227: DBMS_SQL.bind_variable(cursor_id, ':reference_type', X_reference_type);
3228: end if;
3229: if (X_period_name is not null) then
3230: DBMS_SQL.bind_variable(cursor_id, ':period_name', X_period_name);
3231: end if;
3232: if (X_from_journal_entry_name is not null
3233: AND X_from_journal_entry_name <> '%') then
3234: DBMS_SQL.bind_variable(cursor_id, ':from_journal_entry_name',

Line 3234: DBMS_SQL.bind_variable(cursor_id, ':from_journal_entry_name',

3230: DBMS_SQL.bind_variable(cursor_id, ':period_name', X_period_name);
3231: end if;
3232: if (X_from_journal_entry_name is not null
3233: AND X_from_journal_entry_name <> '%') then
3234: DBMS_SQL.bind_variable(cursor_id, ':from_journal_entry_name',
3235: X_from_journal_entry_name);
3236: end if;
3237: if (X_to_journal_entry_name is not null
3238: AND X_to_journal_entry_name <> '%') then

Line 3239: DBMS_SQL.bind_variable(cursor_id, ':to_journal_entry_name',

3235: X_from_journal_entry_name);
3236: end if;
3237: if (X_to_journal_entry_name is not null
3238: AND X_to_journal_entry_name <> '%') then
3239: DBMS_SQL.bind_variable(cursor_id, ':to_journal_entry_name',
3240: X_to_journal_entry_name);
3241: end if;
3242: if (X_from_document_number is not null) then
3243: DBMS_SQL.bind_variable(cursor_id, ':from_document_number',

Line 3243: DBMS_SQL.bind_variable(cursor_id, ':from_document_number',

3239: DBMS_SQL.bind_variable(cursor_id, ':to_journal_entry_name',
3240: X_to_journal_entry_name);
3241: end if;
3242: if (X_from_document_number is not null) then
3243: DBMS_SQL.bind_variable(cursor_id, ':from_document_number',
3244: X_from_document_number);
3245: end if;
3246: if (X_to_document_number is not null) then
3247: DBMS_SQL.bind_variable(cursor_id, ':to_document_number',

Line 3247: DBMS_SQL.bind_variable(cursor_id, ':to_document_number',

3243: DBMS_SQL.bind_variable(cursor_id, ':from_document_number',
3244: X_from_document_number);
3245: end if;
3246: if (X_to_document_number is not null) then
3247: DBMS_SQL.bind_variable(cursor_id, ':to_document_number',
3248: X_to_document_number);
3249: end if;
3250: if (X_from_je_line_number is not null) then
3251: DBMS_SQL.bind_variable(cursor_id, ':from_je_line_number',

Line 3251: DBMS_SQL.bind_variable(cursor_id, ':from_je_line_number',

3247: DBMS_SQL.bind_variable(cursor_id, ':to_document_number',
3248: X_to_document_number);
3249: end if;
3250: if (X_from_je_line_number is not null) then
3251: DBMS_SQL.bind_variable(cursor_id, ':from_je_line_number',
3252: X_from_je_line_number);
3253: end if;
3254: if (X_to_je_line_number is not null) then
3255: DBMS_SQL.bind_variable(cursor_id, ':to_je_line_number',

Line 3255: DBMS_SQL.bind_variable(cursor_id, ':to_je_line_number',

3251: DBMS_SQL.bind_variable(cursor_id, ':from_je_line_number',
3252: X_from_je_line_number);
3253: end if;
3254: if (X_to_je_line_number is not null) then
3255: DBMS_SQL.bind_variable(cursor_id, ':to_je_line_number',
3256: X_to_je_line_number);
3257: end if;
3258: if (X_cleared_date is not null) then
3259: DBMS_SQL.bind_variable(cursor_id, ':cleared_date', X_cleared_date);

Line 3259: DBMS_SQL.bind_variable(cursor_id, ':cleared_date', X_cleared_date);

3255: DBMS_SQL.bind_variable(cursor_id, ':to_je_line_number',
3256: X_to_je_line_number);
3257: end if;
3258: if (X_cleared_date is not null) then
3259: DBMS_SQL.bind_variable(cursor_id, ':cleared_date', X_cleared_date);
3260: end if;
3261: if (X_value_date is not null) then
3262: DBMS_SQL.bind_variable(cursor_id, ':value_date', X_value_date);
3263: end if;

Line 3262: DBMS_SQL.bind_variable(cursor_id, ':value_date', X_value_date);

3258: if (X_cleared_date is not null) then
3259: DBMS_SQL.bind_variable(cursor_id, ':cleared_date', X_cleared_date);
3260: end if;
3261: if (X_value_date is not null) then
3262: DBMS_SQL.bind_variable(cursor_id, ':value_date', X_value_date);
3263: end if;
3264: if (X_gl_date is not null) then
3265: DBMS_SQL.bind_variable(cursor_id, ':gl_date', X_gl_date);
3266: end if;

Line 3265: DBMS_SQL.bind_variable(cursor_id, ':gl_date', X_gl_date);

3261: if (X_value_date is not null) then
3262: DBMS_SQL.bind_variable(cursor_id, ':value_date', X_value_date);
3263: end if;
3264: if (X_gl_date is not null) then
3265: DBMS_SQL.bind_variable(cursor_id, ':gl_date', X_gl_date);
3266: end if;
3267: if (X_from_amount is not null) then
3268: DBMS_SQL.bind_variable(cursor_id, ':from_amount', X_from_amount);
3269: end if;

Line 3268: DBMS_SQL.bind_variable(cursor_id, ':from_amount', X_from_amount);

3264: if (X_gl_date is not null) then
3265: DBMS_SQL.bind_variable(cursor_id, ':gl_date', X_gl_date);
3266: end if;
3267: if (X_from_amount is not null) then
3268: DBMS_SQL.bind_variable(cursor_id, ':from_amount', X_from_amount);
3269: end if;
3270: if (X_to_amount is not null) then
3271: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3272: end if;

Line 3271: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);

3267: if (X_from_amount is not null) then
3268: DBMS_SQL.bind_variable(cursor_id, ':from_amount', X_from_amount);
3269: end if;
3270: if (X_to_amount is not null) then
3271: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3272: end if;
3273: exec_id := DBMS_SQL.execute(cursor_id);
3274: DBMS_SQL.close_cursor(cursor_id);
3275: EXCEPTION

Line 3273: exec_id := DBMS_SQL.execute(cursor_id);

3269: end if;
3270: if (X_to_amount is not null) then
3271: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3272: end if;
3273: exec_id := DBMS_SQL.execute(cursor_id);
3274: DBMS_SQL.close_cursor(cursor_id);
3275: EXCEPTION
3276: when others then
3277: null;

Line 3274: DBMS_SQL.close_cursor(cursor_id);

3270: if (X_to_amount is not null) then
3271: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3272: end if;
3273: exec_id := DBMS_SQL.execute(cursor_id);
3274: DBMS_SQL.close_cursor(cursor_id);
3275: EXCEPTION
3276: when others then
3277: null;
3278: END populate_avail_trx;