eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CTLGD_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 66: PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)

62: | 19-JUL-95 Charlie Tomberg Created |
63: | |
64: +===========================================================================*/
65:
66: PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
67: IS
68:
69:
70: BEGIN

Line 74: arp_util.debug('************** Dump of ra_cust_trx_line_gl_dist record '||

70: BEGIN
71:
72: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()+');
73:
74: arp_util.debug('************** Dump of ra_cust_trx_line_gl_dist record '||
75: '**************');
76:
77: arp_util.debug('cust_trx_line_gl_dist_id: '
78: || p_dist_rec.cust_trx_line_gl_dist_id);

Line 129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||

125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
127: arp_util.debug('program_id: ' || p_dist_rec.program_id);
128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||
130: '**************');
131:
132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');
133:

Line 171: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)

167: | |
168: +===========================================================================*/
169:
170: PROCEDURE display_dist_p( p_cust_trx_line_gl_dist_id IN
171: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
172: IS
173:
174: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
175:

Line 174: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

170: PROCEDURE display_dist_p( p_cust_trx_line_gl_dist_id IN
171: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
172: IS
173:
174: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
175:
176: BEGIN
177:
178: arp_util.debug('arp_ctlgd_pkg.display_dist_p()+');

Line 229: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

225: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
226: IS
227:
228: l_cust_trx_line_gl_dist_id
229: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
230:
231: CURSOR srep_cursor IS
232: SELECT *
233: FROM ra_cust_trx_line_gl_dist

Line 233: FROM ra_cust_trx_line_gl_dist

229: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
230:
231: CURSOR srep_cursor IS
232: SELECT *
233: FROM ra_cust_trx_line_gl_dist
234: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
235: ORDER BY cust_trx_line_gl_dist_id;
236:
237:

Line 245: ' Dump of ra_cust_trx_line_gl_dist records for ctls: '||

241:
242: arp_util.debug('=====================================================' ||
243: '==========================');
244: arp_util.debug('========== ' ||
245: ' Dump of ra_cust_trx_line_gl_dist records for ctls: '||
246: to_char( p_cust_trx_line_salesrep_id ) || ' ' ||
247: '==========');
248:
249: FOR l_dist_rec IN srep_cursor LOOP

Line 254: 'Dump of ra_cust_trx_line_gl_dist records for ctls: '||

250: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
251: END LOOP;
252:
253: arp_util.debug('====== End ' ||
254: 'Dump of ra_cust_trx_line_gl_dist records for ctls: '||
255: to_char( p_cust_trx_line_salesrep_id ) || ' ' ||
256: '=======');
257: arp_util.debug('=====================================================' ||
258: '==========================');

Line 304: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

300: ra_customer_trx.customer_trx_id%type)
301: IS
302:
303: l_cust_trx_line_gl_dist_id
304: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
305:
306: CURSOR srep_cursor IS
307: SELECT *
308: FROM ra_cust_trx_line_gl_dist

Line 308: FROM ra_cust_trx_line_gl_dist

304: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
305:
306: CURSOR srep_cursor IS
307: SELECT *
308: FROM ra_cust_trx_line_gl_dist
309: WHERE customer_trx_id = p_customer_trx_id
310: ORDER BY cust_trx_line_gl_dist_id;
311:
312:

Line 320: ' Dump of ra_cust_trx_line_gl_dist records for ctid: '||

316:
317: arp_util.debug('=====================================================' ||
318: '==========================');
319: arp_util.debug('========== ' ||
320: ' Dump of ra_cust_trx_line_gl_dist records for ctid: '||
321: to_char( p_customer_trx_id ) || ' ' ||
322: '==========');
323:
324: FOR l_dist_rec IN srep_cursor LOOP

Line 329: 'Dump of ra_cust_trx_line_gl_dist records for ctid: '||

325: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
326: END LOOP;
327:
328: arp_util.debug('====== End ' ||
329: 'Dump of ra_cust_trx_line_gl_dist records for ctid: '||
330: to_char( p_customer_trx_id ) || ' ' ||
331: '=======');
332: arp_util.debug('=====================================================' ||
333: '==========================');

Line 380: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

376: ra_customer_trx_lines.customer_trx_line_id%type)
377: IS
378:
379: l_cust_trx_line_gl_dist_id
380: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
381:
382: CURSOR dist_cursor IS
383: SELECT *
384: FROM ra_cust_trx_line_gl_dist

Line 384: FROM ra_cust_trx_line_gl_dist

380: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
381:
382: CURSOR dist_cursor IS
383: SELECT *
384: FROM ra_cust_trx_line_gl_dist
385: WHERE customer_trx_line_id = p_customer_trx_line_id
386: ORDER BY cust_trx_line_gl_dist_id;
387:
388:

Line 396: ' Dump of ra_cust_trx_line_gl_dist records for ctlid: '||

392:
393: arp_util.debug('=====================================================' ||
394: '==========================');
395: arp_util.debug('========== ' ||
396: ' Dump of ra_cust_trx_line_gl_dist records for ctlid: '||
397: to_char( p_customer_trx_line_id ) || ' ' ||
398: '==========');
399:
400: FOR l_dist_rec IN dist_cursor LOOP

Line 405: 'Dump of ra_cust_trx_line_gl_dist records for ctlid: '||

401: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
402: END LOOP;
403:
404: arp_util.debug('====== End ' ||
405: 'Dump of ra_cust_trx_line_gl_dist records for ctlid: '||
406: to_char( p_customer_trx_line_id ) || ' ' ||
407: '=======');
408: arp_util.debug('=====================================================' ||
409: '==========================');

Line 496: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

492: | |
493: +===========================================================================*/
494:
495: PROCEDURE merge_dist_recs(
496: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
497: p_new_dist_rec IN
498: ra_cust_trx_line_gl_dist%rowtype,
499: p_out_dist_rec IN OUT NOCOPY
500: ra_cust_trx_line_gl_dist%rowtype

Line 498: ra_cust_trx_line_gl_dist%rowtype,

494:
495: PROCEDURE merge_dist_recs(
496: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
497: p_new_dist_rec IN
498: ra_cust_trx_line_gl_dist%rowtype,
499: p_out_dist_rec IN OUT NOCOPY
500: ra_cust_trx_line_gl_dist%rowtype
501: ) IS
502:

Line 500: ra_cust_trx_line_gl_dist%rowtype

496: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
497: p_new_dist_rec IN
498: ra_cust_trx_line_gl_dist%rowtype,
499: p_out_dist_rec IN OUT NOCOPY
500: ra_cust_trx_line_gl_dist%rowtype
501: ) IS
502:
503: BEGIN
504:

Line 804: | p_dist_rec - ra_cust_trx_line_gl_dist record |

800: | arp_util.debug |
801: | |
802: | ARGUMENTS : IN: |
803: | p_update_cursor - ID of the update cursor |
804: | p_dist_rec - ra_cust_trx_line_gl_dist record |
805: | p_exchange_rate |
806: | p_currency_code |
807: | p_precision |
808: | p_mau |

Line 824: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

820:
821:
822: PROCEDURE bind_dist_variables(
823: p_update_cursor IN integer,
824: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
825: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
826: p_currency_code IN fnd_currencies.currency_code%type,
827: p_precision IN fnd_currencies.precision%type,
828: p_mau IN

Line 1081: 'UPDATE ra_cust_trx_line_gl_dist

1077: BEGIN
1078: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()+');
1079:
1080: update_text :=
1081: 'UPDATE ra_cust_trx_line_gl_dist
1082: SET cust_trx_line_gl_dist_id =
1083: DECODE(:cust_trx_line_gl_dist_id,
1084: :ar_number_dummy, cust_trx_line_gl_dist_id,
1085: :cust_trx_line_gl_dist_id),

Line 1339: | This procedure Updates records in ra_cust_trx_line_gl_dist |

1335: | PROCEDURE |
1336: | generic_update |
1337: | |
1338: | DESCRIPTION |
1339: | This procedure Updates records in ra_cust_trx_line_gl_dist |
1340: | identified by the where clause that is passed in as a parameter. Only |
1341: | those columns in the dist record parameter that do not contain the |
1342: | special dummy values are updated. |
1343: | |

Line 1380: ra_cust_trx_line_gl_dist.account_set_flag%type,

1376: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
1377: p_where_clause IN varchar2,
1378: p_where1 IN number,
1379: p_account_set_flag IN
1380: ra_cust_trx_line_gl_dist.account_set_flag%type,
1381: p_account_class IN
1382: ra_cust_trx_line_gl_dist.account_class%type,
1383: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1384: p_currency_code IN fnd_currencies.currency_code%type,

Line 1382: ra_cust_trx_line_gl_dist.account_class%type,

1378: p_where1 IN number,
1379: p_account_set_flag IN
1380: ra_cust_trx_line_gl_dist.account_set_flag%type,
1381: p_account_class IN
1382: ra_cust_trx_line_gl_dist.account_class%type,
1383: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1384: p_currency_code IN fnd_currencies.currency_code%type,
1385: p_precision IN fnd_currencies.precision%type,
1386: p_mau IN

Line 1388: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)

1384: p_currency_code IN fnd_currencies.currency_code%type,
1385: p_precision IN fnd_currencies.precision%type,
1386: p_mau IN
1387: fnd_currencies.minimum_accountable_unit%type,
1388: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1389: IS
1390:
1391: l_count number;
1392: l_update_statement varchar2(25000);

Line 1489: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

1485: arp_standard.debug('gl dist array('||to_char(I) || ') = ' || to_char(gl_dist_array(I)));
1486:
1487: ar_mrc_engine.maintain_mrc_data(
1488: p_event_mode => 'UPDATE',
1489: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
1490: p_mode => 'SINGLE',
1491: p_key_value => gl_dist_array(I));
1492: END LOOP;
1493:

Line 1540: PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype) IS

1536: | 09-JUN-95 Charlie Tomberg Created |
1537: | |
1538: +===========================================================================*/
1539:
1540: PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype) IS
1541:
1542: BEGIN
1543:
1544: arp_util.debug('arp_lgd_pkg.set_to_dummy()+');

Line 1610: | This procedure locks the ra_cust_trx_line_gl_dist row identified by |

1606: | PROCEDURE |
1607: | lock_p |
1608: | |
1609: | DESCRIPTION |
1610: | This procedure locks the ra_cust_trx_line_gl_dist row identified by |
1611: | p_cust_trx_line_gl_dist_id parameter. |
1612: | |
1613: | SCOPE - PUBLIC |
1614: | |

Line 1633: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type

1629: | |
1630: +===========================================================================*/
1631:
1632: PROCEDURE lock_p( p_cust_trx_line_gl_dist_id
1633: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type
1634: )
1635: IS
1636:
1637: l_cust_trx_line_gl_dist_id

Line 1638: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

1634: )
1635: IS
1636:
1637: l_cust_trx_line_gl_dist_id
1638: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1639:
1640: BEGIN
1641: arp_util.debug('arp_ctlgd_pkg.lock_p()+');
1642:

Line 1646: FROM ra_cust_trx_line_gl_dist

1642:
1643:
1644: SELECT cust_trx_line_gl_dist_id
1645: INTO l_cust_trx_line_gl_dist_id
1646: FROM ra_cust_trx_line_gl_dist
1647: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1648: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1649:
1650: arp_util.debug('arp_ctlgd_pkg.lock_p()-');

Line 1663: | This procedure locks the ra_cust_trx_line_gl_dist rows identified by |

1659: | PROCEDURE |
1660: | lock_f_ct_id |
1661: | |
1662: | DESCRIPTION |
1663: | This procedure locks the ra_cust_trx_line_gl_dist rows identified by |
1664: | p_customer_trx_id parameter. |
1665: | |
1666: | SCOPE - PUBLIC |
1667: | |

Line 1690: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

1686:
1687: PROCEDURE lock_f_ct_id( p_customer_trx_id
1688: IN ra_customer_trx.customer_trx_id%type,
1689: p_account_set_flag
1690: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1691: p_account_class
1692: IN ra_cust_trx_line_gl_dist.account_class%type)
1693: IS
1694:

Line 1692: IN ra_cust_trx_line_gl_dist.account_class%type)

1688: IN ra_customer_trx.customer_trx_id%type,
1689: p_account_set_flag
1690: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1691: p_account_class
1692: IN ra_cust_trx_line_gl_dist.account_class%type)
1693: IS
1694:
1695:
1696: CURSOR lock_c IS

Line 1698: FROM ra_cust_trx_line_gl_dist

1694:
1695:
1696: CURSOR lock_c IS
1697: SELECT cust_trx_line_gl_dist_id
1698: FROM ra_cust_trx_line_gl_dist
1699: WHERE customer_trx_id = p_customer_trx_id
1700: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
1701: AND account_class = nvl(p_account_class, account_class)
1702: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;

Line 1724: | This procedure locks the ra_cust_trx_line_gl_dist rows identified by |

1720: | PROCEDURE |
1721: | lock_f_ctl_id |
1722: | |
1723: | DESCRIPTION |
1724: | This procedure locks the ra_cust_trx_line_gl_dist rows identified by |
1725: | p_customer_trx_line_id parameter. |
1726: | |
1727: | SCOPE - PUBLIC |
1728: | |

Line 1751: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

1747:
1748: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
1749: IN ra_customer_trx_lines.customer_trx_line_id%type,
1750: p_account_set_flag
1751: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1752: p_account_class
1753: IN ra_cust_trx_line_gl_dist.account_class%type)
1754: IS
1755:

Line 1753: IN ra_cust_trx_line_gl_dist.account_class%type)

1749: IN ra_customer_trx_lines.customer_trx_line_id%type,
1750: p_account_set_flag
1751: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1752: p_account_class
1753: IN ra_cust_trx_line_gl_dist.account_class%type)
1754: IS
1755:
1756: CURSOR lock_c IS
1757: SELECT cust_trx_line_gl_dist_id

Line 1758: FROM ra_cust_trx_line_gl_dist

1754: IS
1755:
1756: CURSOR lock_c IS
1757: SELECT cust_trx_line_gl_dist_id
1758: FROM ra_cust_trx_line_gl_dist
1759: WHERE customer_trx_line_id = p_customer_trx_line_id
1760: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
1761: AND account_class = nvl(p_account_class, account_class)
1762: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;

Line 1784: | This procedure locks the ra_cust_trx_line_gl_dist rows identified by |

1780: | PROCEDURE |
1781: | lock_f_ctls_id |
1782: | |
1783: | DESCRIPTION |
1784: | This procedure locks the ra_cust_trx_line_gl_dist rows identified by |
1785: | p_cust_trx_line_salesrep_id parameter. |
1786: | |
1787: | SCOPE - PUBLIC |
1788: | |

Line 1809: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

1805: | |
1806: +===========================================================================*/
1807:
1808: PROCEDURE lock_f_ctls_id( p_cust_trx_line_salesrep_id
1809: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
1810: p_account_set_flag
1811: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1812: p_account_class
1813: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 1811: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

1807:
1808: PROCEDURE lock_f_ctls_id( p_cust_trx_line_salesrep_id
1809: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
1810: p_account_set_flag
1811: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1812: p_account_class
1813: IN ra_cust_trx_line_gl_dist.account_class%type)
1814: IS
1815:

Line 1813: IN ra_cust_trx_line_gl_dist.account_class%type)

1809: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
1810: p_account_set_flag
1811: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1812: p_account_class
1813: IN ra_cust_trx_line_gl_dist.account_class%type)
1814: IS
1815:
1816: CURSOR lock_c IS
1817: SELECT cust_trx_line_gl_dist_id

Line 1818: FROM ra_cust_trx_line_gl_dist

1814: IS
1815:
1816: CURSOR lock_c IS
1817: SELECT cust_trx_line_gl_dist_id
1818: FROM ra_cust_trx_line_gl_dist
1819: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1820: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
1821: AND account_class = nvl(p_account_class, account_class)
1822: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;

Line 1843: | This procedure locks the ra_cust_trx_line_gl_dist row identified |

1839: | PROCEDURE |
1840: | lock_fetch_p |
1841: | |
1842: | DESCRIPTION |
1843: | This procedure locks the ra_cust_trx_line_gl_dist row identified |
1844: | by the p_cust_trx_line_gl_dist_id parameter and populates the |
1845: | p_dist_rec parameter with the row that was locked. |
1846: | |
1847: | SCOPE - PUBLIC |

Line 1866: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

1862: | 09-JUN-95 Charlie Tomberg Created |
1863: | |
1864: +===========================================================================*/
1865:
1866: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1867: p_cust_trx_line_gl_dist_id IN
1868: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type
1869: ) IS
1870:

Line 1868: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type

1864: +===========================================================================*/
1865:
1866: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1867: p_cust_trx_line_gl_dist_id IN
1868: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type
1869: ) IS
1870:
1871: BEGIN
1872: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()+');

Line 1876: FROM ra_cust_trx_line_gl_dist

1872: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()+');
1873:
1874: SELECT *
1875: INTO p_dist_rec
1876: FROM ra_cust_trx_line_gl_dist
1877: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1878: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1879:
1880: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');

Line 1893: | This procedure locks the ra_cust_trx_line_gl_dist row identified |

1889: | PROCEDURE |
1890: | lock_compare_p |
1891: | |
1892: | DESCRIPTION |
1893: | This procedure locks the ra_cust_trx_line_gl_dist row identified |
1894: | by the p_cust_trx_line_gl_dist_id parameter only if no columns in |
1895: | that row have changed from when they were first selected in the form. |
1896: | |
1897: | SCOPE - PUBLIC |

Line 1920: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

1916: | 13-OCT-95 Martin Johnson Handle NO_DATA_FOUND exception |
1917: | |
1918: +===========================================================================*/
1919:
1920: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
1921: p_cust_trx_line_gl_dist_id IN
1922: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1923: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1924:

Line 1922: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

1918: +===========================================================================*/
1919:
1920: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
1921: p_cust_trx_line_gl_dist_id IN
1922: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1923: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1924:
1925: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1926: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 1925: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1921: p_cust_trx_line_gl_dist_id IN
1922: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1923: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1924:
1925: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1926: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1927: l_ignore_who_flag varchar2(2);
1928:
1929: BEGIN

Line 1926: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1922: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1923: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1924:
1925: l_new_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1926: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1927: l_ignore_who_flag varchar2(2);
1928:
1929: BEGIN
1930: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()+');

Line 1939: FROM ra_cust_trx_line_gl_dist ctlgd

1935: END IF;
1936:
1937: SELECT *
1938: INTO l_new_dist_rec
1939: FROM ra_cust_trx_line_gl_dist ctlgd
1940: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1941: AND (
1942: NVL(ctlgd.cust_trx_line_gl_dist_id, AR_NUMBER_DUMMY) =
1943: NVL(

Line 2472: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

2468:
2469:
2470: PROCEDURE lock_compare_cover(
2471: p_cust_trx_line_gl_dist_id IN
2472: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
2473: p_customer_trx_id IN
2474: ra_cust_trx_line_gl_dist.customer_trx_id%type,
2475: p_customer_trx_line_id IN
2476: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,

Line 2474: ra_cust_trx_line_gl_dist.customer_trx_id%type,

2470: PROCEDURE lock_compare_cover(
2471: p_cust_trx_line_gl_dist_id IN
2472: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
2473: p_customer_trx_id IN
2474: ra_cust_trx_line_gl_dist.customer_trx_id%type,
2475: p_customer_trx_line_id IN
2476: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
2477: p_cust_trx_line_salesrep_id IN
2478: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

Line 2476: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,

2472: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
2473: p_customer_trx_id IN
2474: ra_cust_trx_line_gl_dist.customer_trx_id%type,
2475: p_customer_trx_line_id IN
2476: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
2477: p_cust_trx_line_salesrep_id IN
2478: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
2479: p_account_class IN
2480: ra_cust_trx_line_gl_dist.account_class%type,

Line 2478: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

2474: ra_cust_trx_line_gl_dist.customer_trx_id%type,
2475: p_customer_trx_line_id IN
2476: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
2477: p_cust_trx_line_salesrep_id IN
2478: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
2479: p_account_class IN
2480: ra_cust_trx_line_gl_dist.account_class%type,
2481: p_percent IN
2482: ra_cust_trx_line_gl_dist.percent%type,

Line 2480: ra_cust_trx_line_gl_dist.account_class%type,

2476: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
2477: p_cust_trx_line_salesrep_id IN
2478: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
2479: p_account_class IN
2480: ra_cust_trx_line_gl_dist.account_class%type,
2481: p_percent IN
2482: ra_cust_trx_line_gl_dist.percent%type,
2483: p_amount IN
2484: ra_cust_trx_line_gl_dist.amount%type,

Line 2482: ra_cust_trx_line_gl_dist.percent%type,

2478: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
2479: p_account_class IN
2480: ra_cust_trx_line_gl_dist.account_class%type,
2481: p_percent IN
2482: ra_cust_trx_line_gl_dist.percent%type,
2483: p_amount IN
2484: ra_cust_trx_line_gl_dist.amount%type,
2485: p_gl_date IN
2486: ra_cust_trx_line_gl_dist.gl_date%type,

Line 2484: ra_cust_trx_line_gl_dist.amount%type,

2480: ra_cust_trx_line_gl_dist.account_class%type,
2481: p_percent IN
2482: ra_cust_trx_line_gl_dist.percent%type,
2483: p_amount IN
2484: ra_cust_trx_line_gl_dist.amount%type,
2485: p_gl_date IN
2486: ra_cust_trx_line_gl_dist.gl_date%type,
2487: p_original_gl_date IN
2488: ra_cust_trx_line_gl_dist.original_gl_date%type,

Line 2486: ra_cust_trx_line_gl_dist.gl_date%type,

2482: ra_cust_trx_line_gl_dist.percent%type,
2483: p_amount IN
2484: ra_cust_trx_line_gl_dist.amount%type,
2485: p_gl_date IN
2486: ra_cust_trx_line_gl_dist.gl_date%type,
2487: p_original_gl_date IN
2488: ra_cust_trx_line_gl_dist.original_gl_date%type,
2489: p_gl_posted_date IN
2490: ra_cust_trx_line_gl_dist.gl_posted_date%type,

Line 2488: ra_cust_trx_line_gl_dist.original_gl_date%type,

2484: ra_cust_trx_line_gl_dist.amount%type,
2485: p_gl_date IN
2486: ra_cust_trx_line_gl_dist.gl_date%type,
2487: p_original_gl_date IN
2488: ra_cust_trx_line_gl_dist.original_gl_date%type,
2489: p_gl_posted_date IN
2490: ra_cust_trx_line_gl_dist.gl_posted_date%type,
2491: p_code_combination_id IN
2492: ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 2490: ra_cust_trx_line_gl_dist.gl_posted_date%type,

2486: ra_cust_trx_line_gl_dist.gl_date%type,
2487: p_original_gl_date IN
2488: ra_cust_trx_line_gl_dist.original_gl_date%type,
2489: p_gl_posted_date IN
2490: ra_cust_trx_line_gl_dist.gl_posted_date%type,
2491: p_code_combination_id IN
2492: ra_cust_trx_line_gl_dist.code_combination_id%type,
2493: p_concatenated_segments IN
2494: ra_cust_trx_line_gl_dist.concatenated_segments%type,

Line 2492: ra_cust_trx_line_gl_dist.code_combination_id%type,

2488: ra_cust_trx_line_gl_dist.original_gl_date%type,
2489: p_gl_posted_date IN
2490: ra_cust_trx_line_gl_dist.gl_posted_date%type,
2491: p_code_combination_id IN
2492: ra_cust_trx_line_gl_dist.code_combination_id%type,
2493: p_concatenated_segments IN
2494: ra_cust_trx_line_gl_dist.concatenated_segments%type,
2495: p_collected_tax_ccid IN
2496: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

Line 2494: ra_cust_trx_line_gl_dist.concatenated_segments%type,

2490: ra_cust_trx_line_gl_dist.gl_posted_date%type,
2491: p_code_combination_id IN
2492: ra_cust_trx_line_gl_dist.code_combination_id%type,
2493: p_concatenated_segments IN
2494: ra_cust_trx_line_gl_dist.concatenated_segments%type,
2495: p_collected_tax_ccid IN
2496: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
2497: p_collected_tax_concat_seg IN
2498: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

Line 2496: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

2492: ra_cust_trx_line_gl_dist.code_combination_id%type,
2493: p_concatenated_segments IN
2494: ra_cust_trx_line_gl_dist.concatenated_segments%type,
2495: p_collected_tax_ccid IN
2496: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
2497: p_collected_tax_concat_seg IN
2498: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
2499: p_comments IN
2500: ra_cust_trx_line_gl_dist.comments%type,

Line 2498: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

2494: ra_cust_trx_line_gl_dist.concatenated_segments%type,
2495: p_collected_tax_ccid IN
2496: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
2497: p_collected_tax_concat_seg IN
2498: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
2499: p_comments IN
2500: ra_cust_trx_line_gl_dist.comments%type,
2501: p_account_set_flag IN
2502: ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 2500: ra_cust_trx_line_gl_dist.comments%type,

2496: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
2497: p_collected_tax_concat_seg IN
2498: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
2499: p_comments IN
2500: ra_cust_trx_line_gl_dist.comments%type,
2501: p_account_set_flag IN
2502: ra_cust_trx_line_gl_dist.account_set_flag%type,
2503: p_latest_rec_flag IN
2504: ra_cust_trx_line_gl_dist.latest_rec_flag%type,

Line 2502: ra_cust_trx_line_gl_dist.account_set_flag%type,

2498: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
2499: p_comments IN
2500: ra_cust_trx_line_gl_dist.comments%type,
2501: p_account_set_flag IN
2502: ra_cust_trx_line_gl_dist.account_set_flag%type,
2503: p_latest_rec_flag IN
2504: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
2505: p_ussgl_transaction_code IN
2506: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

Line 2504: ra_cust_trx_line_gl_dist.latest_rec_flag%type,

2500: ra_cust_trx_line_gl_dist.comments%type,
2501: p_account_set_flag IN
2502: ra_cust_trx_line_gl_dist.account_set_flag%type,
2503: p_latest_rec_flag IN
2504: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
2505: p_ussgl_transaction_code IN
2506: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
2507: p_ussgl_trx_code_context IN
2508: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

Line 2506: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

2502: ra_cust_trx_line_gl_dist.account_set_flag%type,
2503: p_latest_rec_flag IN
2504: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
2505: p_ussgl_transaction_code IN
2506: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
2507: p_ussgl_trx_code_context IN
2508: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
2509: p_attribute_category IN
2510: ra_cust_trx_line_gl_dist.attribute_category%type,

Line 2508: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

2504: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
2505: p_ussgl_transaction_code IN
2506: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
2507: p_ussgl_trx_code_context IN
2508: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
2509: p_attribute_category IN
2510: ra_cust_trx_line_gl_dist.attribute_category%type,
2511: p_attribute1 IN
2512: ra_cust_trx_line_gl_dist.attribute1%type,

Line 2510: ra_cust_trx_line_gl_dist.attribute_category%type,

2506: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
2507: p_ussgl_trx_code_context IN
2508: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
2509: p_attribute_category IN
2510: ra_cust_trx_line_gl_dist.attribute_category%type,
2511: p_attribute1 IN
2512: ra_cust_trx_line_gl_dist.attribute1%type,
2513: p_attribute2 IN
2514: ra_cust_trx_line_gl_dist.attribute2%type,

Line 2512: ra_cust_trx_line_gl_dist.attribute1%type,

2508: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
2509: p_attribute_category IN
2510: ra_cust_trx_line_gl_dist.attribute_category%type,
2511: p_attribute1 IN
2512: ra_cust_trx_line_gl_dist.attribute1%type,
2513: p_attribute2 IN
2514: ra_cust_trx_line_gl_dist.attribute2%type,
2515: p_attribute3 IN
2516: ra_cust_trx_line_gl_dist.attribute3%type,

Line 2514: ra_cust_trx_line_gl_dist.attribute2%type,

2510: ra_cust_trx_line_gl_dist.attribute_category%type,
2511: p_attribute1 IN
2512: ra_cust_trx_line_gl_dist.attribute1%type,
2513: p_attribute2 IN
2514: ra_cust_trx_line_gl_dist.attribute2%type,
2515: p_attribute3 IN
2516: ra_cust_trx_line_gl_dist.attribute3%type,
2517: p_attribute4 IN
2518: ra_cust_trx_line_gl_dist.attribute4%type,

Line 2516: ra_cust_trx_line_gl_dist.attribute3%type,

2512: ra_cust_trx_line_gl_dist.attribute1%type,
2513: p_attribute2 IN
2514: ra_cust_trx_line_gl_dist.attribute2%type,
2515: p_attribute3 IN
2516: ra_cust_trx_line_gl_dist.attribute3%type,
2517: p_attribute4 IN
2518: ra_cust_trx_line_gl_dist.attribute4%type,
2519: p_attribute5 IN
2520: ra_cust_trx_line_gl_dist.attribute5%type,

Line 2518: ra_cust_trx_line_gl_dist.attribute4%type,

2514: ra_cust_trx_line_gl_dist.attribute2%type,
2515: p_attribute3 IN
2516: ra_cust_trx_line_gl_dist.attribute3%type,
2517: p_attribute4 IN
2518: ra_cust_trx_line_gl_dist.attribute4%type,
2519: p_attribute5 IN
2520: ra_cust_trx_line_gl_dist.attribute5%type,
2521: p_attribute6 IN
2522: ra_cust_trx_line_gl_dist.attribute6%type,

Line 2520: ra_cust_trx_line_gl_dist.attribute5%type,

2516: ra_cust_trx_line_gl_dist.attribute3%type,
2517: p_attribute4 IN
2518: ra_cust_trx_line_gl_dist.attribute4%type,
2519: p_attribute5 IN
2520: ra_cust_trx_line_gl_dist.attribute5%type,
2521: p_attribute6 IN
2522: ra_cust_trx_line_gl_dist.attribute6%type,
2523: p_attribute7 IN
2524: ra_cust_trx_line_gl_dist.attribute7%type,

Line 2522: ra_cust_trx_line_gl_dist.attribute6%type,

2518: ra_cust_trx_line_gl_dist.attribute4%type,
2519: p_attribute5 IN
2520: ra_cust_trx_line_gl_dist.attribute5%type,
2521: p_attribute6 IN
2522: ra_cust_trx_line_gl_dist.attribute6%type,
2523: p_attribute7 IN
2524: ra_cust_trx_line_gl_dist.attribute7%type,
2525: p_attribute8 IN
2526: ra_cust_trx_line_gl_dist.attribute8%type,

Line 2524: ra_cust_trx_line_gl_dist.attribute7%type,

2520: ra_cust_trx_line_gl_dist.attribute5%type,
2521: p_attribute6 IN
2522: ra_cust_trx_line_gl_dist.attribute6%type,
2523: p_attribute7 IN
2524: ra_cust_trx_line_gl_dist.attribute7%type,
2525: p_attribute8 IN
2526: ra_cust_trx_line_gl_dist.attribute8%type,
2527: p_attribute9 IN
2528: ra_cust_trx_line_gl_dist.attribute9%type,

Line 2526: ra_cust_trx_line_gl_dist.attribute8%type,

2522: ra_cust_trx_line_gl_dist.attribute6%type,
2523: p_attribute7 IN
2524: ra_cust_trx_line_gl_dist.attribute7%type,
2525: p_attribute8 IN
2526: ra_cust_trx_line_gl_dist.attribute8%type,
2527: p_attribute9 IN
2528: ra_cust_trx_line_gl_dist.attribute9%type,
2529: p_attribute10 IN
2530: ra_cust_trx_line_gl_dist.attribute10%type,

Line 2528: ra_cust_trx_line_gl_dist.attribute9%type,

2524: ra_cust_trx_line_gl_dist.attribute7%type,
2525: p_attribute8 IN
2526: ra_cust_trx_line_gl_dist.attribute8%type,
2527: p_attribute9 IN
2528: ra_cust_trx_line_gl_dist.attribute9%type,
2529: p_attribute10 IN
2530: ra_cust_trx_line_gl_dist.attribute10%type,
2531: p_attribute11 IN
2532: ra_cust_trx_line_gl_dist.attribute11%type,

Line 2530: ra_cust_trx_line_gl_dist.attribute10%type,

2526: ra_cust_trx_line_gl_dist.attribute8%type,
2527: p_attribute9 IN
2528: ra_cust_trx_line_gl_dist.attribute9%type,
2529: p_attribute10 IN
2530: ra_cust_trx_line_gl_dist.attribute10%type,
2531: p_attribute11 IN
2532: ra_cust_trx_line_gl_dist.attribute11%type,
2533: p_attribute12 IN
2534: ra_cust_trx_line_gl_dist.attribute12%type,

Line 2532: ra_cust_trx_line_gl_dist.attribute11%type,

2528: ra_cust_trx_line_gl_dist.attribute9%type,
2529: p_attribute10 IN
2530: ra_cust_trx_line_gl_dist.attribute10%type,
2531: p_attribute11 IN
2532: ra_cust_trx_line_gl_dist.attribute11%type,
2533: p_attribute12 IN
2534: ra_cust_trx_line_gl_dist.attribute12%type,
2535: p_attribute13 IN
2536: ra_cust_trx_line_gl_dist.attribute13%type,

Line 2534: ra_cust_trx_line_gl_dist.attribute12%type,

2530: ra_cust_trx_line_gl_dist.attribute10%type,
2531: p_attribute11 IN
2532: ra_cust_trx_line_gl_dist.attribute11%type,
2533: p_attribute12 IN
2534: ra_cust_trx_line_gl_dist.attribute12%type,
2535: p_attribute13 IN
2536: ra_cust_trx_line_gl_dist.attribute13%type,
2537: p_attribute14 IN
2538: ra_cust_trx_line_gl_dist.attribute14%type,

Line 2536: ra_cust_trx_line_gl_dist.attribute13%type,

2532: ra_cust_trx_line_gl_dist.attribute11%type,
2533: p_attribute12 IN
2534: ra_cust_trx_line_gl_dist.attribute12%type,
2535: p_attribute13 IN
2536: ra_cust_trx_line_gl_dist.attribute13%type,
2537: p_attribute14 IN
2538: ra_cust_trx_line_gl_dist.attribute14%type,
2539: p_attribute15 IN
2540: ra_cust_trx_line_gl_dist.attribute15%type,

Line 2538: ra_cust_trx_line_gl_dist.attribute14%type,

2534: ra_cust_trx_line_gl_dist.attribute12%type,
2535: p_attribute13 IN
2536: ra_cust_trx_line_gl_dist.attribute13%type,
2537: p_attribute14 IN
2538: ra_cust_trx_line_gl_dist.attribute14%type,
2539: p_attribute15 IN
2540: ra_cust_trx_line_gl_dist.attribute15%type,
2541: p_posting_control_id IN
2542: ra_cust_trx_line_gl_dist.posting_control_id%type )

Line 2540: ra_cust_trx_line_gl_dist.attribute15%type,

2536: ra_cust_trx_line_gl_dist.attribute13%type,
2537: p_attribute14 IN
2538: ra_cust_trx_line_gl_dist.attribute14%type,
2539: p_attribute15 IN
2540: ra_cust_trx_line_gl_dist.attribute15%type,
2541: p_posting_control_id IN
2542: ra_cust_trx_line_gl_dist.posting_control_id%type )
2543: IS
2544:

Line 2542: ra_cust_trx_line_gl_dist.posting_control_id%type )

2538: ra_cust_trx_line_gl_dist.attribute14%type,
2539: p_attribute15 IN
2540: ra_cust_trx_line_gl_dist.attribute15%type,
2541: p_posting_control_id IN
2542: ra_cust_trx_line_gl_dist.posting_control_id%type )
2543: IS
2544:
2545: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
2546:

Line 2545: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

2541: p_posting_control_id IN
2542: ra_cust_trx_line_gl_dist.posting_control_id%type )
2543: IS
2544:
2545: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
2546:
2547: BEGIN
2548:
2549: IF PG_DEBUG in ('Y', 'C') THEN

Line 2709: | This procedure fetches a single row from ra_cust_trx_line_gl_dist |

2705: | PROCEDURE |
2706: | fetch_p |
2707: | |
2708: | DESCRIPTION |
2709: | This procedure fetches a single row from ra_cust_trx_line_gl_dist |
2710: | into a variable specified as a parameter based on the table's primary |
2711: | key, cust_trx_line_gl_dist_id |
2712: | |
2713: | SCOPE - PUBLIC |

Line 2732: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

2728: | 09-JUN-95 Charlie Tomberg Created |
2729: | |
2730: +===========================================================================*/
2731:
2732: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
2733: p_cust_trx_line_gl_dist_id IN
2734: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
2735: IS
2736:

Line 2734: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)

2730: +===========================================================================*/
2731:
2732: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
2733: p_cust_trx_line_gl_dist_id IN
2734: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
2735: IS
2736:
2737: BEGIN
2738: arp_util.debug('arp_ctlgd_pkg.fetch_p()+');

Line 2742: FROM ra_cust_trx_line_gl_dist

2738: arp_util.debug('arp_ctlgd_pkg.fetch_p()+');
2739:
2740: SELECT *
2741: INTO p_dist_rec
2742: FROM ra_cust_trx_line_gl_dist
2743: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2744:
2745: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2746:

Line 2759: | This procedure deletes the ra_cust_trx_line_gl_dist row identified |

2755: | PROCEDURE |
2756: | delete_p |
2757: | |
2758: | DESCRIPTION |
2759: | This procedure deletes the ra_cust_trx_line_gl_dist row identified |
2760: | by the p_cust_trx_line_gl_dist_id parameter. |
2761: | |
2762: | SCOPE - PUBLIC |
2763: | |

Line 2785: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)

2781: | |
2782: +===========================================================================*/
2783:
2784: procedure delete_p( p_cust_trx_line_gl_dist_id
2785: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
2786: IS
2787:
2788:
2789: BEGIN

Line 2794: DELETE FROM ra_cust_trx_line_gl_dist

2790:
2791:
2792: arp_util.debug('arp_ctlgd_pkg.delete_p()+');
2793:
2794: DELETE FROM ra_cust_trx_line_gl_dist
2795: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2796:
2797: IF ( SQL%ROWCOUNT = 0 )
2798: THEN arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');

Line 2806: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

2802: /* call mrc api to delete */
2803: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2804: ar_mrc_engine.maintain_mrc_data(
2805: p_event_mode => 'DELETE',
2806: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2807: p_mode => 'SINGLE',
2808: p_key_value => p_cust_trx_line_gl_dist_id);
2809:
2810:

Line 2826: | This procedure deletes the ra_cust_trx_line_gl_dist rows identified |

2822: | PROCEDURE |
2823: | delete_f_ct_id |
2824: | |
2825: | DESCRIPTION |
2826: | This procedure deletes the ra_cust_trx_line_gl_dist rows identified |
2827: | by the p_customer_trx_id parameter. |
2828: | |
2829: | SCOPE - PUBLIC |
2830: | |

Line 2856: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

2852:
2853: procedure delete_f_ct_id( p_customer_trx_id
2854: IN ra_customer_trx.customer_trx_id%type,
2855: p_account_set_flag
2856: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2857: p_account_class
2858: IN ra_cust_trx_line_gl_dist.account_class%type)
2859: IS
2860:

Line 2858: IN ra_cust_trx_line_gl_dist.account_class%type)

2854: IN ra_customer_trx.customer_trx_id%type,
2855: p_account_set_flag
2856: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2857: p_account_class
2858: IN ra_cust_trx_line_gl_dist.account_class%type)
2859: IS
2860:
2861: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2862:

Line 2867: DELETE FROM ra_cust_trx_line_gl_dist

2863: BEGIN
2864:
2865: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()+');
2866:
2867: DELETE FROM ra_cust_trx_line_gl_dist
2868: WHERE customer_trx_id = p_customer_trx_id
2869: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
2870: AND account_class = nvl(p_account_class, account_class)
2871: RETURNING cust_trx_line_gl_dist_id

Line 2877: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

2873:
2874: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2875: ar_mrc_engine.maintain_mrc_data(
2876: p_event_mode => 'DELETE',
2877: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2878: p_mode => 'BATCH',
2879: p_key_value_list => l_gl_dist_key_value_list);
2880:
2881:

Line 2897: | This procedure deletes the ra_cust_trx_line_gl_dist rows identified |

2893: | PROCEDURE |
2894: | delete_f_ctl_id |
2895: | |
2896: | DESCRIPTION |
2897: | This procedure deletes the ra_cust_trx_line_gl_dist rows identified |
2898: | by the p_customer_trx_line_id parameter. |
2899: | |
2900: | SCOPE - PUBLIC |
2901: | |

Line 2927: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

2923:
2924: procedure delete_f_ctl_id( p_customer_trx_line_id
2925: IN ra_customer_trx_lines.customer_trx_line_id%type,
2926: p_account_set_flag
2927: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2928: p_account_class
2929: IN ra_cust_trx_line_gl_dist.account_class%type)
2930: IS
2931:

Line 2929: IN ra_cust_trx_line_gl_dist.account_class%type)

2925: IN ra_customer_trx_lines.customer_trx_line_id%type,
2926: p_account_set_flag
2927: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2928: p_account_class
2929: IN ra_cust_trx_line_gl_dist.account_class%type)
2930: IS
2931:
2932: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2933:

Line 2939: DELETE FROM ra_cust_trx_line_gl_dist

2935:
2936:
2937: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()+');
2938:
2939: DELETE FROM ra_cust_trx_line_gl_dist
2940: WHERE customer_trx_line_id = p_customer_trx_line_id
2941: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
2942: AND account_class = nvl(p_account_class, account_class)
2943: RETURNING cust_trx_line_gl_dist_id

Line 2949: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

2945:
2946: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2947: ar_mrc_engine.maintain_mrc_data(
2948: p_event_mode => 'DELETE',
2949: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2950: p_mode => 'BATCH',
2951: p_key_value_list => l_gl_dist_key_value_list);
2952:
2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');

Line 2968: | This procedure deletes the ra_cust_trx_line_gl_dist rows identified |

2964: | PROCEDURE |
2965: | delete_f_ctls_id |
2966: | |
2967: | DESCRIPTION |
2968: | This procedure deletes the ra_cust_trx_line_gl_dist rows identified |
2969: | by the p_cust_trx_line_salesrep_id parameter. |
2970: | |
2971: | SCOPE - PUBLIC |
2972: | |

Line 2998: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

2994:
2995: procedure delete_f_ctls_id( p_cust_trx_line_salesrep_id
2996: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2997: p_account_set_flag
2998: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2999: p_account_class
3000: IN ra_cust_trx_line_gl_dist.account_class%type)
3001: IS
3002:

Line 3000: IN ra_cust_trx_line_gl_dist.account_class%type)

2996: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2997: p_account_set_flag
2998: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2999: p_account_class
3000: IN ra_cust_trx_line_gl_dist.account_class%type)
3001: IS
3002:
3003: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3004:

Line 3009: DELETE FROM ra_cust_trx_line_gl_dist

3005: BEGIN
3006:
3007: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()+');
3008:
3009: DELETE FROM ra_cust_trx_line_gl_dist
3010: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
3011: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
3012: AND account_class = nvl(p_account_class, account_class)
3013: RETURNING cust_trx_line_gl_dist_id

Line 3019: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

3015:
3016: arp_standard.debug('calling mrc engine for insertion of gl dist data');
3017: ar_mrc_engine.maintain_mrc_data(
3018: p_event_mode => 'DELETE',
3019: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3020: p_mode => 'BATCH',
3021: p_key_value_list => l_gl_dist_key_value_list);
3022:
3023:

Line 3039: | This procedure deletes the ra_cust_trx_line_gl_dist rows corresponding |

3035: | PROCEDURE |
3036: | delete_f_ct_ltctl_id_type |
3037: | |
3038: | DESCRIPTION |
3039: | This procedure deletes the ra_cust_trx_line_gl_dist rows corresponding |
3040: | to the child lines (incl. header freight line) identified by |
3041: | p_customer_trx_id, p_link_to_cust_trx_line_id and p_line_type |
3042: | |
3043: | SCOPE - PUBLIC |

Line 3077: ra_cust_trx_line_gl_dist.account_set_flag%type,

3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3074: p_line_type IN
3075: ra_customer_trx_lines.line_type%type,
3076: p_account_set_flag IN
3077: ra_cust_trx_line_gl_dist.account_set_flag%type,
3078: p_account_class IN
3079: ra_cust_trx_line_gl_dist.account_class%type)
3080: IS
3081:

Line 3079: ra_cust_trx_line_gl_dist.account_class%type)

3075: ra_customer_trx_lines.line_type%type,
3076: p_account_set_flag IN
3077: ra_cust_trx_line_gl_dist.account_set_flag%type,
3078: p_account_class IN
3079: ra_cust_trx_line_gl_dist.account_class%type)
3080: IS
3081:
3082: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3083:

Line 3088: DELETE FROM ra_cust_trx_line_gl_dist

3084: BEGIN
3085:
3086: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()+');
3087:
3088: DELETE FROM ra_cust_trx_line_gl_dist
3089: WHERE customer_trx_id = p_customer_trx_id
3090: AND customer_trx_line_id in
3091: ( SELECT customer_trx_line_id
3092: FROM ra_customer_trx_lines

Line 3108: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

3104:
3105: arp_standard.debug('calling mrc engine for insertion of gl dist data');
3106: ar_mrc_engine.maintain_mrc_data(
3107: p_event_mode => 'DELETE',
3108: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3109: p_mode => 'BATCH',
3110: p_key_value_list => l_gl_dist_key_value_list);
3111:
3112:

Line 3129: | This procedure updates the ra_cust_trx_line_gl_dist row identified |

3125: | PROCEDURE |
3126: | update_p |
3127: | |
3128: | DESCRIPTION |
3129: | This procedure updates the ra_cust_trx_line_gl_dist row identified |
3130: | by the p_cust_trx_line_gl_dist_id parameter. |
3131: | |
3132: | SCOPE - PUBLIC |
3133: | |

Line 3158: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

3154: | 09-JUN-95 Charlie Tomberg Created |
3155: | |
3156: +===========================================================================*/
3157:
3158: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3159: p_cust_trx_line_gl_dist_id IN
3160: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3161: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3162: DEFAULT 1,

Line 3160: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

3156: +===========================================================================*/
3157:
3158: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3159: p_cust_trx_line_gl_dist_id IN
3160: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3161: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3162: DEFAULT 1,
3163: p_currency_code IN fnd_currencies.currency_code%type
3164: DEFAULT null,

Line 3212: | This procedure updates the ra_cust_trx_line_gl_dist rows identified |

3208: | PROCEDURE |
3209: | update_f_ct_id |
3210: | |
3211: | DESCRIPTION |
3212: | This procedure updates the ra_cust_trx_line_gl_dist rows identified |
3213: | by the p_customer_trx_id parameter. |
3214: | |
3215: | SCOPE - PUBLIC |
3216: | |

Line 3243: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

3239: | 09-JUN-95 Charlie Tomberg Created |
3240: | |
3241: +===========================================================================*/
3242:
3243: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3244: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3245: p_account_set_flag
3246: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3247: p_account_class

Line 3246: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

3242:
3243: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3244: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3245: p_account_set_flag
3246: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3247: p_account_class
3248: IN ra_cust_trx_line_gl_dist.account_class%type,
3249: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3250: DEFAULT 1,

Line 3248: IN ra_cust_trx_line_gl_dist.account_class%type,

3244: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3245: p_account_set_flag
3246: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3247: p_account_class
3248: IN ra_cust_trx_line_gl_dist.account_class%type,
3249: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3250: DEFAULT 1,
3251: p_currency_code IN fnd_currencies.currency_code%type
3252: DEFAULT null,

Line 3299: | This procedure updates the ra_cust_trx_line_gl_dist rows identified |

3295: | PROCEDURE |
3296: | update_f_ctl_id |
3297: | |
3298: | DESCRIPTION |
3299: | This procedure updates the ra_cust_trx_line_gl_dist rows identified |
3300: | by the p_customer_trx_line_id parameter. |
3301: | |
3302: | SCOPE - PUBLIC |
3303: | |

Line 3330: PROCEDURE update_f_ctl_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

3326: | 09-JUN-95 Charlie Tomberg Created |
3327: | |
3328: +===========================================================================*/
3329:
3330: PROCEDURE update_f_ctl_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3331: p_customer_trx_line_id IN
3332: ra_customer_trx_lines.customer_trx_line_id%type,
3333: p_account_set_flag
3334: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 3334: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

3330: PROCEDURE update_f_ctl_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3331: p_customer_trx_line_id IN
3332: ra_customer_trx_lines.customer_trx_line_id%type,
3333: p_account_set_flag
3334: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3335: p_account_class
3336: IN ra_cust_trx_line_gl_dist.account_class%type,
3337: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3338: DEFAULT 1,

Line 3336: IN ra_cust_trx_line_gl_dist.account_class%type,

3332: ra_customer_trx_lines.customer_trx_line_id%type,
3333: p_account_set_flag
3334: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3335: p_account_class
3336: IN ra_cust_trx_line_gl_dist.account_class%type,
3337: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3338: DEFAULT 1,
3339: p_currency_code IN fnd_currencies.currency_code%type
3340: DEFAULT null,

Line 3387: | This procedure updates the ra_cust_trx_line_gl_dist rows identified |

3383: | PROCEDURE |
3384: | update_f_ctls_id |
3385: | |
3386: | DESCRIPTION |
3387: | This procedure updates the ra_cust_trx_line_gl_dist rows identified |
3388: | by the p_cust_trx_line_salesrep_id parameter. |
3389: | |
3390: | SCOPE - PUBLIC |
3391: | |

Line 3418: PROCEDURE update_f_ctls_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

3414: | 09-JUN-95 Charlie Tomberg Created |
3415: | |
3416: +===========================================================================*/
3417:
3418: PROCEDURE update_f_ctls_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3419: p_cust_trx_line_salesrep_id IN
3420: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
3421: p_account_set_flag
3422: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 3422: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

3418: PROCEDURE update_f_ctls_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3419: p_cust_trx_line_salesrep_id IN
3420: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
3421: p_account_set_flag
3422: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3423: p_account_class
3424: IN ra_cust_trx_line_gl_dist.account_class%type,
3425: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3426: DEFAULT 1,

Line 3424: IN ra_cust_trx_line_gl_dist.account_class%type,

3420: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
3421: p_account_set_flag
3422: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3423: p_account_class
3424: IN ra_cust_trx_line_gl_dist.account_class%type,
3425: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3426: DEFAULT 1,
3427: p_currency_code IN fnd_currencies.currency_code%type
3428: DEFAULT null,

Line 3476: | Updates ra_cust_trx_line_gl_dist.acctd_amount for rows identified by |

3472: | update_acctd_amount |
3473: | |
3474: | DESCRIPTION |
3475: | |
3476: | Updates ra_cust_trx_line_gl_dist.acctd_amount for rows identified by |
3477: | the p_customer_trx_id parameter. |
3478: | |
3479: | SCOPE - PUBLIC |
3480: | |

Line 3501: | ra_cust_trx_line_gl_dist. |

3497: | MODIFICATION HISTORY |
3498: | 21-JUL-95 Martin Johnson Created |
3499: | 14-Aug-02 Debbie Jancis Modified for MRC trigger replacement |
3500: | added calls for processing updates to |
3501: | ra_cust_trx_line_gl_dist. |
3502: | 31-AUG-04 M Raymond Added IF condition to only do MRC
3503: | update if rows were updated in primary
3504: +===========================================================================*/
3505:

Line 3524: update ra_cust_trx_line_gl_dist

3520: BEGIN
3521:
3522: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()+');
3523:
3524: update ra_cust_trx_line_gl_dist
3525: set last_updated_by = pg_user_id,
3526: last_update_date = sysdate,
3527: last_update_login = pg_login_id,
3528: acctd_amount = arpcurr.functional_amount(

Line 3547: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

3543: THEN
3544: arp_standard.debug('calling mrc engine for update of gl dist data');
3545: ar_mrc_engine.maintain_mrc_data(
3546: p_event_mode => 'UPDATE',
3547: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3548: p_mode => 'BATCH',
3549: p_key_value_list => l_gl_dist_key_value_list);
3550: END IF;
3551:

Line 3568: | Updates ra_cust_trx_line_gl_dist amount columns for rows identified by |

3564: | update_amount_f_ctl_id |
3565: | |
3566: | DESCRIPTION |
3567: | |
3568: | Updates ra_cust_trx_line_gl_dist amount columns for rows identified by |
3569: | the p_customer_trx_id parameter. |
3570: | |
3571: | SCOPE - PUBLIC |
3572: | |

Line 3595: | ra_cust_trx_line_gl_dist. |

3591: | MODIFICATION HISTORY |
3592: | 24-JUL-95 Martin Johnson Created |
3593: | 14-Aug-02 Debbie Jancis Modified for MRC trigger replacement |
3594: | added calls for processing updates to |
3595: | ra_cust_trx_line_gl_dist. |
3596: | |
3597: +===========================================================================*/
3598:
3599: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN

Line 3622: UPDATE ra_cust_trx_line_gl_dist

3618: BEGIN
3619:
3620: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()+');
3621:
3622: UPDATE ra_cust_trx_line_gl_dist
3623: SET last_updated_by = pg_user_id,
3624: last_update_date = sysdate,
3625: last_update_login = pg_login_id,
3626: amount = arpcurr.CurrRound(

Line 3651: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

3647: IF arp_global.request_id is NULL then
3648: arp_standard.debug('calling mrc engine for update of gl dist data');
3649: ar_mrc_engine.maintain_mrc_data(
3650: p_event_mode => 'UPDATE',
3651: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3652: p_mode => 'BATCH',
3653: p_key_value_list => l_gl_dist_key_value_list);
3654: END IF;
3655: END IF;

Line 3672: | This procedure inserts a row into ra_cust_trx_line_gl_dists that |

3668: | PROCEDURE |
3669: | insert_p |
3670: | |
3671: | DESCRIPTION |
3672: | This procedure inserts a row into ra_cust_trx_line_gl_dists that |
3673: | contains the column values specified in the p_dist_rec parameter. |
3674: | |
3675: | SCOPE - PUBLIC |
3676: | |

Line 3704: | ra_cust_trx_line_gl_dist. |

3700: | if account_class is REC, otherwise |
3701: | populate with null. |
3702: | 14-Aug-02 Debbie Jancis Modified for MRC trigger replacement |
3703: | added calls for processing inserts to |
3704: | ra_cust_trx_line_gl_dist. |
3705: | |
3706: +===========================================================================*/
3707:
3708: PROCEDURE insert_p(

Line 3709: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

3705: | |
3706: +===========================================================================*/
3707:
3708: PROCEDURE insert_p(
3709: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3710: p_cust_trx_line_gl_dist_id
3711: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3712: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3713: DEFAULT 1,

Line 3711: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

3707:
3708: PROCEDURE insert_p(
3709: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3710: p_cust_trx_line_gl_dist_id
3711: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3712: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3713: DEFAULT 1,
3714: p_currency_code IN fnd_currencies.currency_code%type
3715: DEFAULT null,

Line 3724: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

3720: ) IS
3721:
3722:
3723: l_cust_trx_line_gl_dist_id
3724: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
3725:
3726:
3727: BEGIN
3728:

Line 3737: SELECT RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL

3733: /*---------------------------*
3734: | Get the unique identifier |
3735: *---------------------------*/
3736:
3737: SELECT RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL
3738: INTO l_cust_trx_line_gl_dist_id
3739: FROM DUAL;
3740:
3741:

Line 3746: INSERT INTO ra_cust_trx_line_gl_dist

3742: /*-------------------*
3743: | Insert the record |
3744: *-------------------*/
3745:
3746: INSERT INTO ra_cust_trx_line_gl_dist
3747: (
3748: cust_trx_line_gl_dist_id,
3749: customer_trx_id,
3750: customer_trx_line_id,

Line 3871: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

3867:
3868: arp_standard.debug('calling mrc engine for INSERT of gl dist data');
3869: ar_mrc_engine.maintain_mrc_data(
3870: p_event_mode => 'INSERT',
3871: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3872: p_mode => 'SINGLE',
3873: p_key_value => p_cust_trx_line_gl_dist_id);
3874:
3875: arp_util.debug('arp_ctlgd_pkg.insert_p()-');

Line 3990: FROM ra_cust_trx_line_gl_dist

3986: p_pct_offset_total,
3987: p_pct_offset_total_rtot_db,
3988: p_pct_suspense_total,
3989: p_pct_suspense_total_rtot_db
3990: FROM ra_cust_trx_line_gl_dist
3991: WHERE customer_trx_id = p_customer_trx_id
3992: AND customer_trx_line_id =
3993: DECODE(p_mode,
3994: 'TACC_ACC_ASSGN_SREP', customer_trx_line_id,