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

Line 346: customer_trx_id DBMS_SQL.NUMBER_TABLE,

342: -- To hold values fetched from the Select stmt
343: --
344: TYPE select_rec_tab IS RECORD
345: (
346: customer_trx_id DBMS_SQL.NUMBER_TABLE,
347: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,
349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,

Line 347: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,

343: --
344: TYPE select_rec_tab IS RECORD
345: (
346: customer_trx_id DBMS_SQL.NUMBER_TABLE,
347: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,
349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,

Line 348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,

344: TYPE select_rec_tab IS RECORD
345: (
346: customer_trx_id DBMS_SQL.NUMBER_TABLE,
347: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,
349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,

Line 349: line_amount DBMS_SQL.NUMBER_TABLE,

345: (
346: customer_trx_id DBMS_SQL.NUMBER_TABLE,
347: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,
349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,

Line 350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,

346: customer_trx_id DBMS_SQL.NUMBER_TABLE,
347: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,
349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,

Line 351: percent DBMS_SQL.NUMBER_TABLE,

347: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,
349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,

Line 352: amount DBMS_SQL.NUMBER_TABLE,

348: cust_trx_line_salesrep_id DBMS_SQL.NUMBER_TABLE,
349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,

Line 353: acctd_amount DBMS_SQL.NUMBER_TABLE,

349: line_amount DBMS_SQL.NUMBER_TABLE,
350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,

Line 354: account_class DBMS_SQL.VARCHAR2_TABLE,

350: accounted_line_amount DBMS_SQL.NUMBER_TABLE,
351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,

Line 355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,

351: percent DBMS_SQL.NUMBER_TABLE,
352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,

Line 356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,

352: amount DBMS_SQL.NUMBER_TABLE,
353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format

Line 357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,

353: acctd_amount DBMS_SQL.NUMBER_TABLE,
354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format

Line 358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,

354: account_class DBMS_SQL.VARCHAR2_TABLE,
355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,

Line 359: code_combination_id DBMS_SQL.NUMBER_TABLE,

355: account_set_flag DBMS_SQL.VARCHAR2_TABLE,
356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,

Line 360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format

356: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,

Line 361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format

357: allow_not_open_flag DBMS_SQL.VARCHAR2_TABLE,
358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,

Line 362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,

358: concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,

Line 363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,

359: code_combination_id DBMS_SQL.NUMBER_TABLE,
360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,

Line 364: salesrep_id DBMS_SQL.NUMBER_TABLE,

360: gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,

Line 365: inventory_item_id DBMS_SQL.NUMBER_TABLE,

361: original_gl_date DBMS_SQL.VARCHAR2_TABLE, -- Julian format
362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,

Line 366: memo_line_id DBMS_SQL.NUMBER_TABLE,

362: ussgl_trx_code DBMS_SQL.VARCHAR2_TABLE,
363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,

Line 367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,

363: ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,
371: site_use_id DBMS_SQL.NUMBER_TABLE,

Line 368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,

364: salesrep_id DBMS_SQL.NUMBER_TABLE,
365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,
371: site_use_id DBMS_SQL.NUMBER_TABLE,
372: warehouse_id DBMS_SQL.NUMBER_TABLE,

Line 369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,

365: inventory_item_id DBMS_SQL.NUMBER_TABLE,
366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,
371: site_use_id DBMS_SQL.NUMBER_TABLE,
372: warehouse_id DBMS_SQL.NUMBER_TABLE,
373: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE -- 1651593

Line 370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,

366: memo_line_id DBMS_SQL.NUMBER_TABLE,
367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,
371: site_use_id DBMS_SQL.NUMBER_TABLE,
372: warehouse_id DBMS_SQL.NUMBER_TABLE,
373: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE -- 1651593
374: );

Line 371: site_use_id DBMS_SQL.NUMBER_TABLE,

367: default_tax_ccid DBMS_SQL.NUMBER_TABLE,
368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,
371: site_use_id DBMS_SQL.NUMBER_TABLE,
372: warehouse_id DBMS_SQL.NUMBER_TABLE,
373: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE -- 1651593
374: );
375:

Line 372: warehouse_id DBMS_SQL.NUMBER_TABLE,

368: interim_tax_ccid DBMS_SQL.NUMBER_TABLE,
369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,
371: site_use_id DBMS_SQL.NUMBER_TABLE,
372: warehouse_id DBMS_SQL.NUMBER_TABLE,
373: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE -- 1651593
374: );
375:
376: g_select_rec_tab select_rec_tab;

Line 373: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE -- 1651593

369: int_concatenated_segments DBMS_SQL.VARCHAR2_TABLE,
370: int_code_combination_id DBMS_SQL.NUMBER_TABLE,
371: site_use_id DBMS_SQL.NUMBER_TABLE,
372: warehouse_id DBMS_SQL.NUMBER_TABLE,
373: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE -- 1651593
374: );
375:
376: g_select_rec_tab select_rec_tab;
377: /* Bug-2178723 : Cached the values of detail_posting_allowed_flag and summary_flag

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

1762: p_select_rec IN select_rec_type) IS
1763: BEGIN
1764: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );
1765:
1766: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1767: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1768: dbms_sql.define_column( p_select_c, 3,
1769: p_select_rec.cust_trx_line_salesrep_id );
1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );

Line 1767: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );

1763: BEGIN
1764: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );
1765:
1766: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1767: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1768: dbms_sql.define_column( p_select_c, 3,
1769: p_select_rec.cust_trx_line_salesrep_id );
1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1771: dbms_sql.define_column( p_select_c, 5,

Line 1768: dbms_sql.define_column( p_select_c, 3,

1764: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );
1765:
1766: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1767: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1768: dbms_sql.define_column( p_select_c, 3,
1769: p_select_rec.cust_trx_line_salesrep_id );
1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1771: dbms_sql.define_column( p_select_c, 5,
1772: p_select_rec.accounted_line_amount );

Line 1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );

1766: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1767: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1768: dbms_sql.define_column( p_select_c, 3,
1769: p_select_rec.cust_trx_line_salesrep_id );
1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1771: dbms_sql.define_column( p_select_c, 5,
1772: p_select_rec.accounted_line_amount );
1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );

Line 1771: dbms_sql.define_column( p_select_c, 5,

1767: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1768: dbms_sql.define_column( p_select_c, 3,
1769: p_select_rec.cust_trx_line_salesrep_id );
1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1771: dbms_sql.define_column( p_select_c, 5,
1772: p_select_rec.accounted_line_amount );
1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );

Line 1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );

1769: p_select_rec.cust_trx_line_salesrep_id );
1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1771: dbms_sql.define_column( p_select_c, 5,
1772: p_select_rec.accounted_line_amount );
1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );

Line 1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );

1770: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1771: dbms_sql.define_column( p_select_c, 5,
1772: p_select_rec.accounted_line_amount );
1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );

Line 1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );

1771: dbms_sql.define_column( p_select_c, 5,
1772: p_select_rec.accounted_line_amount );
1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1779: dbms_sql.define_column( p_select_c, 12,

Line 1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );

1772: p_select_rec.accounted_line_amount );
1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1779: dbms_sql.define_column( p_select_c, 12,
1780: p_select_rec.allow_not_open_flag, 1 );

Line 1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );

1773: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1779: dbms_sql.define_column( p_select_c, 12,
1780: p_select_rec.allow_not_open_flag, 1 );
1781: dbms_sql.define_column( p_select_c, 13,

Line 1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );

1774: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1779: dbms_sql.define_column( p_select_c, 12,
1780: p_select_rec.allow_not_open_flag, 1 );
1781: dbms_sql.define_column( p_select_c, 13,
1782: p_select_rec.concatenated_segments, 240 );

Line 1779: dbms_sql.define_column( p_select_c, 12,

1775: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1776: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1779: dbms_sql.define_column( p_select_c, 12,
1780: p_select_rec.allow_not_open_flag, 1 );
1781: dbms_sql.define_column( p_select_c, 13,
1782: p_select_rec.concatenated_segments, 240 );
1783: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );

Line 1781: dbms_sql.define_column( p_select_c, 13,

1777: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1778: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1779: dbms_sql.define_column( p_select_c, 12,
1780: p_select_rec.allow_not_open_flag, 1 );
1781: dbms_sql.define_column( p_select_c, 13,
1782: p_select_rec.concatenated_segments, 240 );
1783: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1784: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1785: dbms_sql.define_column( p_select_c, 16,

Line 1783: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );

1779: dbms_sql.define_column( p_select_c, 12,
1780: p_select_rec.allow_not_open_flag, 1 );
1781: dbms_sql.define_column( p_select_c, 13,
1782: p_select_rec.concatenated_segments, 240 );
1783: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1784: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1785: dbms_sql.define_column( p_select_c, 16,
1786: p_select_rec.original_gl_date, 12 );
1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );

Line 1784: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );

1780: p_select_rec.allow_not_open_flag, 1 );
1781: dbms_sql.define_column( p_select_c, 13,
1782: p_select_rec.concatenated_segments, 240 );
1783: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1784: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1785: dbms_sql.define_column( p_select_c, 16,
1786: p_select_rec.original_gl_date, 12 );
1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1788: dbms_sql.define_column( p_select_c, 18,

Line 1785: dbms_sql.define_column( p_select_c, 16,

1781: dbms_sql.define_column( p_select_c, 13,
1782: p_select_rec.concatenated_segments, 240 );
1783: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1784: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1785: dbms_sql.define_column( p_select_c, 16,
1786: p_select_rec.original_gl_date, 12 );
1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1788: dbms_sql.define_column( p_select_c, 18,
1789: p_select_rec.ussgl_trx_code_context, 30 );

Line 1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );

1783: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1784: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1785: dbms_sql.define_column( p_select_c, 16,
1786: p_select_rec.original_gl_date, 12 );
1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1788: dbms_sql.define_column( p_select_c, 18,
1789: p_select_rec.ussgl_trx_code_context, 30 );
1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );

Line 1788: dbms_sql.define_column( p_select_c, 18,

1784: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1785: dbms_sql.define_column( p_select_c, 16,
1786: p_select_rec.original_gl_date, 12 );
1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1788: dbms_sql.define_column( p_select_c, 18,
1789: p_select_rec.ussgl_trx_code_context, 30 );
1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );

Line 1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );

1786: p_select_rec.original_gl_date, 12 );
1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1788: dbms_sql.define_column( p_select_c, 18,
1789: p_select_rec.ussgl_trx_code_context, 30 );
1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );

Line 1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );

1787: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1788: dbms_sql.define_column( p_select_c, 18,
1789: p_select_rec.ussgl_trx_code_context, 30 );
1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1795: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);

Line 1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );

1788: dbms_sql.define_column( p_select_c, 18,
1789: p_select_rec.ussgl_trx_code_context, 30 );
1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1795: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1796: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);

Line 1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );

1789: p_select_rec.ussgl_trx_code_context, 30 );
1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1795: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1796: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1797:

Line 1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );

1790: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1795: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1796: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1797:
1798: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );

Line 1795: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);

1791: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1795: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1796: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1797:
1798: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1799: EXCEPTION

Line 1796: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);

1792: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1793: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1794: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1795: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1796: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1797:
1798: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1799: EXCEPTION
1800: WHEN OTHERS THEN

Line 1813: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1809: p_select_tab IN select_rec_tab) IS
1810: BEGIN
1811: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );
1812:
1813: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1815: dbms_sql.define_array( p_select_c, 3,
1816: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1814: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1810: BEGIN
1811: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );
1812:
1813: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1815: dbms_sql.define_array( p_select_c, 3,
1816: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 5,

Line 1815: dbms_sql.define_array( p_select_c, 3,

1811: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );
1812:
1813: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1815: dbms_sql.define_array( p_select_c, 3,
1816: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 5,
1819: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );

1813: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1815: dbms_sql.define_array( p_select_c, 3,
1816: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 5,
1819: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1818: dbms_sql.define_array( p_select_c, 5,

1814: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1815: dbms_sql.define_array( p_select_c, 3,
1816: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 5,
1819: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );

1816: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 5,
1819: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );

1817: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 5,
1819: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );

1818: dbms_sql.define_array( p_select_c, 5,
1819: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 12,

Line 1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );

1819: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 12,
1827: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);

Line 1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );

1820: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 12,
1827: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1828: dbms_sql.define_array( p_select_c, 13,

Line 1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1821: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 12,
1827: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1828: dbms_sql.define_array( p_select_c, 13,
1829: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1826: dbms_sql.define_array( p_select_c, 12,

1822: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 12,
1827: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1828: dbms_sql.define_array( p_select_c, 13,
1829: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1828: dbms_sql.define_array( p_select_c, 13,

1824: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1825: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 12,
1827: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1828: dbms_sql.define_array( p_select_c, 13,
1829: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1832: dbms_sql.define_array( p_select_c, 16,

Line 1830: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1826: dbms_sql.define_array( p_select_c, 12,
1827: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1828: dbms_sql.define_array( p_select_c, 13,
1829: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1832: dbms_sql.define_array( p_select_c, 16,
1833: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1831: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );

1827: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1828: dbms_sql.define_array( p_select_c, 13,
1829: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1832: dbms_sql.define_array( p_select_c, 16,
1833: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 18,

Line 1832: dbms_sql.define_array( p_select_c, 16,

1828: dbms_sql.define_array( p_select_c, 13,
1829: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1832: dbms_sql.define_array( p_select_c, 16,
1833: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 18,
1836: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );

1830: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1832: dbms_sql.define_array( p_select_c, 16,
1833: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 18,
1836: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1835: dbms_sql.define_array( p_select_c, 18,

1831: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1832: dbms_sql.define_array( p_select_c, 16,
1833: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 18,
1836: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1833: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 18,
1836: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1834: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 18,
1836: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);

Line 1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1835: dbms_sql.define_array( p_select_c, 18,
1836: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1843: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);

Line 1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );

1836: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1843: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1844: -- 1651593

Line 1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );

1837: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1843: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1844: -- 1651593
1845: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );

Line 1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);

1838: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1843: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1844: -- 1651593
1845: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1846:

Line 1843: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);

1839: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1840: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1843: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1844: -- 1651593
1845: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1846:
1847: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );

Line 1845: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );

1841: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1842: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1843: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1844: -- 1651593
1845: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1846:
1847: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );
1848: EXCEPTION
1849: WHEN OTHERS THEN

Line 3741: l_select_c := dbms_sql.open_cursor;

3737: l_cache_index BINARY_INTEGER;
3738:
3739: BEGIN
3740:
3741: l_select_c := dbms_sql.open_cursor;
3742:
3743: l_cache_index := cursor_attr_cache.count + 1;
3744:
3745: /*----------------------------------------------------+

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

3787: -- Parse
3788: ------------------------------------------------------------
3789: debug( ' Parsing select stmt', MSG_LEVEL_DEBUG );
3790:
3791: dbms_sql.parse( l_select_c, l_select_stmt, dbms_sql.v7);
3792:
3793:
3794: ------------------------------------------------------------
3795: -- Define Column Arrays

Line 3857: dbms_sql.bind_variable( p_cursor,

3853: p_bind_variable IN VARCHAR2,
3854: p_value IN VARCHAR2
3855: ) IS
3856: BEGIN
3857: dbms_sql.bind_variable( p_cursor,
3858: p_bind_variable,
3859: p_value );
3860:
3861: EXCEPTION

Line 3875: dbms_sql.bind_variable( p_cursor,

3871: p_bind_variable IN VARCHAR2,
3872: p_value IN INTEGER
3873: ) IS
3874: BEGIN
3875: dbms_sql.bind_variable( p_cursor,
3876: p_bind_variable,
3877: p_value );
3878:
3879: EXCEPTION

Line 3894: dbms_sql.bind_variable( p_cursor,

3890: p_bind_variable IN VARCHAR2,
3891: p_value IN DATE
3892: ) IS
3893: BEGIN
3894: dbms_sql.bind_variable( p_cursor,
3895: p_bind_variable,
3896: p_value );
3897:
3898: EXCEPTION

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

4954: p_select_rec OUT NOCOPY select_rec_type ) IS
4955: BEGIN
4956: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4957:
4958: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4959: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4960: dbms_sql.column_value( p_select_c, 3,
4961: p_select_rec.cust_trx_line_salesrep_id );
4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );

Line 4959: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );

4955: BEGIN
4956: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4957:
4958: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4959: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4960: dbms_sql.column_value( p_select_c, 3,
4961: p_select_rec.cust_trx_line_salesrep_id );
4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4963: dbms_sql.column_value( p_select_c, 5,

Line 4960: dbms_sql.column_value( p_select_c, 3,

4956: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4957:
4958: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4959: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4960: dbms_sql.column_value( p_select_c, 3,
4961: p_select_rec.cust_trx_line_salesrep_id );
4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4963: dbms_sql.column_value( p_select_c, 5,
4964: p_select_rec.accounted_line_amount );

Line 4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );

4958: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4959: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4960: dbms_sql.column_value( p_select_c, 3,
4961: p_select_rec.cust_trx_line_salesrep_id );
4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4963: dbms_sql.column_value( p_select_c, 5,
4964: p_select_rec.accounted_line_amount );
4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );

Line 4963: dbms_sql.column_value( p_select_c, 5,

4959: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4960: dbms_sql.column_value( p_select_c, 3,
4961: p_select_rec.cust_trx_line_salesrep_id );
4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4963: dbms_sql.column_value( p_select_c, 5,
4964: p_select_rec.accounted_line_amount );
4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );

Line 4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );

4961: p_select_rec.cust_trx_line_salesrep_id );
4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4963: dbms_sql.column_value( p_select_c, 5,
4964: p_select_rec.accounted_line_amount );
4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );

Line 4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );

4962: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4963: dbms_sql.column_value( p_select_c, 5,
4964: p_select_rec.accounted_line_amount );
4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );

Line 4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );

4963: dbms_sql.column_value( p_select_c, 5,
4964: p_select_rec.accounted_line_amount );
4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4971: dbms_sql.column_value( p_select_c, 12,

Line 4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );

4964: p_select_rec.accounted_line_amount );
4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4971: dbms_sql.column_value( p_select_c, 12,
4972: p_select_rec.allow_not_open_flag );

Line 4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );

4965: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4971: dbms_sql.column_value( p_select_c, 12,
4972: p_select_rec.allow_not_open_flag );
4973: dbms_sql.column_value( p_select_c, 13,

Line 4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );

4966: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4971: dbms_sql.column_value( p_select_c, 12,
4972: p_select_rec.allow_not_open_flag );
4973: dbms_sql.column_value( p_select_c, 13,
4974: p_select_rec.concatenated_segments );

Line 4971: dbms_sql.column_value( p_select_c, 12,

4967: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4968: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4971: dbms_sql.column_value( p_select_c, 12,
4972: p_select_rec.allow_not_open_flag );
4973: dbms_sql.column_value( p_select_c, 13,
4974: p_select_rec.concatenated_segments );
4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );

Line 4973: dbms_sql.column_value( p_select_c, 13,

4969: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4970: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4971: dbms_sql.column_value( p_select_c, 12,
4972: p_select_rec.allow_not_open_flag );
4973: dbms_sql.column_value( p_select_c, 13,
4974: p_select_rec.concatenated_segments );
4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4976: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );

Line 4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );

4971: dbms_sql.column_value( p_select_c, 12,
4972: p_select_rec.allow_not_open_flag );
4973: dbms_sql.column_value( p_select_c, 13,
4974: p_select_rec.concatenated_segments );
4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4976: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4979: dbms_sql.column_value( p_select_c, 18,

Line 4976: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );

4972: p_select_rec.allow_not_open_flag );
4973: dbms_sql.column_value( p_select_c, 13,
4974: p_select_rec.concatenated_segments );
4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4976: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4979: dbms_sql.column_value( p_select_c, 18,
4980: p_select_rec.ussgl_trx_code_context );

Line 4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );

4973: dbms_sql.column_value( p_select_c, 13,
4974: p_select_rec.concatenated_segments );
4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4976: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4979: dbms_sql.column_value( p_select_c, 18,
4980: p_select_rec.ussgl_trx_code_context );
4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );

Line 4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );

4974: p_select_rec.concatenated_segments );
4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4976: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4979: dbms_sql.column_value( p_select_c, 18,
4980: p_select_rec.ussgl_trx_code_context );
4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );

Line 4979: dbms_sql.column_value( p_select_c, 18,

4975: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4976: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4979: dbms_sql.column_value( p_select_c, 18,
4980: p_select_rec.ussgl_trx_code_context );
4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );

Line 4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );

4977: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4979: dbms_sql.column_value( p_select_c, 18,
4980: p_select_rec.ussgl_trx_code_context );
4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );

Line 4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );

4978: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4979: dbms_sql.column_value( p_select_c, 18,
4980: p_select_rec.ussgl_trx_code_context );
4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );

Line 4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );

4979: dbms_sql.column_value( p_select_c, 18,
4980: p_select_rec.ussgl_trx_code_context );
4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4987: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );

Line 4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );

4980: p_select_rec.ussgl_trx_code_context );
4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4987: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4988: -- 1651593

Line 4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );

4981: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4987: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4988: -- 1651593
4989: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);

Line 4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );

4982: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4987: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4988: -- 1651593
4989: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);
4990:

Line 4987: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );

4983: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4984: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4987: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4988: -- 1651593
4989: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);
4990:
4991: /* 5148504 - return null value when interim_tax_ccid comes

Line 4989: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);

4985: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4986: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4987: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4988: -- 1651593
4989: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);
4990:
4991: /* 5148504 - return null value when interim_tax_ccid comes
4992: back from SELECT as -1 */
4993: IF p_select_rec.interim_tax_ccid = -1

Line 5013: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );

5009: p_select_tab OUT NOCOPY select_rec_tab ) IS
5010: BEGIN
5011: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
5012:
5013: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
5014: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
5015: dbms_sql.column_value( p_select_c, 3,
5016: p_select_tab.cust_trx_line_salesrep_id );
5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );

Line 5014: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );

5010: BEGIN
5011: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
5012:
5013: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
5014: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
5015: dbms_sql.column_value( p_select_c, 3,
5016: p_select_tab.cust_trx_line_salesrep_id );
5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
5018: dbms_sql.column_value( p_select_c, 5,

Line 5015: dbms_sql.column_value( p_select_c, 3,

5011: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
5012:
5013: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
5014: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
5015: dbms_sql.column_value( p_select_c, 3,
5016: p_select_tab.cust_trx_line_salesrep_id );
5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
5018: dbms_sql.column_value( p_select_c, 5,
5019: p_select_tab.accounted_line_amount );

Line 5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );

5013: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
5014: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
5015: dbms_sql.column_value( p_select_c, 3,
5016: p_select_tab.cust_trx_line_salesrep_id );
5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
5018: dbms_sql.column_value( p_select_c, 5,
5019: p_select_tab.accounted_line_amount );
5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );

Line 5018: dbms_sql.column_value( p_select_c, 5,

5014: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
5015: dbms_sql.column_value( p_select_c, 3,
5016: p_select_tab.cust_trx_line_salesrep_id );
5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
5018: dbms_sql.column_value( p_select_c, 5,
5019: p_select_tab.accounted_line_amount );
5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );

Line 5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );

5016: p_select_tab.cust_trx_line_salesrep_id );
5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
5018: dbms_sql.column_value( p_select_c, 5,
5019: p_select_tab.accounted_line_amount );
5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );

Line 5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );

5017: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
5018: dbms_sql.column_value( p_select_c, 5,
5019: p_select_tab.accounted_line_amount );
5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );

Line 5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );

5018: dbms_sql.column_value( p_select_c, 5,
5019: p_select_tab.accounted_line_amount );
5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
5026: dbms_sql.column_value( p_select_c, 12,

Line 5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );

5019: p_select_tab.accounted_line_amount );
5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
5026: dbms_sql.column_value( p_select_c, 12,
5027: p_select_tab.allow_not_open_flag );

Line 5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );

5020: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
5026: dbms_sql.column_value( p_select_c, 12,
5027: p_select_tab.allow_not_open_flag );
5028: dbms_sql.column_value( p_select_c, 13,

Line 5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );

5021: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
5026: dbms_sql.column_value( p_select_c, 12,
5027: p_select_tab.allow_not_open_flag );
5028: dbms_sql.column_value( p_select_c, 13,
5029: p_select_tab.concatenated_segments );

Line 5026: dbms_sql.column_value( p_select_c, 12,

5022: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
5023: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
5026: dbms_sql.column_value( p_select_c, 12,
5027: p_select_tab.allow_not_open_flag );
5028: dbms_sql.column_value( p_select_c, 13,
5029: p_select_tab.concatenated_segments );
5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );

Line 5028: dbms_sql.column_value( p_select_c, 13,

5024: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
5025: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
5026: dbms_sql.column_value( p_select_c, 12,
5027: p_select_tab.allow_not_open_flag );
5028: dbms_sql.column_value( p_select_c, 13,
5029: p_select_tab.concatenated_segments );
5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
5031: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );

Line 5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );

5026: dbms_sql.column_value( p_select_c, 12,
5027: p_select_tab.allow_not_open_flag );
5028: dbms_sql.column_value( p_select_c, 13,
5029: p_select_tab.concatenated_segments );
5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
5031: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
5034: dbms_sql.column_value( p_select_c, 18,

Line 5031: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );

5027: p_select_tab.allow_not_open_flag );
5028: dbms_sql.column_value( p_select_c, 13,
5029: p_select_tab.concatenated_segments );
5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
5031: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
5034: dbms_sql.column_value( p_select_c, 18,
5035: p_select_tab.ussgl_trx_code_context );

Line 5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );

5028: dbms_sql.column_value( p_select_c, 13,
5029: p_select_tab.concatenated_segments );
5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
5031: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
5034: dbms_sql.column_value( p_select_c, 18,
5035: p_select_tab.ussgl_trx_code_context );
5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );

Line 5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );

5029: p_select_tab.concatenated_segments );
5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
5031: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
5034: dbms_sql.column_value( p_select_c, 18,
5035: p_select_tab.ussgl_trx_code_context );
5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );

Line 5034: dbms_sql.column_value( p_select_c, 18,

5030: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
5031: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
5034: dbms_sql.column_value( p_select_c, 18,
5035: p_select_tab.ussgl_trx_code_context );
5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );

Line 5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );

5032: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
5034: dbms_sql.column_value( p_select_c, 18,
5035: p_select_tab.ussgl_trx_code_context );
5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );

Line 5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );

5033: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
5034: dbms_sql.column_value( p_select_c, 18,
5035: p_select_tab.ussgl_trx_code_context );
5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );

Line 5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );

5034: dbms_sql.column_value( p_select_c, 18,
5035: p_select_tab.ussgl_trx_code_context );
5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );

Line 5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );

5035: p_select_tab.ussgl_trx_code_context );
5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
5043: -- 1651593

Line 5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );

5036: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
5043: -- 1651593
5044: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);

Line 5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );

5037: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
5043: -- 1651593
5044: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
5045:

Line 5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );

5038: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
5039: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
5043: -- 1651593
5044: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
5045:
5046: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );

Line 5044: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);

5040: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
5041: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
5043: -- 1651593
5044: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
5045:
5046: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );
5047: EXCEPTION
5048: WHEN OTHERS THEN

Line 5830: gl_dist_array dbms_sql.number_table; /* MRC */

5826:
5827: l_low INTEGER:=0;
5828: l_high INTEGER:=0;
5829:
5830: gl_dist_array dbms_sql.number_table; /* MRC */
5831: l_error_count NUMBER := 0;
5832: l_use_unearn_srep_dependency BOOLEAN := FALSE;
5833:
5834: /*9112739*/

Line 5910: l_delete_c := dbms_sql.open_cursor;

5906: l_delete_stmt VARCHAR2(32767);
5907:
5908: BEGIN
5909:
5910: l_delete_c := dbms_sql.open_cursor;
5911: l_delete_stmt := build_delete_sql( system_info,
5912: profile_info,
5913: p_account_class,
5914: p_customer_trx_id,

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

5918:
5919: l_delete_stmt := l_delete_stmt ||
5920: ' RETURNING cust_trx_line_gl_dist_id INTO :gl_dist_key_value ';
5921:
5922: dbms_sql.parse( l_delete_c, l_delete_stmt, dbms_sql.v7 );
5923:
5924: /*-----------------------+
5925: | bind output variable |
5926: +-----------------------*/

Line 5927: dbms_sql.bind_array(l_delete_c,':gl_dist_key_value',

5923:
5924: /*-----------------------+
5925: | bind output variable |
5926: +-----------------------*/
5927: dbms_sql.bind_array(l_delete_c,':gl_dist_key_value',
5928: gl_dist_array);
5929:
5930:
5931: EXCEPTION

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

5942: ----------------------------------------------------------------
5943: debug( ' Deleting distributions', MSG_LEVEL_DEBUG );
5944:
5945: BEGIN
5946: l_ignore := dbms_sql.execute( l_delete_c );
5947:
5948: debug( to_char(l_ignore) || ' row(s) deleted',
5949: MSG_LEVEL_DEBUG );
5950:

Line 5956: dbms_sql.variable_value( l_delete_c, ':gl_dist_key_value',

5952: /*------------------------------------------+
5953: | get RETURNING COLUMN into OUT NOCOPY bind array |
5954: +------------------------------------------*/
5955:
5956: dbms_sql.variable_value( l_delete_c, ':gl_dist_key_value',
5957: gl_dist_array);
5958:
5959: IF PG_DEBUG in ('Y', 'C') THEN
5960: arp_standard.debug('do_autoaccounting: ' || 'before loop for MRC processing...');

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

6170: debug( ' Executing select stmt', MSG_LEVEL_DEBUG );
6171: --
6172: -- Execute
6173: --
6174: l_ignore := dbms_sql.execute( l_select_c );
6175:
6176: EXCEPTION
6177: WHEN OTHERS THEN
6178: debug( 'Error executing select cursor', MSG_LEVEL_BASIC );

Line 6196: l_rows_fetched := dbms_sql.fetch_rows( l_select_c );

6192: -- Each call to the fetch_rows will fetch MAX_ARRAY_SIZE rows of data
6193: -- If no. of rows are < MAX_ARRAY_SIZE then exit loop after processing.
6194: --
6195:
6196: l_rows_fetched := dbms_sql.fetch_rows( l_select_c );
6197:
6198: l_low := l_high + 1;
6199: l_high:= l_high + l_rows_fetched;
6200: