APPS.ARP_MAINTAIN_PS2 dependencies on STANDARD

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

677: nvl(:charge_amt, 0),
678: 0, nvl(:gl_date, :trx_date), null),to_date(''12/31/4712'',''MM/DD/YYYY'')), /* gl_date_closed */
679: nvl(:gl_date, :trx_date),
680: :reversed_cash_receipt_id
681: , :org_id--arp_standard.sysparm.org_id /* SSA changes anuj */
682: )' ;
683:
684: debug(' insert_ps_sql = ' || CRLF ||
685: l_insert_ps_sql || CRLF,

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

1159:
1160: --anuj
1161: dbms_sql.bind_variable( p_insert_ps_c,
1162: 'org_id',
1163: arp_standard.sysparm.org_id /* SSA changes anuj */ );
1164:
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: debug( 'EXCEPTION: Error in binding rule_insert_dist_c',

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

1188: JL_BR_SPED_PKG.SET_TRX_LOCK_STATUS(p_select_rec.customer_trx_id);
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: Exception calling BEGIN JL_BR_SPED_PKG.LOCK_INVOICE_FROM_WORKBENCH.');
1193: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: ' || SQLERRM);
1194: END IF;
1195: END;
1196: END IF;

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

1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: Exception calling BEGIN JL_BR_SPED_PKG.LOCK_INVOICE_FROM_WORKBENCH.');
1193: arp_standard.debug('LOCK_INVOICE_FROM_WORKBENCH: ' || SQLERRM);
1194: END IF;
1195: END;
1196: END IF;
1197:

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

1745: :trx_number,
1746: :trx_date,
1747: nvl(:gl_date, to_date(''12/31/4712'',''MM/DD/YYYY'')), /* gl_date_closed */
1748: :gl_date
1749: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */
1750: )' ;
1751:
1752: debug(' insert_ps_sql = ' || CRLF ||
1753: l_insert_ps_sql || CRLF,

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

2789: p_select_rec.trx_number );
2790: --begin anuj
2791: dbms_sql.bind_variable( p_insert_ps_c,
2792: 'org_id',
2793: arp_standard.sysparm.org_id /* SSA changes anuj */
2794: );
2795: --end anuj
2796:
2797:

Line 2885: arp_standard.sysparm.set_of_books_id );

2881:
2882: dbms_sql.bind_variable(
2883: p_insert_ra_c,
2884: 'set_of_books_id',
2885: arp_standard.sysparm.set_of_books_id );
2886:
2887: dbms_sql.bind_variable( p_insert_ra_c,
2888: 'trx_date',
2889: p_select_rec.trx_date );

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

3775: -1 * :acctd_adj_amount,
3776: -1 * :line_adj_amount,
3777: -1 * :tax_adj_amount,
3778: -1 * :frt_adj_amount
3779: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */
3780: )';
3781:
3782: debug(' insert_adj_sql = ' || CRLF ||
3783: l_insert_adj_sql || CRLF,

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

4490:
4491: --begin anuj
4492: dbms_sql.bind_variable (p_insert_adj_c,
4493: 'org_id',
4494: arp_standard.sysparm.org_id /* SSA changes anuj */);
4495: --end anuj
4496:
4497: EXCEPTION
4498: WHEN OTHERS THEN

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

4705: BEGIN
4706: print_fcn_label2('arp_maintain_ps2.load_tables()+' );
4707:
4708: /* DEBUG */
4709: -- arp_standard.enable_file_debug('/sqlcom/out/omvispt3','ARTEMP2B.log');
4710:
4711: l_ps_id_t( l_table_index ) := p_select_rec.payment_schedule_id;
4712: l_ps_amount_due_rem_t( l_table_index ) :=
4713: p_select_rec.amount_due_remaining;

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

5361: -1 * :acctd_adj_amount,
5362: -1 * :line_adjusted,
5363: -1 * :tax_adjusted,
5364: -1 * :freight_adjusted
5365: ,:org_id --arp_standard.sysparm.org_id /* SSA changes anuj */
5366: )';
5367:
5368: debug(' insert_adj_sql = ' || CRLF ||
5369: l_insert_adj_sql || CRLF,

Line 6322: arp_standard.sysparm.org_id);

6318: p_frt_adj_t(i));
6319: /* anuj: Corrected typo for SSA retrofit */
6320: dbms_sql.bind_variable( p_insert_adj_c,
6321: 'org_id',
6322: arp_standard.sysparm.org_id);
6323:
6324: EXCEPTION
6325: WHEN OTHERS THEN
6326: debug( 'EXCEPTION: Error in binding insert_adj_c',