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.ARP_AUTO_ACCOUNTING_BR dependencies on DBMS_SQL

Line 1103: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );

1099: p_select_rec IN select_rec_type) IS
1100: BEGIN
1101: print_fcn_label2( 'arp_auto_accounting_br.define_columns()+' );
1102:
1103: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);
1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);
1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);

Line 1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);

1100: BEGIN
1101: print_fcn_label2( 'arp_auto_accounting_br.define_columns()+' );
1102:
1103: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);
1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);
1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);

Line 1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);

1101: print_fcn_label2( 'arp_auto_accounting_br.define_columns()+' );
1102:
1103: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);
1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);
1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);

Line 1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);

1102:
1103: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);
1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);
1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);

Line 1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);

1103: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);
1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);
1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);

Line 1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);

1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);
1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);
1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);

Line 1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);

1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);
1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);

Line 1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);

1106: dbms_sql.define_column( p_select_c, 4, p_select_rec.drawee_id);
1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);

Line 1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);

1107: dbms_sql.define_column( p_select_c, 5, p_select_rec.bill_to_site_use_id);
1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);

Line 1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);

1108: dbms_sql.define_column( p_select_c, 6, p_select_rec.br_unpaid_flag,1);
1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);

Line 1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);

1109: dbms_sql.define_column( p_select_c, 7, p_select_rec.transaction_history_id);
1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);

Line 1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);

1110: dbms_sql.define_column( p_select_c, 8, p_select_rec.batch_id);
1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);

Line 1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);

1111: dbms_sql.define_column( p_select_c, 9, p_select_rec.gl_date,12);
1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);

Line 1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);

1112: dbms_sql.define_column( p_select_c, 10, p_select_rec.source_type, 30);
1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);

Line 1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);

1113: dbms_sql.define_column( p_select_c, 11, p_select_rec.amount);
1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);
1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);

Line 1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);

1114: dbms_sql.define_column( p_select_c, 12, p_select_rec.acctd_amount);
1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);
1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);
1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);

Line 1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);

1115: dbms_sql.define_column( p_select_c, 13, p_select_rec.currency_code,15);
1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);
1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);
1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);
1123: dbms_sql.define_column( p_select_c, 21, p_select_rec.br_unpaid_ccid);

Line 1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);

1116: dbms_sql.define_column( p_select_c, 14, p_select_rec.currency_conversion_rate);
1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);
1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);
1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);
1123: dbms_sql.define_column( p_select_c, 21, p_select_rec.br_unpaid_ccid);
1124:

Line 1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);

1117: dbms_sql.define_column( p_select_c, 15, p_select_rec.currency_conversion_type,30);
1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);
1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);
1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);
1123: dbms_sql.define_column( p_select_c, 21, p_select_rec.br_unpaid_ccid);
1124:
1125: print_fcn_label2( 'arp_auto_accounting_br.define_columns()-' );

Line 1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);

1118: dbms_sql.define_column( p_select_c, 16, p_select_rec.currency_conversion_date,12);
1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);
1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);
1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);
1123: dbms_sql.define_column( p_select_c, 21, p_select_rec.br_unpaid_ccid);
1124:
1125: print_fcn_label2( 'arp_auto_accounting_br.define_columns()-' );
1126: EXCEPTION

Line 1123: dbms_sql.define_column( p_select_c, 21, p_select_rec.br_unpaid_ccid);

1119: dbms_sql.define_column( p_select_c, 17, p_select_rec.receipt_method_id);
1120: dbms_sql.define_column( p_select_c, 18, p_select_rec.bank_account_id);
1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);
1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);
1123: dbms_sql.define_column( p_select_c, 21, p_select_rec.br_unpaid_ccid);
1124:
1125: print_fcn_label2( 'arp_auto_accounting_br.define_columns()-' );
1126: EXCEPTION
1127: WHEN OTHERS THEN

Line 2081: dbms_sql.bind_variable( ccid_reader_c, 'ccid',

2077: BEGIN
2078:
2079: -- loop: bind variables
2080: -- fetch
2081: dbms_sql.bind_variable( ccid_reader_c, 'ccid',
2082: l_ccid );
2083:
2084: dbms_sql.define_column( ccid_reader_c, 1, l_detail_posting_flag, 1 );
2085: dbms_sql.define_column( ccid_reader_c, 2, l_summary_flag, 1 );

Line 2084: dbms_sql.define_column( ccid_reader_c, 1, l_detail_posting_flag, 1 );

2080: -- fetch
2081: dbms_sql.bind_variable( ccid_reader_c, 'ccid',
2082: l_ccid );
2083:
2084: dbms_sql.define_column( ccid_reader_c, 1, l_detail_posting_flag, 1 );
2085: dbms_sql.define_column( ccid_reader_c, 2, l_summary_flag, 1 );
2086:
2087: EXCEPTION
2088: WHEN OTHERS THEN

Line 2085: dbms_sql.define_column( ccid_reader_c, 2, l_summary_flag, 1 );

2081: dbms_sql.bind_variable( ccid_reader_c, 'ccid',
2082: l_ccid );
2083:
2084: dbms_sql.define_column( ccid_reader_c, 1, l_detail_posting_flag, 1 );
2085: dbms_sql.define_column( ccid_reader_c, 2, l_summary_flag, 1 );
2086:
2087: EXCEPTION
2088: WHEN OTHERS THEN
2089: debug( 'Error in binding ccid_reader', MSG_LEVEL_BASIC );

Line 2096: l_ignore := dbms_sql.execute( ccid_reader_c );

2092: END;
2093:
2094: BEGIN
2095:
2096: l_ignore := dbms_sql.execute( ccid_reader_c );
2097:
2098: IF dbms_sql.fetch_rows( ccid_reader_c ) > 0 THEN
2099:
2100: dbms_sql.column_value( ccid_reader_c, 1, l_detail_posting_flag );

Line 2098: IF dbms_sql.fetch_rows( ccid_reader_c ) > 0 THEN

2094: BEGIN
2095:
2096: l_ignore := dbms_sql.execute( ccid_reader_c );
2097:
2098: IF dbms_sql.fetch_rows( ccid_reader_c ) > 0 THEN
2099:
2100: dbms_sql.column_value( ccid_reader_c, 1, l_detail_posting_flag );
2101: dbms_sql.column_value( ccid_reader_c, 2, l_summary_flag );
2102:

Line 2100: dbms_sql.column_value( ccid_reader_c, 1, l_detail_posting_flag );

2096: l_ignore := dbms_sql.execute( ccid_reader_c );
2097:
2098: IF dbms_sql.fetch_rows( ccid_reader_c ) > 0 THEN
2099:
2100: dbms_sql.column_value( ccid_reader_c, 1, l_detail_posting_flag );
2101: dbms_sql.column_value( ccid_reader_c, 2, l_summary_flag );
2102:
2103: IF( l_detail_posting_flag = NO ) THEN
2104:

Line 2101: dbms_sql.column_value( ccid_reader_c, 2, l_summary_flag );

2097:
2098: IF dbms_sql.fetch_rows( ccid_reader_c ) > 0 THEN
2099:
2100: dbms_sql.column_value( ccid_reader_c, 1, l_detail_posting_flag );
2101: dbms_sql.column_value( ccid_reader_c, 2, l_summary_flag );
2102:
2103: IF( l_detail_posting_flag = NO ) THEN
2104:
2105: g_error_buffer := MSG_FLEX_POSTING_NOT_ALLOWED;

Line 2353: l_select_c := dbms_sql.open_cursor;

2349: l_cache_index BINARY_INTEGER;
2350:
2351: BEGIN
2352:
2353: l_select_c := dbms_sql.open_cursor;
2354:
2355: l_cache_index := cursor_attr_cache.count + 1;
2356:
2357: /*----------------------------------------------------+

Line 2386: dbms_sql.parse( l_select_c, l_select_stmt, dbms_sql.v7);

2382: -- Parse
2383: ------------------------------------------------------------
2384: debug( ' Parsing select stmt', MSG_LEVEL_DEBUG );
2385:
2386: dbms_sql.parse( l_select_c, l_select_stmt, dbms_sql.v7);
2387:
2388:
2389: ------------------------------------------------------------
2390: -- Define columns

Line 2451: dbms_sql.bind_variable( p_cursor,

2447: p_bind_variable IN VARCHAR2,
2448: p_value IN VARCHAR2
2449: ) IS
2450: BEGIN
2451: dbms_sql.bind_variable( p_cursor,
2452: p_bind_variable,
2453: p_value );
2454:
2455: EXCEPTION

Line 2469: dbms_sql.bind_variable( p_cursor,

2465: p_bind_variable IN VARCHAR2,
2466: p_value IN INTEGER
2467: ) IS
2468: BEGIN
2469: dbms_sql.bind_variable( p_cursor,
2470: p_bind_variable,
2471: p_value );
2472:
2473: EXCEPTION

Line 2488: dbms_sql.bind_variable( p_cursor,

2484: p_bind_variable IN VARCHAR2,
2485: p_value IN DATE
2486: ) IS
2487: BEGIN
2488: dbms_sql.bind_variable( p_cursor,
2489: p_bind_variable,
2490: p_value );
2491:
2492: EXCEPTION

Line 3067: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );

3063: p_select_rec OUT NOCOPY select_rec_type ) IS
3064: BEGIN
3065: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()+' );
3066:
3067: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);
3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);
3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);

Line 3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);

3064: BEGIN
3065: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()+' );
3066:
3067: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);
3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);
3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);

Line 3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);

3065: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()+' );
3066:
3067: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);
3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);
3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);

Line 3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);

3066:
3067: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);
3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);
3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);

Line 3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);

3067: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);
3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);
3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);

Line 3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);

3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);
3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);
3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);

Line 3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);

3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);
3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);

Line 3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);

3070: dbms_sql.column_value( p_select_c, 4, p_select_rec.drawee_id);
3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);

Line 3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);

3071: dbms_sql.column_value( p_select_c, 5, p_select_rec.bill_to_site_use_id);
3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);

Line 3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);

3072: dbms_sql.column_value( p_select_c, 6, p_select_rec.br_unpaid_flag);
3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);

Line 3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);

3073: dbms_sql.column_value( p_select_c, 7, p_select_rec.transaction_history_id);
3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);

Line 3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);

3074: dbms_sql.column_value( p_select_c, 8, p_select_rec.batch_id);
3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);

Line 3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);

3075: dbms_sql.column_value( p_select_c, 9, p_select_rec.gl_date);
3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);

Line 3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);

3076: dbms_sql.column_value( p_select_c, 10, p_select_rec.source_type);
3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);

Line 3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);

3077: dbms_sql.column_value( p_select_c, 11, p_select_rec.amount);
3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);
3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);

Line 3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);

3078: dbms_sql.column_value( p_select_c, 12, p_select_rec.acctd_amount);
3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);
3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);
3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);

Line 3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);

3079: dbms_sql.column_value( p_select_c, 13, p_select_rec.currency_code);
3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);
3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);
3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);
3087: dbms_sql.column_value( p_select_c, 21, p_select_rec.br_unpaid_ccid);

Line 3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);

3080: dbms_sql.column_value( p_select_c, 14, p_select_rec.currency_conversion_rate);
3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);
3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);
3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);
3087: dbms_sql.column_value( p_select_c, 21, p_select_rec.br_unpaid_ccid);
3088:

Line 3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);

3081: dbms_sql.column_value( p_select_c, 15, p_select_rec.currency_conversion_type);
3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);
3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);
3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);
3087: dbms_sql.column_value( p_select_c, 21, p_select_rec.br_unpaid_ccid);
3088:
3089: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()-' );

Line 3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);

3082: dbms_sql.column_value( p_select_c, 16, p_select_rec.currency_conversion_date);
3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);
3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);
3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);
3087: dbms_sql.column_value( p_select_c, 21, p_select_rec.br_unpaid_ccid);
3088:
3089: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()-' );
3090: EXCEPTION

Line 3087: dbms_sql.column_value( p_select_c, 21, p_select_rec.br_unpaid_ccid);

3083: dbms_sql.column_value( p_select_c, 17, p_select_rec.receipt_method_id);
3084: dbms_sql.column_value( p_select_c, 18, p_select_rec.bank_account_id);
3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);
3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);
3087: dbms_sql.column_value( p_select_c, 21, p_select_rec.br_unpaid_ccid);
3088:
3089: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()-' );
3090: EXCEPTION
3091: WHEN OTHERS THEN

Line 3442: l_delete_c := dbms_sql.open_cursor;

3438: l_delete_stmt VARCHAR2(32767);
3439:
3440: BEGIN
3441:
3442: l_delete_c := dbms_sql.open_cursor;
3443: l_delete_stmt := build_delete_sql( system_info,
3444: profile_info,
3445: p_account_class,
3446: p_customer_trx_id );

Line 3448: dbms_sql.parse( l_delete_c, l_delete_stmt, dbms_sql.v7 );

3444: profile_info,
3445: p_account_class,
3446: p_customer_trx_id );
3447:
3448: dbms_sql.parse( l_delete_c, l_delete_stmt, dbms_sql.v7 );
3449:
3450: EXCEPTION
3451: WHEN OTHERS THEN
3452: debug( 'Error constructing/parsing delete cursor',

Line 3465: l_ignore := dbms_sql.execute( l_delete_c );

3461: ----------------------------------------------------------------
3462: debug( ' Deleting distributions', MSG_LEVEL_DEBUG );
3463:
3464: BEGIN
3465: l_ignore := dbms_sql.execute( l_delete_c );
3466:
3467: debug( to_char(l_ignore) || ' row(s) deleted',
3468: MSG_LEVEL_DEBUG );
3469:

Line 3522: l_ignore := dbms_sql.execute( l_select_c );

3518: BEGIN
3519:
3520: debug( ' Executing select stmt', MSG_LEVEL_DEBUG );
3521:
3522: l_ignore := dbms_sql.execute( l_select_c );
3523:
3524: EXCEPTION
3525: WHEN OTHERS THEN
3526: debug( 'Error executing select cursor', MSG_LEVEL_BASIC );

Line 3541: IF dbms_sql.fetch_rows( l_select_c ) > 0 THEN

3537:
3538:
3539: BEGIN
3540:
3541: IF dbms_sql.fetch_rows( l_select_c ) > 0 THEN
3542:
3543: debug( ' Fetched a row', MSG_LEVEL_DEBUG );
3544:
3545: l_first_fetch := FALSE;

Line 3947: ccid_reader_c := dbms_sql.open_cursor;

3943: BEGIN
3944:
3945: BEGIN
3946:
3947: ccid_reader_c := dbms_sql.open_cursor;
3948:
3949: temp :=
3950: 'SELECT
3951: detail_posting_allowed_flag,

Line 3974: dbms_sql.parse( ccid_reader_c, temp, dbms_sql.v7);

3970: --------------------------------------------------------------------
3971: BEGIN
3972:
3973: debug( 'parsing' );
3974: dbms_sql.parse( ccid_reader_c, temp, dbms_sql.v7);
3975:
3976: EXCEPTION
3977: WHEN OTHERS THEN
3978: debug('Error parsing ccid reader');