DBA Data[Home] [Help]

APPS.ARP_PROCESS_LINE dependencies on ARP_CTLGD_PKG

Line 486: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);

482: | o The REC dist |
483: | o The FREIGHT dist |
484: +---------------------------------------------------------*/
485:
486: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);
487:
488: l_dist_rec.account_set_flag := 'N';
489:
490:

Line 502: arp_ctlgd_pkg.update_f_ct_id(l_dist_rec,

498: l_dist_rec.amount := p_trx_amount;
499: l_dist_rec.gl_date := p_gl_date;
500: l_dist_rec.original_gl_date := p_gl_date;
501:
502: arp_ctlgd_pkg.update_f_ct_id(l_dist_rec,
503: p_customer_trx_id,
504: null,
505: null);
506:

Line 1207: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1203: IF ( p_line_rec.previous_customer_trx_id IS NOT NULL AND l_dist_line IS NOT NULL)
1204:
1205: THEN
1206: arp_util.debug('Stamping distributions with the transaction code when entered at line level');
1207: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1208: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1209: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1210:
1211:

Line 1209: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');

1205: THEN
1206: arp_util.debug('Stamping distributions with the transaction code when entered at line level');
1207: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1208: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1209: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1210:
1211:
1212: DECLARE
1213: cursor c1 is select customer_trx_line_id

Line 1221: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1217: BEGIN
1218: open c1;
1219: LOOP
1220: fetch c1 into l_id;
1221: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1222: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1223: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1224: exit when c1%NOTFOUND;
1225: END LOOP;

Line 1223: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');

1219: LOOP
1220: fetch c1 into l_id;
1221: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1222: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1223: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1224: exit when c1%NOTFOUND;
1225: END LOOP;
1226: close c1;
1227: EXCEPTION

Line 1668: arp_ctlgd_pkg.update_amount_f_ctl_id(

1664: END;
1665:
1666: ELSIF l_amount_changed_flag
1667: THEN
1668: arp_ctlgd_pkg.update_amount_f_ctl_id(
1669: p_customer_trx_line_id,
1670: l_new_line_rec.extended_amount,
1671: p_foreign_currency_code,
1672: pg_base_curr_code,

Line 1717: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1713: IF nvl(l_db_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0) <> nvl(p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0)
1714: THEN
1715:
1716: arp_util.debug('Updating distributions with the transaction code when changed at line level');
1717: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1718: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1719: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1720:
1721: /* The logic below is mainly to hit the other rows in RA_CUST_TRX_LINE_GL_DIST which are

Line 1719: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');

1715:
1716: arp_util.debug('Updating distributions with the transaction code when changed at line level');
1717: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1718: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1719: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1720:
1721: /* The logic below is mainly to hit the other rows in RA_CUST_TRX_LINE_GL_DIST which are
1722: linked to the line updated above apart from the REC row*/
1723: DECLARE

Line 1732: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1728: BEGIN
1729: open c1;
1730: LOOP
1731: fetch c1 into l_id;
1732: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1733: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1734: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1735: exit when c1%NOTFOUND;
1736: END LOOP;

Line 1734: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');

1730: LOOP
1731: fetch c1 into l_id;
1732: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1733: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1734: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1735: exit when c1%NOTFOUND;
1736: END LOOP;
1737: close c1;
1738: EXCEPTION

Line 1835: | arp_ctlgd_pkg.delete_f_ct_ltctl_id_type

1831: | 'DEFERRED' mode so that 'soft' |
1832: | excpetion will be raise. |
1833: | 21-OCT-1997 OSTEINME Bug 565566:
1834: | added call to procedure
1835: | arp_ctlgd_pkg.delete_f_ct_ltctl_id_type
1836: | |
1837: +===========================================================================*/
1838:
1839:

Line 1918: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type(

1914: | Delete the account assignments associated with |
1915: | the freight line. |
1916: +---------------------------------------------------*/
1917:
1918: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type(
1919: p_line_rec.customer_trx_id,
1920: p_customer_trx_line_id,
1921: 'FREIGHT',
1922: NULL,

Line 1944: arp_ctlgd_pkg.delete_f_ctl_id( p_customer_trx_line_id,

1940: | Delete the account assignments and account sets |
1941: | associated with this line. |
1942: +---------------------------------------------------*/
1943:
1944: arp_ctlgd_pkg.delete_f_ctl_id( p_customer_trx_line_id,
1945: null,
1946: null );
1947:
1948: /*------------------------------------------------------------+