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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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
1758: p_select_rec IN select_rec_type) IS
1759: BEGIN
1760: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );
1761:
1762: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1763: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1764: dbms_sql.define_column( p_select_c, 3,
1765: p_select_rec.cust_trx_line_salesrep_id );
1766: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1759: BEGIN
1760: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );
1761:
1762: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1763: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1764: dbms_sql.define_column( p_select_c, 3,
1765: p_select_rec.cust_trx_line_salesrep_id );
1766: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1767: dbms_sql.define_column( p_select_c, 5,
1760: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );
1761:
1762: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1763: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1764: dbms_sql.define_column( p_select_c, 3,
1765: p_select_rec.cust_trx_line_salesrep_id );
1766: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1767: dbms_sql.define_column( p_select_c, 5,
1768: p_select_rec.accounted_line_amount );
1762: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1763: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1764: dbms_sql.define_column( p_select_c, 3,
1765: p_select_rec.cust_trx_line_salesrep_id );
1766: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1767: dbms_sql.define_column( p_select_c, 5,
1768: p_select_rec.accounted_line_amount );
1769: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1763: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1764: dbms_sql.define_column( p_select_c, 3,
1765: p_select_rec.cust_trx_line_salesrep_id );
1766: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1767: dbms_sql.define_column( p_select_c, 5,
1768: p_select_rec.accounted_line_amount );
1769: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1765: p_select_rec.cust_trx_line_salesrep_id );
1766: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1767: dbms_sql.define_column( p_select_c, 5,
1768: p_select_rec.accounted_line_amount );
1769: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1772: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1766: dbms_sql.define_column( p_select_c, 4, p_select_rec.line_amount );
1767: dbms_sql.define_column( p_select_c, 5,
1768: p_select_rec.accounted_line_amount );
1769: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1772: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1774: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1767: dbms_sql.define_column( p_select_c, 5,
1768: p_select_rec.accounted_line_amount );
1769: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1772: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1774: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1775: dbms_sql.define_column( p_select_c, 12,
1768: p_select_rec.accounted_line_amount );
1769: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1772: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1774: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1775: dbms_sql.define_column( p_select_c, 12,
1776: p_select_rec.allow_not_open_flag, 1 );
1769: dbms_sql.define_column( p_select_c, 6, p_select_rec.percent );
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1772: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1774: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1775: dbms_sql.define_column( p_select_c, 12,
1776: p_select_rec.allow_not_open_flag, 1 );
1777: dbms_sql.define_column( p_select_c, 13,
1770: dbms_sql.define_column( p_select_c, 7, p_select_rec.amount );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1772: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1774: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1775: dbms_sql.define_column( p_select_c, 12,
1776: p_select_rec.allow_not_open_flag, 1 );
1777: dbms_sql.define_column( p_select_c, 13,
1778: p_select_rec.concatenated_segments, 240 );
1771: dbms_sql.define_column( p_select_c, 8, p_select_rec.acctd_amount );
1772: dbms_sql.define_column( p_select_c, 9, p_select_rec.account_class, 20 );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1774: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1775: dbms_sql.define_column( p_select_c, 12,
1776: p_select_rec.allow_not_open_flag, 1 );
1777: dbms_sql.define_column( p_select_c, 13,
1778: p_select_rec.concatenated_segments, 240 );
1779: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1773: dbms_sql.define_column( p_select_c, 10, p_select_rec.account_set_flag, 1 );
1774: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
1775: dbms_sql.define_column( p_select_c, 12,
1776: p_select_rec.allow_not_open_flag, 1 );
1777: dbms_sql.define_column( p_select_c, 13,
1778: p_select_rec.concatenated_segments, 240 );
1779: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1780: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1781: dbms_sql.define_column( p_select_c, 16,
1775: dbms_sql.define_column( p_select_c, 12,
1776: p_select_rec.allow_not_open_flag, 1 );
1777: dbms_sql.define_column( p_select_c, 13,
1778: p_select_rec.concatenated_segments, 240 );
1779: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1780: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1781: dbms_sql.define_column( p_select_c, 16,
1782: p_select_rec.original_gl_date, 12 );
1783: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1776: p_select_rec.allow_not_open_flag, 1 );
1777: dbms_sql.define_column( p_select_c, 13,
1778: p_select_rec.concatenated_segments, 240 );
1779: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1780: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1781: dbms_sql.define_column( p_select_c, 16,
1782: p_select_rec.original_gl_date, 12 );
1783: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1784: dbms_sql.define_column( p_select_c, 18,
1777: dbms_sql.define_column( p_select_c, 13,
1778: p_select_rec.concatenated_segments, 240 );
1779: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1780: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1781: dbms_sql.define_column( p_select_c, 16,
1782: p_select_rec.original_gl_date, 12 );
1783: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1784: dbms_sql.define_column( p_select_c, 18,
1785: p_select_rec.ussgl_trx_code_context, 30 );
1779: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1780: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1781: dbms_sql.define_column( p_select_c, 16,
1782: p_select_rec.original_gl_date, 12 );
1783: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1784: dbms_sql.define_column( p_select_c, 18,
1785: p_select_rec.ussgl_trx_code_context, 30 );
1786: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1780: dbms_sql.define_column( p_select_c, 15, p_select_rec.gl_date, 12 );
1781: dbms_sql.define_column( p_select_c, 16,
1782: p_select_rec.original_gl_date, 12 );
1783: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1784: dbms_sql.define_column( p_select_c, 18,
1785: p_select_rec.ussgl_trx_code_context, 30 );
1786: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1782: p_select_rec.original_gl_date, 12 );
1783: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1784: dbms_sql.define_column( p_select_c, 18,
1785: p_select_rec.ussgl_trx_code_context, 30 );
1786: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1789: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1783: dbms_sql.define_column( p_select_c, 17, p_select_rec.ussgl_trx_code, 30 );
1784: dbms_sql.define_column( p_select_c, 18,
1785: p_select_rec.ussgl_trx_code_context, 30 );
1786: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1789: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1791: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1784: dbms_sql.define_column( p_select_c, 18,
1785: p_select_rec.ussgl_trx_code_context, 30 );
1786: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1789: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1791: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1792: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1785: p_select_rec.ussgl_trx_code_context, 30 );
1786: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1789: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1791: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1792: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1793:
1786: dbms_sql.define_column( p_select_c, 19, p_select_rec.salesrep_id );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1789: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1791: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1792: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1793:
1794: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1787: dbms_sql.define_column( p_select_c, 20, p_select_rec.inventory_item_id );
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1789: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1791: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1792: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1793:
1794: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1795: EXCEPTION
1788: dbms_sql.define_column( p_select_c, 21, p_select_rec.memo_line_id );
1789: dbms_sql.define_column( p_select_c, 22, p_select_rec.default_tax_ccid );
1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1791: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1792: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1793:
1794: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1795: EXCEPTION
1796: WHEN OTHERS THEN
1805: p_select_tab IN select_rec_tab) IS
1806: BEGIN
1807: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );
1808:
1809: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1810: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1811: dbms_sql.define_array( p_select_c, 3,
1812: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1813: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1806: BEGIN
1807: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );
1808:
1809: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1810: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1811: dbms_sql.define_array( p_select_c, 3,
1812: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1813: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 5,
1807: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );
1808:
1809: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1810: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1811: dbms_sql.define_array( p_select_c, 3,
1812: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1813: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 5,
1815: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1809: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1810: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1811: dbms_sql.define_array( p_select_c, 3,
1812: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1813: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 5,
1815: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1816: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1810: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1811: dbms_sql.define_array( p_select_c, 3,
1812: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1813: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 5,
1815: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1816: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1812: p_select_tab.cust_trx_line_salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1813: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 5,
1815: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1816: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1819: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1813: dbms_sql.define_array( p_select_c, 4, p_select_tab.line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 5,
1815: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1816: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1819: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1814: dbms_sql.define_array( p_select_c, 5,
1815: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1816: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1819: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 12,
1815: p_select_tab.accounted_line_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1816: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1819: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 12,
1823: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1816: dbms_sql.define_array( p_select_c, 6, p_select_tab.percent, MAX_ARRAY_SIZE, STARTING_INDEX );
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1819: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 12,
1823: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1824: dbms_sql.define_array( p_select_c, 13,
1817: dbms_sql.define_array( p_select_c, 7, p_select_tab.amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1819: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 12,
1823: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1824: dbms_sql.define_array( p_select_c, 13,
1825: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1818: dbms_sql.define_array( p_select_c, 8, p_select_tab.acctd_amount, MAX_ARRAY_SIZE, STARTING_INDEX );
1819: dbms_sql.define_array( p_select_c, 9, p_select_tab.account_class, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 12,
1823: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1824: dbms_sql.define_array( p_select_c, 13,
1825: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1820: dbms_sql.define_array( p_select_c, 10, p_select_tab.account_set_flag, MAX_ARRAY_SIZE, STARTING_INDEX );
1821: dbms_sql.define_array( p_select_c, 11, p_select_tab.cust_trx_type_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1822: dbms_sql.define_array( p_select_c, 12,
1823: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1824: dbms_sql.define_array( p_select_c, 13,
1825: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1827: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1828: dbms_sql.define_array( p_select_c, 16,
1822: dbms_sql.define_array( p_select_c, 12,
1823: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1824: dbms_sql.define_array( p_select_c, 13,
1825: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1827: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1828: dbms_sql.define_array( p_select_c, 16,
1829: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1823: p_select_tab.allow_not_open_flag, MAX_ARRAY_SIZE, STARTING_INDEX);
1824: dbms_sql.define_array( p_select_c, 13,
1825: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1827: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1828: dbms_sql.define_array( p_select_c, 16,
1829: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 18,
1824: dbms_sql.define_array( p_select_c, 13,
1825: p_select_tab.concatenated_segments, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1827: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1828: dbms_sql.define_array( p_select_c, 16,
1829: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 18,
1832: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1826: dbms_sql.define_array( p_select_c, 14, p_select_tab.code_combination_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1827: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1828: dbms_sql.define_array( p_select_c, 16,
1829: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 18,
1832: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1833: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1827: dbms_sql.define_array( p_select_c, 15, p_select_tab.gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1828: dbms_sql.define_array( p_select_c, 16,
1829: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 18,
1832: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1833: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1829: p_select_tab.original_gl_date, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 18,
1832: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1833: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1836: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1830: dbms_sql.define_array( p_select_c, 17, p_select_tab.ussgl_trx_code, MAX_ARRAY_SIZE, STARTING_INDEX );
1831: dbms_sql.define_array( p_select_c, 18,
1832: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1833: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1836: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1831: dbms_sql.define_array( p_select_c, 18,
1832: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1833: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1836: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1839: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1832: p_select_tab.ussgl_trx_code_context, MAX_ARRAY_SIZE, STARTING_INDEX );
1833: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1836: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1839: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1840: -- 1651593
1833: dbms_sql.define_array( p_select_c, 19, p_select_tab.salesrep_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1836: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1839: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1840: -- 1651593
1841: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1834: dbms_sql.define_array( p_select_c, 20, p_select_tab.inventory_item_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1836: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1839: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1840: -- 1651593
1841: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1842:
1835: dbms_sql.define_array( p_select_c, 21, p_select_tab.memo_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1836: dbms_sql.define_array( p_select_c, 22, p_select_tab.default_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1839: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1840: -- 1651593
1841: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1842:
1843: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );
1837: dbms_sql.define_array( p_select_c, 23, p_select_tab.interim_tax_ccid, MAX_ARRAY_SIZE, STARTING_INDEX );
1838: dbms_sql.define_array( p_select_c, 24, p_select_tab.site_use_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1839: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1840: -- 1651593
1841: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1842:
1843: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );
1844: EXCEPTION
1845: WHEN OTHERS THEN
3712: l_cache_index BINARY_INTEGER;
3713:
3714: BEGIN
3715:
3716: l_select_c := dbms_sql.open_cursor;
3717:
3718: l_cache_index := cursor_attr_cache.count + 1;
3719:
3720: /*----------------------------------------------------+
3761: -- Parse
3762: ------------------------------------------------------------
3763: debug( ' Parsing select stmt', MSG_LEVEL_DEBUG );
3764:
3765: dbms_sql.parse( l_select_c, l_select_stmt, dbms_sql.v7);
3766:
3767:
3768: ------------------------------------------------------------
3769: -- Define Column Arrays
3827: p_bind_variable IN VARCHAR2,
3828: p_value IN VARCHAR2
3829: ) IS
3830: BEGIN
3831: dbms_sql.bind_variable( p_cursor,
3832: p_bind_variable,
3833: p_value );
3834:
3835: EXCEPTION
3845: p_bind_variable IN VARCHAR2,
3846: p_value IN INTEGER
3847: ) IS
3848: BEGIN
3849: dbms_sql.bind_variable( p_cursor,
3850: p_bind_variable,
3851: p_value );
3852:
3853: EXCEPTION
3864: p_bind_variable IN VARCHAR2,
3865: p_value IN DATE
3866: ) IS
3867: BEGIN
3868: dbms_sql.bind_variable( p_cursor,
3869: p_bind_variable,
3870: p_value );
3871:
3872: EXCEPTION
4890: p_select_rec OUT NOCOPY select_rec_type ) IS
4891: BEGIN
4892: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4893:
4894: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4895: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4896: dbms_sql.column_value( p_select_c, 3,
4897: p_select_rec.cust_trx_line_salesrep_id );
4898: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4891: BEGIN
4892: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4893:
4894: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4895: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4896: dbms_sql.column_value( p_select_c, 3,
4897: p_select_rec.cust_trx_line_salesrep_id );
4898: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4899: dbms_sql.column_value( p_select_c, 5,
4892: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4893:
4894: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4895: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4896: dbms_sql.column_value( p_select_c, 3,
4897: p_select_rec.cust_trx_line_salesrep_id );
4898: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4899: dbms_sql.column_value( p_select_c, 5,
4900: p_select_rec.accounted_line_amount );
4894: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4895: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4896: dbms_sql.column_value( p_select_c, 3,
4897: p_select_rec.cust_trx_line_salesrep_id );
4898: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4899: dbms_sql.column_value( p_select_c, 5,
4900: p_select_rec.accounted_line_amount );
4901: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4895: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4896: dbms_sql.column_value( p_select_c, 3,
4897: p_select_rec.cust_trx_line_salesrep_id );
4898: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4899: dbms_sql.column_value( p_select_c, 5,
4900: p_select_rec.accounted_line_amount );
4901: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4897: p_select_rec.cust_trx_line_salesrep_id );
4898: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4899: dbms_sql.column_value( p_select_c, 5,
4900: p_select_rec.accounted_line_amount );
4901: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4904: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4898: dbms_sql.column_value( p_select_c, 4, p_select_rec.line_amount );
4899: dbms_sql.column_value( p_select_c, 5,
4900: p_select_rec.accounted_line_amount );
4901: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4904: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4906: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4899: dbms_sql.column_value( p_select_c, 5,
4900: p_select_rec.accounted_line_amount );
4901: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4904: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4906: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4907: dbms_sql.column_value( p_select_c, 12,
4900: p_select_rec.accounted_line_amount );
4901: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4904: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4906: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4907: dbms_sql.column_value( p_select_c, 12,
4908: p_select_rec.allow_not_open_flag );
4901: dbms_sql.column_value( p_select_c, 6, p_select_rec.percent );
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4904: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4906: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4907: dbms_sql.column_value( p_select_c, 12,
4908: p_select_rec.allow_not_open_flag );
4909: dbms_sql.column_value( p_select_c, 13,
4902: dbms_sql.column_value( p_select_c, 7, p_select_rec.amount );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4904: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4906: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4907: dbms_sql.column_value( p_select_c, 12,
4908: p_select_rec.allow_not_open_flag );
4909: dbms_sql.column_value( p_select_c, 13,
4910: p_select_rec.concatenated_segments );
4903: dbms_sql.column_value( p_select_c, 8, p_select_rec.acctd_amount );
4904: dbms_sql.column_value( p_select_c, 9, p_select_rec.account_class );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4906: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4907: dbms_sql.column_value( p_select_c, 12,
4908: p_select_rec.allow_not_open_flag );
4909: dbms_sql.column_value( p_select_c, 13,
4910: p_select_rec.concatenated_segments );
4911: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4905: dbms_sql.column_value( p_select_c, 10, p_select_rec.account_set_flag );
4906: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
4907: dbms_sql.column_value( p_select_c, 12,
4908: p_select_rec.allow_not_open_flag );
4909: dbms_sql.column_value( p_select_c, 13,
4910: p_select_rec.concatenated_segments );
4911: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4912: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4913: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4907: dbms_sql.column_value( p_select_c, 12,
4908: p_select_rec.allow_not_open_flag );
4909: dbms_sql.column_value( p_select_c, 13,
4910: p_select_rec.concatenated_segments );
4911: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4912: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4913: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4914: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4915: dbms_sql.column_value( p_select_c, 18,
4908: p_select_rec.allow_not_open_flag );
4909: dbms_sql.column_value( p_select_c, 13,
4910: p_select_rec.concatenated_segments );
4911: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4912: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4913: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4914: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4915: dbms_sql.column_value( p_select_c, 18,
4916: p_select_rec.ussgl_trx_code_context );
4909: dbms_sql.column_value( p_select_c, 13,
4910: p_select_rec.concatenated_segments );
4911: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4912: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4913: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4914: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4915: dbms_sql.column_value( p_select_c, 18,
4916: p_select_rec.ussgl_trx_code_context );
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4910: p_select_rec.concatenated_segments );
4911: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4912: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4913: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4914: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4915: dbms_sql.column_value( p_select_c, 18,
4916: p_select_rec.ussgl_trx_code_context );
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4911: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
4912: dbms_sql.column_value( p_select_c, 15, p_select_rec.gl_date );
4913: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4914: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4915: dbms_sql.column_value( p_select_c, 18,
4916: p_select_rec.ussgl_trx_code_context );
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4913: dbms_sql.column_value( p_select_c, 16, p_select_rec.original_gl_date );
4914: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4915: dbms_sql.column_value( p_select_c, 18,
4916: p_select_rec.ussgl_trx_code_context );
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4920: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4914: dbms_sql.column_value( p_select_c, 17, p_select_rec.ussgl_trx_code );
4915: dbms_sql.column_value( p_select_c, 18,
4916: p_select_rec.ussgl_trx_code_context );
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4920: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4922: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4915: dbms_sql.column_value( p_select_c, 18,
4916: p_select_rec.ussgl_trx_code_context );
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4920: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4922: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4923: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4916: p_select_rec.ussgl_trx_code_context );
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4920: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4922: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4923: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4924: -- 1651593
4917: dbms_sql.column_value( p_select_c, 19, p_select_rec.salesrep_id );
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4920: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4922: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4923: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4924: -- 1651593
4925: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);
4918: dbms_sql.column_value( p_select_c, 20, p_select_rec.inventory_item_id );
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4920: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4922: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4923: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4924: -- 1651593
4925: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);
4926:
4919: dbms_sql.column_value( p_select_c, 21, p_select_rec.memo_line_id );
4920: dbms_sql.column_value( p_select_c, 22, p_select_rec.default_tax_ccid );
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4922: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4923: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4924: -- 1651593
4925: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);
4926:
4927: /* 5148504 - return null value when interim_tax_ccid comes
4921: dbms_sql.column_value( p_select_c, 23, p_select_rec.interim_tax_ccid );
4922: dbms_sql.column_value( p_select_c, 24, p_select_rec.site_use_id );
4923: dbms_sql.column_value( p_select_c, 25, p_select_rec.warehouse_id );
4924: -- 1651593
4925: dbms_sql.column_value( p_select_c, 26, p_select_rec.link_to_cust_trx_line_id);
4926:
4927: /* 5148504 - return null value when interim_tax_ccid comes
4928: back from SELECT as -1 */
4929: IF p_select_rec.interim_tax_ccid = -1
4945: p_select_tab OUT NOCOPY select_rec_tab ) IS
4946: BEGIN
4947: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
4948:
4949: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
4950: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
4951: dbms_sql.column_value( p_select_c, 3,
4952: p_select_tab.cust_trx_line_salesrep_id );
4953: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
4946: BEGIN
4947: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
4948:
4949: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
4950: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
4951: dbms_sql.column_value( p_select_c, 3,
4952: p_select_tab.cust_trx_line_salesrep_id );
4953: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
4954: dbms_sql.column_value( p_select_c, 5,
4947: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
4948:
4949: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
4950: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
4951: dbms_sql.column_value( p_select_c, 3,
4952: p_select_tab.cust_trx_line_salesrep_id );
4953: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
4954: dbms_sql.column_value( p_select_c, 5,
4955: p_select_tab.accounted_line_amount );
4949: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
4950: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
4951: dbms_sql.column_value( p_select_c, 3,
4952: p_select_tab.cust_trx_line_salesrep_id );
4953: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
4954: dbms_sql.column_value( p_select_c, 5,
4955: p_select_tab.accounted_line_amount );
4956: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4950: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
4951: dbms_sql.column_value( p_select_c, 3,
4952: p_select_tab.cust_trx_line_salesrep_id );
4953: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
4954: dbms_sql.column_value( p_select_c, 5,
4955: p_select_tab.accounted_line_amount );
4956: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4952: p_select_tab.cust_trx_line_salesrep_id );
4953: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
4954: dbms_sql.column_value( p_select_c, 5,
4955: p_select_tab.accounted_line_amount );
4956: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4959: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4953: dbms_sql.column_value( p_select_c, 4, p_select_tab.line_amount );
4954: dbms_sql.column_value( p_select_c, 5,
4955: p_select_tab.accounted_line_amount );
4956: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4959: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4961: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
4954: dbms_sql.column_value( p_select_c, 5,
4955: p_select_tab.accounted_line_amount );
4956: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4959: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4961: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
4962: dbms_sql.column_value( p_select_c, 12,
4955: p_select_tab.accounted_line_amount );
4956: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4959: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4961: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
4962: dbms_sql.column_value( p_select_c, 12,
4963: p_select_tab.allow_not_open_flag );
4956: dbms_sql.column_value( p_select_c, 6, p_select_tab.percent );
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4959: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4961: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
4962: dbms_sql.column_value( p_select_c, 12,
4963: p_select_tab.allow_not_open_flag );
4964: dbms_sql.column_value( p_select_c, 13,
4957: dbms_sql.column_value( p_select_c, 7, p_select_tab.amount );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4959: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4961: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
4962: dbms_sql.column_value( p_select_c, 12,
4963: p_select_tab.allow_not_open_flag );
4964: dbms_sql.column_value( p_select_c, 13,
4965: p_select_tab.concatenated_segments );
4958: dbms_sql.column_value( p_select_c, 8, p_select_tab.acctd_amount );
4959: dbms_sql.column_value( p_select_c, 9, p_select_tab.account_class );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4961: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
4962: dbms_sql.column_value( p_select_c, 12,
4963: p_select_tab.allow_not_open_flag );
4964: dbms_sql.column_value( p_select_c, 13,
4965: p_select_tab.concatenated_segments );
4966: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
4960: dbms_sql.column_value( p_select_c, 10, p_select_tab.account_set_flag );
4961: dbms_sql.column_value( p_select_c, 11, p_select_tab.cust_trx_type_id );
4962: dbms_sql.column_value( p_select_c, 12,
4963: p_select_tab.allow_not_open_flag );
4964: dbms_sql.column_value( p_select_c, 13,
4965: p_select_tab.concatenated_segments );
4966: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
4967: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
4968: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
4962: dbms_sql.column_value( p_select_c, 12,
4963: p_select_tab.allow_not_open_flag );
4964: dbms_sql.column_value( p_select_c, 13,
4965: p_select_tab.concatenated_segments );
4966: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
4967: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
4968: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
4969: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
4970: dbms_sql.column_value( p_select_c, 18,
4963: p_select_tab.allow_not_open_flag );
4964: dbms_sql.column_value( p_select_c, 13,
4965: p_select_tab.concatenated_segments );
4966: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
4967: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
4968: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
4969: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
4970: dbms_sql.column_value( p_select_c, 18,
4971: p_select_tab.ussgl_trx_code_context );
4964: dbms_sql.column_value( p_select_c, 13,
4965: p_select_tab.concatenated_segments );
4966: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
4967: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
4968: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
4969: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
4970: dbms_sql.column_value( p_select_c, 18,
4971: p_select_tab.ussgl_trx_code_context );
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4965: p_select_tab.concatenated_segments );
4966: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
4967: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
4968: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
4969: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
4970: dbms_sql.column_value( p_select_c, 18,
4971: p_select_tab.ussgl_trx_code_context );
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4966: dbms_sql.column_value( p_select_c, 14, p_select_tab.code_combination_id );
4967: dbms_sql.column_value( p_select_c, 15, p_select_tab.gl_date );
4968: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
4969: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
4970: dbms_sql.column_value( p_select_c, 18,
4971: p_select_tab.ussgl_trx_code_context );
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4968: dbms_sql.column_value( p_select_c, 16, p_select_tab.original_gl_date );
4969: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
4970: dbms_sql.column_value( p_select_c, 18,
4971: p_select_tab.ussgl_trx_code_context );
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4975: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4969: dbms_sql.column_value( p_select_c, 17, p_select_tab.ussgl_trx_code );
4970: dbms_sql.column_value( p_select_c, 18,
4971: p_select_tab.ussgl_trx_code_context );
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4975: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4977: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
4970: dbms_sql.column_value( p_select_c, 18,
4971: p_select_tab.ussgl_trx_code_context );
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4975: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4977: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
4978: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
4971: p_select_tab.ussgl_trx_code_context );
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4975: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4977: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
4978: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
4979: -- 1651593
4972: dbms_sql.column_value( p_select_c, 19, p_select_tab.salesrep_id );
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4975: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4977: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
4978: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
4979: -- 1651593
4980: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
4973: dbms_sql.column_value( p_select_c, 20, p_select_tab.inventory_item_id );
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4975: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4977: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
4978: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
4979: -- 1651593
4980: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
4981:
4974: dbms_sql.column_value( p_select_c, 21, p_select_tab.memo_line_id );
4975: dbms_sql.column_value( p_select_c, 22, p_select_tab.default_tax_ccid );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4977: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
4978: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
4979: -- 1651593
4980: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
4981:
4982: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );
4976: dbms_sql.column_value( p_select_c, 23, p_select_tab.interim_tax_ccid );
4977: dbms_sql.column_value( p_select_c, 24, p_select_tab.site_use_id );
4978: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
4979: -- 1651593
4980: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
4981:
4982: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );
4983: EXCEPTION
4984: WHEN OTHERS THEN
5761:
5762: l_low INTEGER:=0;
5763: l_high INTEGER:=0;
5764:
5765: gl_dist_array dbms_sql.number_table; /* MRC */
5766: l_error_count NUMBER := 0;
5767: BEGIN
5768:
5769: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_internal()+' );
5832: l_delete_stmt VARCHAR2(32767);
5833:
5834: BEGIN
5835:
5836: l_delete_c := dbms_sql.open_cursor;
5837: l_delete_stmt := build_delete_sql( system_info,
5838: profile_info,
5839: p_account_class,
5840: p_customer_trx_id,
5844:
5845: l_delete_stmt := l_delete_stmt ||
5846: ' RETURNING cust_trx_line_gl_dist_id INTO :gl_dist_key_value ';
5847:
5848: dbms_sql.parse( l_delete_c, l_delete_stmt, dbms_sql.v7 );
5849:
5850: /*-----------------------+
5851: | bind output variable |
5852: +-----------------------*/
5849:
5850: /*-----------------------+
5851: | bind output variable |
5852: +-----------------------*/
5853: dbms_sql.bind_array(l_delete_c,':gl_dist_key_value',
5854: gl_dist_array);
5855:
5856:
5857: EXCEPTION
5868: ----------------------------------------------------------------
5869: debug( ' Deleting distributions', MSG_LEVEL_DEBUG );
5870:
5871: BEGIN
5872: l_ignore := dbms_sql.execute( l_delete_c );
5873:
5874: debug( to_char(l_ignore) || ' row(s) deleted',
5875: MSG_LEVEL_DEBUG );
5876:
5878: /*------------------------------------------+
5879: | get RETURNING COLUMN into OUT NOCOPY bind array |
5880: +------------------------------------------*/
5881:
5882: dbms_sql.variable_value( l_delete_c, ':gl_dist_key_value',
5883: gl_dist_array);
5884:
5885: IF PG_DEBUG in ('Y', 'C') THEN
5886: arp_standard.debug('do_autoaccounting: ' || 'before loop for MRC processing...');
6062: debug( ' Executing select stmt', MSG_LEVEL_DEBUG );
6063: --
6064: -- Execute
6065: --
6066: l_ignore := dbms_sql.execute( l_select_c );
6067:
6068: EXCEPTION
6069: WHEN OTHERS THEN
6070: debug( 'Error executing select cursor', MSG_LEVEL_BASIC );
6084: -- Each call to the fetch_rows will fetch MAX_ARRAY_SIZE rows of data
6085: -- If no. of rows are < MAX_ARRAY_SIZE then exit loop after processing.
6086: --
6087:
6088: l_rows_fetched := dbms_sql.fetch_rows( l_select_c );
6089:
6090: l_low := l_high + 1;
6091: l_high:= l_high + l_rows_fetched;
6092: