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

Line 18: | Sets complete_flag in ra_customer_trx to No. |

14: | PROCEDURE |
15: | make_incomplete |
16: | |
17: | DESCRIPTION |
18: | Sets complete_flag in ra_customer_trx to No. |
19: | |
20: | SCOPE - PRIVATE |
21: | |
22: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 42: ra_customer_trx.customer_trx_id%type )

38:
39: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
40:
41: PROCEDURE make_incomplete( p_customer_trx_id IN
42: ra_customer_trx.customer_trx_id%type )
43: IS
44:
45: l_trx_rec ra_customer_trx%rowtype;
46:

Line 45: l_trx_rec ra_customer_trx%rowtype;

41: PROCEDURE make_incomplete( p_customer_trx_id IN
42: ra_customer_trx.customer_trx_id%type )
43: IS
44:
45: l_trx_rec ra_customer_trx%rowtype;
46:
47: BEGIN
48:
49: IF PG_DEBUG in ('Y', 'C') THEN

Line 104: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

100: | 17-MAY-96 Martin Johnson Created |
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:

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 118: ra_customer_trx ct

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
122: WHEN NO_DATA_FOUND THEN

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 339: ra_customer_trx.customer_trx_id%type,

335: +===========================================================================*/
336:
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:

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 443: ra_customer_trx.customer_trx_id%type,

439:
440:
441: PROCEDURE header_freight_only_rules_case(
442: p_customer_trx_id IN
443: ra_customer_trx.customer_trx_id%type,
444: p_trx_amount IN number,
445: p_exchange_rate IN
446: ra_customer_trx.exchange_rate%type,
447: p_gl_date IN

Line 446: ra_customer_trx.exchange_rate%type,

442: p_customer_trx_id IN
443: ra_customer_trx.customer_trx_id%type,
444: p_trx_amount IN number,
445: p_exchange_rate IN
446: ra_customer_trx.exchange_rate%type,
447: p_gl_date IN
448: ra_cust_trx_line_gl_dist.gl_date%type
449: )
450: IS

Line 452: l_trx_rec ra_customer_trx%rowtype;

448: ra_cust_trx_line_gl_dist.gl_date%type
449: )
450: IS
451:
452: l_trx_rec ra_customer_trx%rowtype;
453: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
454:
455: BEGIN
456:

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 745: ra_customer_trx.complete_flag%type ) IS

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:
748: BEGIN
749:

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 859: ra_customer_trx.trx_date%type,

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,
860: p_header_currency_code IN
861: ra_customer_trx.invoice_currency_code%type
862: DEFAULT NULL,
863: p_header_exchange_rate IN ra_customer_trx.exchange_rate%type

Line 861: ra_customer_trx.invoice_currency_code%type

857: ra_cust_trx_line_gl_dist.gl_date%type,
858: p_trx_date IN OUT NOCOPY
859: ra_customer_trx.trx_date%type,
860: p_header_currency_code IN
861: ra_customer_trx.invoice_currency_code%type
862: DEFAULT NULL,
863: p_header_exchange_rate IN ra_customer_trx.exchange_rate%type
864: DEFAULT NULL,
865: p_status OUT NOCOPY varchar2,

Line 863: p_header_exchange_rate IN ra_customer_trx.exchange_rate%type

859: ra_customer_trx.trx_date%type,
860: p_header_currency_code IN
861: ra_customer_trx.invoice_currency_code%type
862: DEFAULT NULL,
863: p_header_exchange_rate IN ra_customer_trx.exchange_rate%type
864: DEFAULT NULL,
865: p_status OUT NOCOPY varchar2,
866: p_run_autoacc_flag IN varchar2 DEFAULT 'Y',
867: p_run_tax_flag IN varchar2 DEFAULT 'Y',

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 1214: from ra_customer_trx_lines

1210:
1211:
1212: DECLARE
1213: cursor c1 is select customer_trx_line_id
1214: from ra_customer_trx_lines
1215: where link_to_cust_trx_line_id = p_customer_trx_line_id;
1216: l_id number;
1217: BEGIN
1218: open c1;

Line 1282: | Updates a ra_customer_trx_lines record |

1278: | PROCEDURE |
1279: | update_line |
1280: | |
1281: | DESCRIPTION |
1282: | Updates a ra_customer_trx_lines record |
1283: | |
1284: | SCOPE - PUBLIC |
1285: | |
1286: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1334: ra_customer_trx_lines.customer_trx_line_id%type,

1330: PROCEDURE update_line(
1331: p_form_name IN varchar2,
1332: p_form_version IN number,
1333: p_customer_trx_line_id IN
1334: ra_customer_trx_lines.customer_trx_line_id%type,
1335: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
1336: p_foreign_currency_code IN fnd_currencies.currency_code%type,
1337: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1338: p_recalculate_tax_flag IN boolean,

Line 1335: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,

1331: p_form_name IN varchar2,
1332: p_form_version IN number,
1333: p_customer_trx_line_id IN
1334: ra_customer_trx_lines.customer_trx_line_id%type,
1335: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
1336: p_foreign_currency_code IN fnd_currencies.currency_code%type,
1337: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1338: p_recalculate_tax_flag IN boolean,
1339: p_rerun_autoacc_flag IN boolean,

Line 1337: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

1333: p_customer_trx_line_id IN
1334: ra_customer_trx_lines.customer_trx_line_id%type,
1335: p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
1336: p_foreign_currency_code IN fnd_currencies.currency_code%type,
1337: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1338: p_recalculate_tax_flag IN boolean,
1339: p_rerun_autoacc_flag IN boolean,
1340: p_rule_start_date OUT NOCOPY
1341: ra_customer_trx_lines.rule_start_date%type,

Line 1341: ra_customer_trx_lines.rule_start_date%type,

1337: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1338: p_recalculate_tax_flag IN boolean,
1339: p_rerun_autoacc_flag IN boolean,
1340: p_rule_start_date OUT NOCOPY
1341: ra_customer_trx_lines.rule_start_date%type,
1342: p_accounting_rule_duration OUT NOCOPY
1343: ra_customer_trx_lines.accounting_rule_duration%type,
1344: p_gl_date IN OUT NOCOPY
1345: ra_cust_trx_line_gl_dist.gl_date%type,

Line 1343: ra_customer_trx_lines.accounting_rule_duration%type,

1339: p_rerun_autoacc_flag IN boolean,
1340: p_rule_start_date OUT NOCOPY
1341: ra_customer_trx_lines.rule_start_date%type,
1342: p_accounting_rule_duration OUT NOCOPY
1343: ra_customer_trx_lines.accounting_rule_duration%type,
1344: p_gl_date IN OUT NOCOPY
1345: ra_cust_trx_line_gl_dist.gl_date%type,
1346: p_trx_date IN OUT NOCOPY
1347: ra_customer_trx.trx_date%type,

Line 1347: ra_customer_trx.trx_date%type,

1343: ra_customer_trx_lines.accounting_rule_duration%type,
1344: p_gl_date IN OUT NOCOPY
1345: ra_cust_trx_line_gl_dist.gl_date%type,
1346: p_trx_date IN OUT NOCOPY
1347: ra_customer_trx.trx_date%type,
1348: p_status OUT NOCOPY varchar2 )
1349: IS
1350:
1351: l_recalculate_tax_flag boolean;

Line 1356: l_db_line_rec ra_customer_trx_lines%rowtype;

1352: l_derive_gldate_flag boolean;
1353: l_amount_changed_flag boolean;
1354: l_last_period_changed_flag boolean;
1355:
1356: l_db_line_rec ra_customer_trx_lines%rowtype;
1357: l_new_line_rec ra_customer_trx_lines%rowtype;
1358:
1359: l_old_tax_amount NUMBER;
1360: l_new_tax_amount NUMBER;

Line 1357: l_new_line_rec ra_customer_trx_lines%rowtype;

1353: l_amount_changed_flag boolean;
1354: l_last_period_changed_flag boolean;
1355:
1356: l_db_line_rec ra_customer_trx_lines%rowtype;
1357: l_new_line_rec ra_customer_trx_lines%rowtype;
1358:
1359: l_old_tax_amount NUMBER;
1360: l_new_tax_amount NUMBER;
1361: l_requery_tax_if_visible BOOLEAN;

Line 1364: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;

1360: l_new_tax_amount NUMBER;
1361: l_requery_tax_if_visible BOOLEAN;
1362:
1363: l_failure_count number;
1364: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
1365: l_accounting_rule_duration
1366: ra_customer_trx_lines.accounting_rule_duration%type;
1367:
1368: l_old_trx_date date;

Line 1366: ra_customer_trx_lines.accounting_rule_duration%type;

1362:
1363: l_failure_count number;
1364: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
1365: l_accounting_rule_duration
1366: ra_customer_trx_lines.accounting_rule_duration%type;
1367:
1368: l_old_trx_date date;
1369: l_trx_date_changed boolean;
1370:

Line 1393: FROM ra_customer_trx_lines l,

1389:
1390: --{BUG#5192414
1391: CURSOR cpost IS
1392: SELECT 'Y'
1393: FROM ra_customer_trx_lines l,
1394: ra_cust_trx_line_gl_dist d
1395: WHERE l.customer_trx_line_id = p_customer_trx_line_id
1396: AND l.customer_trx_id = d.customer_trx_id
1397: AND d.account_set_flag = 'N'

Line 1725: from ra_customer_trx_lines

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
1724: cursor c1 is select customer_trx_line_id
1725: from ra_customer_trx_lines
1726: where link_to_cust_trx_line_id = p_customer_trx_line_id;
1727: l_id number;
1728: BEGIN
1729: open c1;

Line 1797: | Deletes records from ra_customer_trx_lines |

1793: | PROCEDURE |
1794: | delete_line |
1795: | |
1796: | DESCRIPTION |
1797: | Deletes records from ra_customer_trx_lines |
1798: | |
1799: | SCOPE - PUBLIC |
1800: | |
1801: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1843: ra_customer_trx_lines.customer_trx_line_id%type,

1839:
1840: PROCEDURE delete_line(p_form_name IN varchar2,
1841: p_form_version IN number,
1842: p_customer_trx_line_id IN
1843: ra_customer_trx_lines.customer_trx_line_id%type,
1844: p_complete_flag IN ra_customer_trx.complete_flag%type,
1845: p_recalculate_tax_flag IN boolean,
1846: p_trx_amount IN number,
1847: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 1844: p_complete_flag IN ra_customer_trx.complete_flag%type,

1840: PROCEDURE delete_line(p_form_name IN varchar2,
1841: p_form_version IN number,
1842: p_customer_trx_line_id IN
1843: ra_customer_trx_lines.customer_trx_line_id%type,
1844: p_complete_flag IN ra_customer_trx.complete_flag%type,
1845: p_recalculate_tax_flag IN boolean,
1846: p_trx_amount IN number,
1847: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1848: p_header_currency_code IN fnd_currencies.currency_code%type,

Line 1847: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

1843: ra_customer_trx_lines.customer_trx_line_id%type,
1844: p_complete_flag IN ra_customer_trx.complete_flag%type,
1845: p_recalculate_tax_flag IN boolean,
1846: p_trx_amount IN number,
1847: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1848: p_header_currency_code IN fnd_currencies.currency_code%type,
1849: p_gl_date IN OUT NOCOPY ra_cust_trx_line_gl_dist.gl_date%type,
1850: p_trx_date IN OUT NOCOPY ra_customer_trx.trx_date%type,
1851: p_line_rec IN ra_customer_trx_lines%rowtype,

Line 1850: p_trx_date IN OUT NOCOPY ra_customer_trx.trx_date%type,

1846: p_trx_amount IN number,
1847: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1848: p_header_currency_code IN fnd_currencies.currency_code%type,
1849: p_gl_date IN OUT NOCOPY ra_cust_trx_line_gl_dist.gl_date%type,
1850: p_trx_date IN OUT NOCOPY ra_customer_trx.trx_date%type,
1851: p_line_rec IN ra_customer_trx_lines%rowtype,
1852: p_status OUT NOCOPY varchar2 ) IS
1853:
1854: l_recalculate_tax_flag boolean;

Line 1851: p_line_rec IN ra_customer_trx_lines%rowtype,

1847: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1848: p_header_currency_code IN fnd_currencies.currency_code%type,
1849: p_gl_date IN OUT NOCOPY ra_cust_trx_line_gl_dist.gl_date%type,
1850: p_trx_date IN OUT NOCOPY ra_customer_trx.trx_date%type,
1851: p_line_rec IN ra_customer_trx_lines%rowtype,
1852: p_status OUT NOCOPY varchar2 ) IS
1853:
1854: l_recalculate_tax_flag boolean;
1855: l_old_tax_amount NUMBER;

Line 1862: from ra_customer_trx_lines ctl,

1858:
1859: --added for bug 7478499
1860: CURSOR cont_cursor IS
1861: select alc.customer_trx_line_id
1862: from ra_customer_trx_lines ctl,
1863: ar_line_conts alc
1864: where
1865: ctl.customer_trx_line_id = p_customer_trx_line_id
1866: and ctl.customer_trx_line_id = alc.customer_trx_line_id