APPS.ARP_MAINTAIN_PS2 dependencies on ARP_STANDARD

Line 689: , :org_id--arp_standard.sysparm.org_id /* SSA changes anuj */

685: nvl(:charge_amt, 0),
686: 0, nvl(:gl_date, :trx_date), null),to_date(''12/31/4712'',''MM/DD/YYYY'')), /* gl_date_closed */
687: nvl(:gl_date, :trx_date),
688: :reversed_cash_receipt_id
689: , :org_id--arp_standard.sysparm.org_id /* SSA changes anuj */
690: )' ;
691:
692: debug(' insert_ps_sql = ' || CRLF ||
693: l_insert_ps_sql || CRLF,

Line 1171: arp_standard.sysparm.org_id /* SSA changes anuj */ );

1167:
1168: --anuj
1169: dbms_sql.bind_variable( p_insert_ps_c,
1170: 'org_id',
1171: arp_standard.sysparm.org_id /* SSA changes anuj */ );
1172:
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: debug( 'EXCEPTION: Error in binding rule_insert_dist_c',

Line 1200: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: Exception calling BEGIN JL_BR_SPED_PKG.LOCK_INVOICE_FROM_WORKBENCH.');

1196: JL_BR_SPED_PKG.SET_TRX_LOCK_STATUS(p_select_rec.customer_trx_id);
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: Exception calling BEGIN JL_BR_SPED_PKG.LOCK_INVOICE_FROM_WORKBENCH.');
1201: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: ' || SQLERRM);
1202: END IF;
1203: END;
1204: END IF;

Line 1201: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: ' || SQLERRM);

1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: Exception calling BEGIN JL_BR_SPED_PKG.LOCK_INVOICE_FROM_WORKBENCH.');
1201: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: ' || SQLERRM);
1202: END IF;
1203: END;
1204: END IF;
1205:

Line 1757: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */

1753: :trx_number,
1754: :trx_date,
1755: nvl(:gl_date, to_date(''12/31/4712'',''MM/DD/YYYY'')), /* gl_date_closed */
1756: :gl_date
1757: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */
1758: )' ;
1759:
1760: debug(' insert_ps_sql = ' || CRLF ||
1761: l_insert_ps_sql || CRLF,

Line 2801: arp_standard.sysparm.org_id /* SSA changes anuj */

2797: p_select_rec.trx_number );
2798: --begin anuj
2799: dbms_sql.bind_variable( p_insert_ps_c,
2800: 'org_id',
2801: arp_standard.sysparm.org_id /* SSA changes anuj */
2802: );
2803: --end anuj
2804:
2805:

Line 2893: arp_standard.sysparm.set_of_books_id );

2889:
2890: dbms_sql.bind_variable(
2891: p_insert_ra_c,
2892: 'set_of_books_id',
2893: arp_standard.sysparm.set_of_books_id );
2894:
2895: dbms_sql.bind_variable( p_insert_ra_c,
2896: 'trx_date',
2897: p_select_rec.trx_date );

Line 3788: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */

3784: -1 * :acctd_adj_amount,
3785: -1 * :line_adj_amount,
3786: -1 * :tax_adj_amount,
3787: -1 * :frt_adj_amount
3788: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */
3789: )';
3790:
3791: debug(' insert_adj_sql = ' || CRLF ||
3792: l_insert_adj_sql || CRLF,

Line 4503: arp_standard.sysparm.org_id /* SSA changes anuj */);

4499:
4500: --begin anuj
4501: dbms_sql.bind_variable (p_insert_adj_c,
4502: 'org_id',
4503: arp_standard.sysparm.org_id /* SSA changes anuj */);
4504: --end anuj
4505:
4506: EXCEPTION
4507: WHEN OTHERS THEN

Line 4718: -- arp_standard.enable_file_debug('/sqlcom/out/omvispt3','ARTEMP2B.log');

4714: BEGIN
4715: print_fcn_label2('arp_maintain_ps2.load_tables()+' );
4716:
4717: /* DEBUG */
4718: -- arp_standard.enable_file_debug('/sqlcom/out/omvispt3','ARTEMP2B.log');
4719:
4720: l_ps_id_t( l_table_index ) := p_select_rec.payment_schedule_id;
4721: l_ps_amount_due_rem_t( l_table_index ) :=
4722: p_select_rec.amount_due_remaining;

Line 5374: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */

5370: -1 * :acctd_adj_amount,
5371: -1 * :line_adjusted,
5372: -1 * :tax_adjusted,
5373: -1 * :freight_adjusted
5374: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */
5375: )';
5376:
5377: debug(' insert_adj_sql = ' || CRLF ||
5378: l_insert_adj_sql || CRLF,

Line 6331: arp_standard.sysparm.org_id);

6327: p_frt_adj_t(i));
6328: /* anuj: Corrected typo for SSA retrofit */
6329: dbms_sql.bind_variable( p_insert_adj_c,
6330: 'org_id',
6331: arp_standard.sysparm.org_id);
6332:
6333: EXCEPTION
6334: WHEN OTHERS THEN
6335: debug( 'EXCEPTION: Error in binding insert_adj_c',