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_PROCESS_LINE dependencies on RA_CUSTOMER_TRX_LINES

Line 105: p_commitment_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type )

101: | |
102: +===========================================================================*/
103: PROCEDURE get_commitment_line_id(
104: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
105: p_commitment_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type )
106: IS
107: BEGIN
108:
109: IF PG_DEBUG in ('Y', 'C') THEN

Line 117: FROM ra_customer_trx_lines ctl,

113: BEGIN
114:
115: SELECT customer_trx_line_id
116: INTO p_commitment_line_id
117: FROM ra_customer_trx_lines ctl,
118: ra_customer_trx ct
119: WHERE ct.customer_trx_id = p_customer_trx_id
120: AND ctl.customer_trx_id = ct.initial_customer_trx_id;
121: EXCEPTION

Line 186: PROCEDURE set_flags( p_line_rec IN ra_customer_trx_lines%rowtype,

182: | 08-Jun-04 Naruhiko Yanagita Bug:3678009 |
183: | Added a condition for unit_selling_price|
184: +===========================================================================*/
185:
186: PROCEDURE set_flags( p_line_rec IN ra_customer_trx_lines%rowtype,
187: p_old_line_rec IN ra_customer_trx_lines%rowtype,
188: p_customer_trx_line_id IN
189: ra_customer_trx_lines.customer_trx_line_id%type,
190: p_derive_gl_date_flag OUT NOCOPY boolean,

Line 187: p_old_line_rec IN ra_customer_trx_lines%rowtype,

183: | Added a condition for unit_selling_price|
184: +===========================================================================*/
185:
186: PROCEDURE set_flags( p_line_rec IN ra_customer_trx_lines%rowtype,
187: p_old_line_rec IN ra_customer_trx_lines%rowtype,
188: p_customer_trx_line_id IN
189: ra_customer_trx_lines.customer_trx_line_id%type,
190: p_derive_gl_date_flag OUT NOCOPY boolean,
191: p_amount_changed_flag OUT NOCOPY boolean,

Line 189: ra_customer_trx_lines.customer_trx_line_id%type,

185:
186: PROCEDURE set_flags( p_line_rec IN ra_customer_trx_lines%rowtype,
187: p_old_line_rec IN ra_customer_trx_lines%rowtype,
188: p_customer_trx_line_id IN
189: ra_customer_trx_lines.customer_trx_line_id%type,
190: p_derive_gl_date_flag OUT NOCOPY boolean,
191: p_amount_changed_flag OUT NOCOPY boolean,
192: p_last_period_changed_flag OUT NOCOPY boolean) IS
193:

Line 341: ra_customer_trx_lines.customer_trx_line_id%type

337: PROCEDURE line_rerun_aa(
338: p_customer_trx_id IN
339: ra_customer_trx.customer_trx_id%type,
340: p_customer_trx_line_id IN
341: ra_customer_trx_lines.customer_trx_line_id%type
342: ) IS
343:
344: l_ccid binary_integer;
345: l_concat_segments varchar2(2000);

Line 562: PROCEDURE val_insert_line ( p_line_rec IN ra_customer_trx_lines%rowtype ) IS

558: | |
559: +===========================================================================*/
560:
561:
562: PROCEDURE val_insert_line ( p_line_rec IN ra_customer_trx_lines%rowtype ) IS
563:
564:
565: BEGIN
566:

Line 637: PROCEDURE val_update_line ( p_line_rec IN ra_customer_trx_lines%rowtype,

633: | |
634: +===========================================================================*/
635:
636:
637: PROCEDURE val_update_line ( p_line_rec IN ra_customer_trx_lines%rowtype,
638: p_db_line_rec IN ra_customer_trx_lines%rowtype,
639: p_new_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype )
640: IS
641:

Line 638: p_db_line_rec IN ra_customer_trx_lines%rowtype,

634: +===========================================================================*/
635:
636:
637: PROCEDURE val_update_line ( p_line_rec IN ra_customer_trx_lines%rowtype,
638: p_db_line_rec IN ra_customer_trx_lines%rowtype,
639: p_new_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype )
640: IS
641:
642: l_errorbuf varchar2(200);

Line 639: p_new_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype )

635:
636:
637: PROCEDURE val_update_line ( p_line_rec IN ra_customer_trx_lines%rowtype,
638: p_db_line_rec IN ra_customer_trx_lines%rowtype,
639: p_new_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype )
640: IS
641:
642: l_errorbuf varchar2(200);
643:

Line 644: l_line_rec ra_customer_trx_lines%rowtype;

640: IS
641:
642: l_errorbuf varchar2(200);
643:
644: l_line_rec ra_customer_trx_lines%rowtype;
645:
646: BEGIN
647:
648: arp_util.debug('arp_process_line.val_update_line()+');

Line 743: PROCEDURE val_delete_line ( p_line_rec IN ra_customer_trx_lines%rowtype,

739: | |
740: +===========================================================================*/
741:
742:
743: PROCEDURE val_delete_line ( p_line_rec IN ra_customer_trx_lines%rowtype,
744: p_complete_flag IN
745: ra_customer_trx.complete_flag%type ) IS
746:
747:

Line 779: | Inserts a record into ra_customer_trx_lines. |

775: | PROCEDURE |
776: | insert_line |
777: | |
778: | DESCRIPTION |
779: | Inserts a record into ra_customer_trx_lines. |
780: | |
781: | SCOPE - PUBLIC |
782: | |
783: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 836: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,

832:
833: PROCEDURE insert_line(
834: p_form_name IN varchar2,
835: p_form_version IN number,
836: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
837: p_memo_line_type IN ar_memo_lines.line_type%type,
838: p_customer_trx_line_id OUT NOCOPY
839: ra_customer_trx_lines.customer_trx_line_id%type,
840: p_trx_class IN ra_cust_trx_types.type%type

Line 839: ra_customer_trx_lines.customer_trx_line_id%type,

835: p_form_version IN number,
836: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
837: p_memo_line_type IN ar_memo_lines.line_type%type,
838: p_customer_trx_line_id OUT NOCOPY
839: ra_customer_trx_lines.customer_trx_line_id%type,
840: p_trx_class IN ra_cust_trx_types.type%type
841: DEFAULT NULL,
842: p_ccid1 IN
843: gl_code_combinations.code_combination_id%type

Line 853: ra_customer_trx_lines.rule_start_date%type,

849: DEFAULT NULL,
850: p_amount2 IN ra_cust_trx_line_gl_dist.amount%type
851: DEFAULT NULL,
852: p_rule_start_date OUT NOCOPY
853: ra_customer_trx_lines.rule_start_date%type,
854: p_accounting_rule_duration OUT NOCOPY
855: ra_customer_trx_lines.accounting_rule_duration%type,
856: p_gl_date IN OUT NOCOPY
857: ra_cust_trx_line_gl_dist.gl_date%type,

Line 855: ra_customer_trx_lines.accounting_rule_duration%type,

851: DEFAULT NULL,
852: p_rule_start_date OUT NOCOPY
853: ra_customer_trx_lines.rule_start_date%type,
854: p_accounting_rule_duration OUT NOCOPY
855: ra_customer_trx_lines.accounting_rule_duration%type,
856: p_gl_date IN OUT NOCOPY
857: ra_cust_trx_line_gl_dist.gl_date%type,
858: p_trx_date IN OUT NOCOPY
859: ra_customer_trx.trx_date%type,

Line 878: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

874: l_num_failed_dist_rows number;
875: l_errorbuf varchar2(200);
876: l_result number;
877:
878: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
879: l_new_tax_amount NUMBER;
880:
881: l_failure_count number;
882: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;

Line 882: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;

878: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
879: l_new_tax_amount NUMBER;
880:
881: l_failure_count number;
882: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
883: l_accounting_rule_duration
884: ra_customer_trx_lines.accounting_rule_duration%type;
885:
886: l_recalculate_tax_flag boolean;

Line 884: ra_customer_trx_lines.accounting_rule_duration%type;

880:
881: l_failure_count number;
882: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
883: l_accounting_rule_duration
884: ra_customer_trx_lines.accounting_rule_duration%type;
885:
886: l_recalculate_tax_flag boolean;
887: l_status1 varchar2(100);
888: l_status2 varchar2(100);

Line 892: l_commitment_line_id ra_customer_trx_lines.customer_trx_line_id%type;

888: l_status2 varchar2(100);
889: l_status3 varchar2(100);
890: l_status4 varchar2(100);
891:
892: l_commitment_line_id ra_customer_trx_lines.customer_trx_line_id%type;
893: l_line_rec ra_customer_trx_lines%rowtype;
894:
895: l_extended_amount NUMBER;
896: l_unit_selling_price NUMBER;

Line 893: l_line_rec ra_customer_trx_lines%rowtype;

889: l_status3 varchar2(100);
890: l_status4 varchar2(100);
891:
892: l_commitment_line_id ra_customer_trx_lines.customer_trx_line_id%type;
893: l_line_rec ra_customer_trx_lines%rowtype;
894:
895: l_extended_amount NUMBER;
896: l_unit_selling_price NUMBER;
897: l_gross_extended_amount NUMBER;

Line 1228: from ra_customer_trx_lines

1224:
1225:
1226: DECLARE
1227: cursor c1 is select customer_trx_line_id
1228: from ra_customer_trx_lines
1229: where link_to_cust_trx_line_id = p_customer_trx_line_id;
1230: l_id number;
1231: BEGIN
1232: open c1;

Line 1296: | Updates a ra_customer_trx_lines record |

1292: | PROCEDURE |
1293: | update_line |
1294: | |
1295: | DESCRIPTION |
1296: | Updates a ra_customer_trx_lines record |
1297: | |
1298: | SCOPE - PUBLIC |
1299: | |
1300: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1348: ra_customer_trx_lines.customer_trx_line_id%type,

1344: PROCEDURE update_line(
1345: p_form_name IN varchar2,
1346: p_form_version IN number,
1347: p_customer_trx_line_id IN
1348: ra_customer_trx_lines.customer_trx_line_id%type,
1349: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
1350: p_foreign_currency_code IN fnd_currencies.currency_code%type,
1351: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1352: p_recalculate_tax_flag IN boolean,

Line 1349: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,

1345: p_form_name IN varchar2,
1346: p_form_version IN number,
1347: p_customer_trx_line_id IN
1348: ra_customer_trx_lines.customer_trx_line_id%type,
1349: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
1350: p_foreign_currency_code IN fnd_currencies.currency_code%type,
1351: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1352: p_recalculate_tax_flag IN boolean,
1353: p_rerun_autoacc_flag IN boolean,

Line 1355: ra_customer_trx_lines.rule_start_date%type,

1351: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1352: p_recalculate_tax_flag IN boolean,
1353: p_rerun_autoacc_flag IN boolean,
1354: p_rule_start_date OUT NOCOPY
1355: ra_customer_trx_lines.rule_start_date%type,
1356: p_accounting_rule_duration OUT NOCOPY
1357: ra_customer_trx_lines.accounting_rule_duration%type,
1358: p_gl_date IN OUT NOCOPY
1359: ra_cust_trx_line_gl_dist.gl_date%type,

Line 1357: ra_customer_trx_lines.accounting_rule_duration%type,

1353: p_rerun_autoacc_flag IN boolean,
1354: p_rule_start_date OUT NOCOPY
1355: ra_customer_trx_lines.rule_start_date%type,
1356: p_accounting_rule_duration OUT NOCOPY
1357: ra_customer_trx_lines.accounting_rule_duration%type,
1358: p_gl_date IN OUT NOCOPY
1359: ra_cust_trx_line_gl_dist.gl_date%type,
1360: p_trx_date IN OUT NOCOPY
1361: ra_customer_trx.trx_date%type,

Line 1370: l_db_line_rec ra_customer_trx_lines%rowtype;

1366: l_derive_gldate_flag boolean;
1367: l_amount_changed_flag boolean;
1368: l_last_period_changed_flag boolean;
1369:
1370: l_db_line_rec ra_customer_trx_lines%rowtype;
1371: l_new_line_rec ra_customer_trx_lines%rowtype;
1372:
1373: l_old_tax_amount NUMBER;
1374: l_new_tax_amount NUMBER;

Line 1371: l_new_line_rec ra_customer_trx_lines%rowtype;

1367: l_amount_changed_flag boolean;
1368: l_last_period_changed_flag boolean;
1369:
1370: l_db_line_rec ra_customer_trx_lines%rowtype;
1371: l_new_line_rec ra_customer_trx_lines%rowtype;
1372:
1373: l_old_tax_amount NUMBER;
1374: l_new_tax_amount NUMBER;
1375: l_requery_tax_if_visible BOOLEAN;

Line 1378: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;

1374: l_new_tax_amount NUMBER;
1375: l_requery_tax_if_visible BOOLEAN;
1376:
1377: l_failure_count number;
1378: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
1379: l_accounting_rule_duration
1380: ra_customer_trx_lines.accounting_rule_duration%type;
1381:
1382: l_old_trx_date date;

Line 1380: ra_customer_trx_lines.accounting_rule_duration%type;

1376:
1377: l_failure_count number;
1378: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
1379: l_accounting_rule_duration
1380: ra_customer_trx_lines.accounting_rule_duration%type;
1381:
1382: l_old_trx_date date;
1383: l_trx_date_changed boolean;
1384:

Line 1407: FROM ra_customer_trx_lines l,

1403:
1404: --{BUG#5192414
1405: CURSOR cpost IS
1406: SELECT 'Y'
1407: FROM ra_customer_trx_lines l,
1408: ra_cust_trx_line_gl_dist d
1409: WHERE l.customer_trx_line_id = p_customer_trx_line_id
1410: AND l.customer_trx_id = d.customer_trx_id
1411: AND d.account_set_flag = 'N'

Line 1739: from ra_customer_trx_lines

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
1738: cursor c1 is select customer_trx_line_id
1739: from ra_customer_trx_lines
1740: where link_to_cust_trx_line_id = p_customer_trx_line_id;
1741: l_id number;
1742: BEGIN
1743: open c1;

Line 1811: | Deletes records from ra_customer_trx_lines |

1807: | PROCEDURE |
1808: | delete_line |
1809: | |
1810: | DESCRIPTION |
1811: | Deletes records from ra_customer_trx_lines |
1812: | |
1813: | SCOPE - PUBLIC |
1814: | |
1815: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1857: ra_customer_trx_lines.customer_trx_line_id%type,

1853:
1854: PROCEDURE delete_line(p_form_name IN varchar2,
1855: p_form_version IN number,
1856: p_customer_trx_line_id IN
1857: ra_customer_trx_lines.customer_trx_line_id%type,
1858: p_complete_flag IN ra_customer_trx.complete_flag%type,
1859: p_recalculate_tax_flag IN boolean,
1860: p_trx_amount IN number,
1861: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 1865: p_line_rec IN ra_customer_trx_lines%rowtype,

1861: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1862: p_header_currency_code IN fnd_currencies.currency_code%type,
1863: p_gl_date IN OUT NOCOPY ra_cust_trx_line_gl_dist.gl_date%type,
1864: p_trx_date IN OUT NOCOPY ra_customer_trx.trx_date%type,
1865: p_line_rec IN ra_customer_trx_lines%rowtype,
1866: p_status OUT NOCOPY varchar2 ) IS
1867:
1868: l_recalculate_tax_flag boolean;
1869: l_old_tax_amount NUMBER;

Line 1876: from ra_customer_trx_lines ctl,

1872:
1873: --added for bug 7478499
1874: CURSOR cont_cursor IS
1875: select alc.customer_trx_line_id
1876: from ra_customer_trx_lines ctl,
1877: ar_line_conts alc
1878: where
1879: ctl.customer_trx_line_id = p_customer_trx_line_id
1880: and ctl.customer_trx_line_id = alc.customer_trx_line_id