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 1221: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1217: IF ( p_line_rec.previous_customer_trx_id IS NOT NULL AND l_dist_line IS NOT NULL)
1218:
1219: THEN
1220: arp_util.debug('Stamping distributions with the transaction code when entered at line level');
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,p_customer_trx_line_id,'N','');
1224:
1225:

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

1219: THEN
1220: arp_util.debug('Stamping distributions with the transaction code when entered at line level');
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,p_customer_trx_line_id,'N','');
1224:
1225:
1226: DECLARE
1227: cursor c1 is select customer_trx_line_id

Line 1235: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1231: BEGIN
1232: open c1;
1233: LOOP
1234: fetch c1 into l_id;
1235: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1236: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1237: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1238: exit when c1%NOTFOUND;
1239: END LOOP;

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

1233: LOOP
1234: fetch c1 into l_id;
1235: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1236: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1237: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1238: exit when c1%NOTFOUND;
1239: END LOOP;
1240: close c1;
1241: EXCEPTION

Line 1682: arp_ctlgd_pkg.update_amount_f_ctl_id(

1678: END;
1679:
1680: ELSIF l_amount_changed_flag
1681: THEN
1682: arp_ctlgd_pkg.update_amount_f_ctl_id(
1683: p_customer_trx_line_id,
1684: l_new_line_rec.extended_amount,
1685: p_foreign_currency_code,
1686: pg_base_curr_code,

Line 1731: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1727: IF nvl(l_db_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0) <> nvl(p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0)
1728: THEN
1729:
1730: arp_util.debug('Updating distributions with the transaction code when changed at line level');
1731: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1732: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1733: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1734:
1735: /* The logic below is mainly to hit the other rows in RA_CUST_TRX_LINE_GL_DIST which are

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

1729:
1730: arp_util.debug('Updating distributions with the transaction code when changed at line level');
1731: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1732: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1733: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1734:
1735: /* The logic below is mainly to hit the other rows in RA_CUST_TRX_LINE_GL_DIST which are
1736: linked to the line updated above apart from the REC row*/
1737: DECLARE

Line 1746: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);

1742: BEGIN
1743: open c1;
1744: LOOP
1745: fetch c1 into l_id;
1746: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1747: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1748: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1749: exit when c1%NOTFOUND;
1750: END LOOP;

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

1744: LOOP
1745: fetch c1 into l_id;
1746: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1747: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1748: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,l_id,'N','');
1749: exit when c1%NOTFOUND;
1750: END LOOP;
1751: close c1;
1752: EXCEPTION

Line 1849: | arp_ctlgd_pkg.delete_f_ct_ltctl_id_type

1845: | 'DEFERRED' mode so that 'soft' |
1846: | excpetion will be raise. |
1847: | 21-OCT-1997 OSTEINME Bug 565566:
1848: | added call to procedure
1849: | arp_ctlgd_pkg.delete_f_ct_ltctl_id_type
1850: | |
1851: +===========================================================================*/
1852:
1853:

Line 1932: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type(

1928: | Delete the account assignments associated with |
1929: | the freight line. |
1930: +---------------------------------------------------*/
1931:
1932: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type(
1933: p_line_rec.customer_trx_id,
1934: p_customer_trx_line_id,
1935: 'FREIGHT',
1936: NULL,

Line 1958: arp_ctlgd_pkg.delete_f_ctl_id( p_customer_trx_line_id,

1954: | Delete the account assignments and account sets |
1955: | associated with this line. |
1956: +---------------------------------------------------*/
1957:
1958: arp_ctlgd_pkg.delete_f_ctl_id( p_customer_trx_line_id,
1959: null,
1960: null );
1961:
1962: /*------------------------------------------------------------+