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 3015: cursor_id := DBMS_SQL.open_cursor;

3011: insert_stmt VARCHAR2(3000);
3012: cursor_id INTEGER;
3013: exec_id INTEGER;
3014: BEGIN
3015: cursor_id := DBMS_SQL.open_cursor;
3016: insert_stmt := 'INSERT INTO ce_available_transactions_tmp ' ||
3017: '(ROW_ID, MULTI_SELECT, BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, ' ||
3018: 'BANK_ACCOUNT_NUM, BANK_NAME, BANK_BRANCH_NAME, '||
3019: 'TRX_ID, TRX_TYPE, TYPE_MEANING, TRX_NUMBER, CHECK_NUMBER, ' ||

Line 3053: DBMS_SQL.Parse(cursor_id,

3049: 'RECEIPT_METHOD_ID, RECEIPT_CLASS_NAME, DEPOSIT_DATE, VALUE_DATE, ' ||
3050: 'REVERSED_RECEIPT_FLAG, LEGAL_ENTITY_ID, ORG_ID FROM ' || X_table ||
3051: ' WHERE ' || X_where_clause;
3052:
3053: DBMS_SQL.Parse(cursor_id,
3054: insert_stmt,
3055: DBMS_SQL.v7);
3056: if (X_asset_code_combination_id is not null) then
3057: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',

Line 3055: DBMS_SQL.v7);

3051: ' WHERE ' || X_where_clause;
3052:
3053: DBMS_SQL.Parse(cursor_id,
3054: insert_stmt,
3055: DBMS_SQL.v7);
3056: if (X_asset_code_combination_id is not null) then
3057: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',
3058: X_asset_code_combination_id);
3059: end if;

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

3053: DBMS_SQL.Parse(cursor_id,
3054: insert_stmt,
3055: DBMS_SQL.v7);
3056: if (X_asset_code_combination_id is not null) then
3057: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',
3058: X_asset_code_combination_id);
3059: end if;
3060: if (X_bank_account_id is not null) then
3061: DBMS_SQL.bind_variable(cursor_id, ':bank_account_id',

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

3057: DBMS_SQL.bind_variable(cursor_id, ':asset_code_combination_id',
3058: X_asset_code_combination_id);
3059: end if;
3060: if (X_bank_account_id is not null) then
3061: DBMS_SQL.bind_variable(cursor_id, ':bank_account_id',
3062: X_bank_account_id);
3063: end if;
3064: if (X_org_id is not null) then
3065: DBMS_SQL.bind_variable(cursor_id, ':org_id',

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

3061: DBMS_SQL.bind_variable(cursor_id, ':bank_account_id',
3062: X_bank_account_id);
3063: end if;
3064: if (X_org_id is not null) then
3065: DBMS_SQL.bind_variable(cursor_id, ':org_id',
3066: X_org_id);
3067: elsif (X_legal_entity_id is not null) then
3068: DBMS_SQL.bind_variable(cursor_id, ':legal_entity_id',
3069: X_legal_entity_id);

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

3064: if (X_org_id is not null) then
3065: DBMS_SQL.bind_variable(cursor_id, ':org_id',
3066: X_org_id);
3067: elsif (X_legal_entity_id is not null) then
3068: DBMS_SQL.bind_variable(cursor_id, ':legal_entity_id',
3069: X_legal_entity_id);
3070: end if;
3071: if (X_from_number is not null AND X_from_number <> '%') then
3072: DBMS_SQL.bind_variable(cursor_id, ':from_number', X_from_number);

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

3068: DBMS_SQL.bind_variable(cursor_id, ':legal_entity_id',
3069: X_legal_entity_id);
3070: end if;
3071: if (X_from_number is not null AND X_from_number <> '%') then
3072: DBMS_SQL.bind_variable(cursor_id, ':from_number', X_from_number);
3073: end if;
3074: if (X_to_number is not null AND X_to_number <> '%') then
3075: DBMS_SQL.bind_variable(cursor_id, ':to_number', X_to_number);
3076: end if;

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

3071: if (X_from_number is not null AND X_from_number <> '%') then
3072: DBMS_SQL.bind_variable(cursor_id, ':from_number', X_from_number);
3073: end if;
3074: if (X_to_number is not null AND X_to_number <> '%') then
3075: DBMS_SQL.bind_variable(cursor_id, ':to_number', X_to_number);
3076: end if;
3077: if (X_status is not null) then
3078: DBMS_SQL.bind_variable(cursor_id, ':status', X_status);
3079: end if;

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

3074: if (X_to_number is not null AND X_to_number <> '%') then
3075: DBMS_SQL.bind_variable(cursor_id, ':to_number', X_to_number);
3076: end if;
3077: if (X_status is not null) then
3078: DBMS_SQL.bind_variable(cursor_id, ':status', X_status);
3079: end if;
3080: if (X_currency_code is not null) then
3081: DBMS_SQL.bind_variable(cursor_id, ':currency_code', X_currency_code);
3082: end if;

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

3077: if (X_status is not null) then
3078: DBMS_SQL.bind_variable(cursor_id, ':status', X_status);
3079: end if;
3080: if (X_currency_code is not null) then
3081: DBMS_SQL.bind_variable(cursor_id, ':currency_code', X_currency_code);
3082: end if;
3083: if (X_reference_id is not null) then
3084: DBMS_SQL.bind_variable(cursor_id, ':reference_id', X_reference_id);
3085: end if;

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

3080: if (X_currency_code is not null) then
3081: DBMS_SQL.bind_variable(cursor_id, ':currency_code', X_currency_code);
3082: end if;
3083: if (X_reference_id is not null) then
3084: DBMS_SQL.bind_variable(cursor_id, ':reference_id', X_reference_id);
3085: end if;
3086: if (X_from_batch_name is not null AND X_from_batch_name <> '%') then
3087: DBMS_SQL.bind_variable(cursor_id, ':from_batch_name', X_from_batch_name);
3088: end if;

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

3083: if (X_reference_id is not null) then
3084: DBMS_SQL.bind_variable(cursor_id, ':reference_id', X_reference_id);
3085: end if;
3086: if (X_from_batch_name is not null AND X_from_batch_name <> '%') then
3087: DBMS_SQL.bind_variable(cursor_id, ':from_batch_name', X_from_batch_name);
3088: end if;
3089: if (X_to_batch_name is not null AND X_to_batch_name <> '%') then
3090: DBMS_SQL.bind_variable(cursor_id, ':to_batch_name', X_to_batch_name);
3091: end if;

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

3086: if (X_from_batch_name is not null AND X_from_batch_name <> '%') then
3087: DBMS_SQL.bind_variable(cursor_id, ':from_batch_name', X_from_batch_name);
3088: end if;
3089: if (X_to_batch_name is not null AND X_to_batch_name <> '%') then
3090: DBMS_SQL.bind_variable(cursor_id, ':to_batch_name', X_to_batch_name);
3091: end if;
3092: if (X_from_remit_num is not null AND X_from_remit_num <> '%') then
3093: DBMS_SQL.bind_variable(cursor_id, ':from_remit_num', X_from_remit_num);
3094: end if;

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

3089: if (X_to_batch_name is not null AND X_to_batch_name <> '%') then
3090: DBMS_SQL.bind_variable(cursor_id, ':to_batch_name', X_to_batch_name);
3091: end if;
3092: if (X_from_remit_num is not null AND X_from_remit_num <> '%') then
3093: DBMS_SQL.bind_variable(cursor_id, ':from_remit_num', X_from_remit_num);
3094: end if;
3095: if (X_to_remit_num is not null AND X_to_remit_num <> '%') then
3096: DBMS_SQL.bind_variable(cursor_id, ':to_remit_num', X_to_remit_num);
3097: end if;

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

3092: if (X_from_remit_num is not null AND X_from_remit_num <> '%') then
3093: DBMS_SQL.bind_variable(cursor_id, ':from_remit_num', X_from_remit_num);
3094: end if;
3095: if (X_to_remit_num is not null AND X_to_remit_num <> '%') then
3096: DBMS_SQL.bind_variable(cursor_id, ':to_remit_num', X_to_remit_num);
3097: end if;
3098: if (X_from_date is not null) then
3099: DBMS_SQL.bind_variable(cursor_id, ':from_date', X_from_date);
3100: end if;

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

3095: if (X_to_remit_num is not null AND X_to_remit_num <> '%') then
3096: DBMS_SQL.bind_variable(cursor_id, ':to_remit_num', X_to_remit_num);
3097: end if;
3098: if (X_from_date is not null) then
3099: DBMS_SQL.bind_variable(cursor_id, ':from_date', X_from_date);
3100: end if;
3101: if (X_to_date is not null) then
3102: DBMS_SQL.bind_variable(cursor_id, ':to_date', X_to_date);
3103: end if;

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

3098: if (X_from_date is not null) then
3099: DBMS_SQL.bind_variable(cursor_id, ':from_date', X_from_date);
3100: end if;
3101: if (X_to_date is not null) then
3102: DBMS_SQL.bind_variable(cursor_id, ':to_date', X_to_date);
3103: end if;
3104: if (X_from_maturity_date is not null) then
3105: DBMS_SQL.bind_variable(cursor_id, ':from_maturity_date',
3106: X_from_maturity_date);

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

3101: if (X_to_date is not null) then
3102: DBMS_SQL.bind_variable(cursor_id, ':to_date', X_to_date);
3103: end if;
3104: if (X_from_maturity_date is not null) then
3105: DBMS_SQL.bind_variable(cursor_id, ':from_maturity_date',
3106: X_from_maturity_date);
3107: end if;
3108: if (X_to_maturity_date is not null) then
3109: DBMS_SQL.bind_variable(cursor_id, ':to_maturity_date',

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

3105: DBMS_SQL.bind_variable(cursor_id, ':from_maturity_date',
3106: X_from_maturity_date);
3107: end if;
3108: if (X_to_maturity_date is not null) then
3109: DBMS_SQL.bind_variable(cursor_id, ':to_maturity_date',
3110: X_to_maturity_date);
3111: end if;
3112: if (X_customer_id is not null) then
3113: DBMS_SQL.bind_variable(cursor_id, ':customer_id', X_customer_id);

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

3109: DBMS_SQL.bind_variable(cursor_id, ':to_maturity_date',
3110: X_to_maturity_date);
3111: end if;
3112: if (X_customer_id is not null) then
3113: DBMS_SQL.bind_variable(cursor_id, ':customer_id', X_customer_id);
3114: end if;
3115: if (X_receipt_class_id is not null) then
3116: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3117: X_receipt_class_id);

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

3112: if (X_customer_id is not null) then
3113: DBMS_SQL.bind_variable(cursor_id, ':customer_id', X_customer_id);
3114: end if;
3115: if (X_receipt_class_id is not null) then
3116: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3117: X_receipt_class_id);
3118: end if;
3119: if (X_receipt_method_id is not null) then
3120: DBMS_SQL.bind_variable(cursor_id, ':receipt_method_id',

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

3116: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3117: X_receipt_class_id);
3118: end if;
3119: if (X_receipt_method_id is not null) then
3120: DBMS_SQL.bind_variable(cursor_id, ':receipt_method_id',
3121: X_receipt_method_id);
3122: end if;
3123: if (X_deposit_date_from is not null) then
3124: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_from',

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

3120: DBMS_SQL.bind_variable(cursor_id, ':receipt_method_id',
3121: X_receipt_method_id);
3122: end if;
3123: if (X_deposit_date_from is not null) then
3124: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_from',
3125: X_deposit_date_from);
3126: end if;
3127: if (X_deposit_date_to is not null) then
3128: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_to', X_deposit_date_to);

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

3124: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_from',
3125: X_deposit_date_from);
3126: end if;
3127: if (X_deposit_date_to is not null) then
3128: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_to', X_deposit_date_to);
3129: end if;
3130: if (X_receipt_class_id is not null) then
3131: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3132: X_receipt_class_id);

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

3127: if (X_deposit_date_to is not null) then
3128: DBMS_SQL.bind_variable(cursor_id, ':deposit_date_to', X_deposit_date_to);
3129: end if;
3130: if (X_receipt_class_id is not null) then
3131: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3132: X_receipt_class_id);
3133: end if;
3134: if (X_supplier_id is not null) then
3135: DBMS_SQL.bind_variable(cursor_id, ':supplier_id', X_supplier_id);

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

3131: DBMS_SQL.bind_variable(cursor_id, ':receipt_class_id',
3132: X_receipt_class_id);
3133: end if;
3134: if (X_supplier_id is not null) then
3135: DBMS_SQL.bind_variable(cursor_id, ':supplier_id', X_supplier_id);
3136: end if;
3137: if (X_reference_type is not null) then
3138: DBMS_SQL.bind_variable(cursor_id, ':reference_type', X_reference_type);
3139: end if;

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

3134: if (X_supplier_id is not null) then
3135: DBMS_SQL.bind_variable(cursor_id, ':supplier_id', X_supplier_id);
3136: end if;
3137: if (X_reference_type is not null) then
3138: DBMS_SQL.bind_variable(cursor_id, ':reference_type', X_reference_type);
3139: end if;
3140: if (X_period_name is not null) then
3141: DBMS_SQL.bind_variable(cursor_id, ':period_name', X_period_name);
3142: end if;

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

3137: if (X_reference_type is not null) then
3138: DBMS_SQL.bind_variable(cursor_id, ':reference_type', X_reference_type);
3139: end if;
3140: if (X_period_name is not null) then
3141: DBMS_SQL.bind_variable(cursor_id, ':period_name', X_period_name);
3142: end if;
3143: if (X_from_journal_entry_name is not null
3144: AND X_from_journal_entry_name <> '%') then
3145: DBMS_SQL.bind_variable(cursor_id, ':from_journal_entry_name',

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

3141: DBMS_SQL.bind_variable(cursor_id, ':period_name', X_period_name);
3142: end if;
3143: if (X_from_journal_entry_name is not null
3144: AND X_from_journal_entry_name <> '%') then
3145: DBMS_SQL.bind_variable(cursor_id, ':from_journal_entry_name',
3146: X_from_journal_entry_name);
3147: end if;
3148: if (X_to_journal_entry_name is not null
3149: AND X_to_journal_entry_name <> '%') then

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

3146: X_from_journal_entry_name);
3147: end if;
3148: if (X_to_journal_entry_name is not null
3149: AND X_to_journal_entry_name <> '%') then
3150: DBMS_SQL.bind_variable(cursor_id, ':to_journal_entry_name',
3151: X_to_journal_entry_name);
3152: end if;
3153: if (X_from_document_number is not null) then
3154: DBMS_SQL.bind_variable(cursor_id, ':from_document_number',

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

3150: DBMS_SQL.bind_variable(cursor_id, ':to_journal_entry_name',
3151: X_to_journal_entry_name);
3152: end if;
3153: if (X_from_document_number is not null) then
3154: DBMS_SQL.bind_variable(cursor_id, ':from_document_number',
3155: X_from_document_number);
3156: end if;
3157: if (X_to_document_number is not null) then
3158: DBMS_SQL.bind_variable(cursor_id, ':to_document_number',

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

3154: DBMS_SQL.bind_variable(cursor_id, ':from_document_number',
3155: X_from_document_number);
3156: end if;
3157: if (X_to_document_number is not null) then
3158: DBMS_SQL.bind_variable(cursor_id, ':to_document_number',
3159: X_to_document_number);
3160: end if;
3161: if (X_from_je_line_number is not null) then
3162: DBMS_SQL.bind_variable(cursor_id, ':from_je_line_number',

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

3158: DBMS_SQL.bind_variable(cursor_id, ':to_document_number',
3159: X_to_document_number);
3160: end if;
3161: if (X_from_je_line_number is not null) then
3162: DBMS_SQL.bind_variable(cursor_id, ':from_je_line_number',
3163: X_from_je_line_number);
3164: end if;
3165: if (X_to_je_line_number is not null) then
3166: DBMS_SQL.bind_variable(cursor_id, ':to_je_line_number',

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

3162: DBMS_SQL.bind_variable(cursor_id, ':from_je_line_number',
3163: X_from_je_line_number);
3164: end if;
3165: if (X_to_je_line_number is not null) then
3166: DBMS_SQL.bind_variable(cursor_id, ':to_je_line_number',
3167: X_to_je_line_number);
3168: end if;
3169: if (X_cleared_date is not null) then
3170: DBMS_SQL.bind_variable(cursor_id, ':cleared_date', X_cleared_date);

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

3166: DBMS_SQL.bind_variable(cursor_id, ':to_je_line_number',
3167: X_to_je_line_number);
3168: end if;
3169: if (X_cleared_date is not null) then
3170: DBMS_SQL.bind_variable(cursor_id, ':cleared_date', X_cleared_date);
3171: end if;
3172: if (X_value_date is not null) then
3173: DBMS_SQL.bind_variable(cursor_id, ':value_date', X_value_date);
3174: end if;

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

3169: if (X_cleared_date is not null) then
3170: DBMS_SQL.bind_variable(cursor_id, ':cleared_date', X_cleared_date);
3171: end if;
3172: if (X_value_date is not null) then
3173: DBMS_SQL.bind_variable(cursor_id, ':value_date', X_value_date);
3174: end if;
3175: if (X_gl_date is not null) then
3176: DBMS_SQL.bind_variable(cursor_id, ':gl_date', X_gl_date);
3177: end if;

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

3172: if (X_value_date is not null) then
3173: DBMS_SQL.bind_variable(cursor_id, ':value_date', X_value_date);
3174: end if;
3175: if (X_gl_date is not null) then
3176: DBMS_SQL.bind_variable(cursor_id, ':gl_date', X_gl_date);
3177: end if;
3178: if (X_from_amount is not null) then
3179: DBMS_SQL.bind_variable(cursor_id, ':from_amount', X_from_amount);
3180: end if;

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

3175: if (X_gl_date is not null) then
3176: DBMS_SQL.bind_variable(cursor_id, ':gl_date', X_gl_date);
3177: end if;
3178: if (X_from_amount is not null) then
3179: DBMS_SQL.bind_variable(cursor_id, ':from_amount', X_from_amount);
3180: end if;
3181: if (X_to_amount is not null) then
3182: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3183: end if;

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

3178: if (X_from_amount is not null) then
3179: DBMS_SQL.bind_variable(cursor_id, ':from_amount', X_from_amount);
3180: end if;
3181: if (X_to_amount is not null) then
3182: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3183: end if;
3184: exec_id := DBMS_SQL.execute(cursor_id);
3185: DBMS_SQL.close_cursor(cursor_id);
3186: EXCEPTION

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

3180: end if;
3181: if (X_to_amount is not null) then
3182: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3183: end if;
3184: exec_id := DBMS_SQL.execute(cursor_id);
3185: DBMS_SQL.close_cursor(cursor_id);
3186: EXCEPTION
3187: when others then
3188: null;

Line 3185: DBMS_SQL.close_cursor(cursor_id);

3181: if (X_to_amount is not null) then
3182: DBMS_SQL.bind_variable(cursor_id, ':to_amount', X_to_amount);
3183: end if;
3184: exec_id := DBMS_SQL.execute(cursor_id);
3185: DBMS_SQL.close_cursor(cursor_id);
3186: EXCEPTION
3187: when others then
3188: null;
3189: END populate_avail_trx;