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_HEADER dependencies on RA_CUSTOMER_TRX

Line 26: | Validates row that is going to be inserted into ra_customer_trx. |

22: | PROCEDURE |
23: | validate_insert_header |
24: | |
25: | DESCRIPTION |
26: | Validates row that is going to be inserted into ra_customer_trx. |
27: | |
28: | SCOPE - PRIVATE |
29: | |
30: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 49: PROCEDURE validate_insert_header( l_trx_rec IN ra_customer_trx%rowtype,

45: | to validate complete_flag |
46: | |
47: +===========================================================================*/
48:
49: PROCEDURE validate_insert_header( l_trx_rec IN ra_customer_trx%rowtype,
50: l_status OUT NOCOPY varchar2 ) IS
51:
52: BEGIN
53:

Line 75: | Validates row that is going to be updated in ra_customer_trx. |

71: | PROCEDURE |
72: | validate_update_header |
73: | |
74: | DESCRIPTION |
75: | Validates row that is going to be updated in ra_customer_trx. |
76: | |
77: | SCOPE - PRIVATE |
78: | |
79: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 115: | Validates row that is going to be delete from ra_customer_trx. |

111: | PROCEDURE |
112: | validate_delete_header |
113: | |
114: | DESCRIPTION |
115: | Validates row that is going to be delete from ra_customer_trx. |
116: | |
117: | SCOPE - PRIVATE |
118: | |
119: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 192: ra_customer_trx.customer_trx_id%type,

188: | for SELECT that fetches gl_date
189: +===========================================================================*/
190:
191: PROCEDURE set_flags(p_customer_trx_id IN
192: ra_customer_trx.customer_trx_id%type,
193: p_new_trx_rec IN ra_customer_trx%rowtype,
194: p_new_gl_date IN
195: ra_cust_trx_line_gl_dist.gl_date%type,
196: p_new_open_rec_flag IN

Line 193: p_new_trx_rec IN ra_customer_trx%rowtype,

189: +===========================================================================*/
190:
191: PROCEDURE set_flags(p_customer_trx_id IN
192: ra_customer_trx.customer_trx_id%type,
193: p_new_trx_rec IN ra_customer_trx%rowtype,
194: p_new_gl_date IN
195: ra_cust_trx_line_gl_dist.gl_date%type,
196: p_new_open_rec_flag IN
197: ra_cust_trx_types.accounting_affect_flag%type,

Line 208: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype,

204: p_complete_changed_flag OUT NOCOPY boolean,
205: p_open_rec_changed_flag OUT NOCOPY boolean,
206: p_dispute_changed_flag OUT NOCOPY boolean,
207: p_number_of_payment_schedules OUT NOCOPY NUMBER,
208: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
209: p_cust_trx_type_changed_flag OUT NOCOPY boolean)
210: IS
211:
212: l_old_trx_rec ra_customer_trx%rowtype;

Line 212: l_old_trx_rec ra_customer_trx%rowtype;

208: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
209: p_cust_trx_type_changed_flag OUT NOCOPY boolean)
210: IS
211:
212: l_old_trx_rec ra_customer_trx%rowtype;
213: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
214: l_old_open_rec_flag ra_cust_trx_types.accounting_affect_flag%type;
215: l_old_dispute_amount ar_payment_schedules.amount_in_dispute%type;
216: ld_old_dispute_date DATE;

Line 420: FROM ra_cust_trx_line_gl_dist gld, ra_customer_trx ra

416:
417:
418: CURSOR c_ct IS
419: SELECT distinct gld.event_id event_id
420: FROM ra_cust_trx_line_gl_dist gld, ra_customer_trx ra
421: WHERE gld.customer_trx_id = p_customer_trx_id
422: and gld.customer_trx_id = ra.customer_trx_id
423: and ra.invoicing_rule_id is NULL
424: and gld.gl_date <> p_gl_date

Line 422: and gld.customer_trx_id = ra.customer_trx_id

418: CURSOR c_ct IS
419: SELECT distinct gld.event_id event_id
420: FROM ra_cust_trx_line_gl_dist gld, ra_customer_trx ra
421: WHERE gld.customer_trx_id = p_customer_trx_id
422: and gld.customer_trx_id = ra.customer_trx_id
423: and ra.invoicing_rule_id is NULL
424: and gld.gl_date <> p_gl_date
425: and gld.account_class = 'REC'
426: and gld.posting_control_id = -3

Line 434: and nvl(source_id_int_1 , -99) = ra.customer_trx_id

430: (Select 1 from xla_events
431: where entity_id in (
432: Select entity_id from xla_transaction_entities
433: where entity_code = 'TRANSACTIONS'
434: and nvl(source_id_int_1 , -99) = ra.customer_trx_id
435: and ledger_id = ra.set_of_books_id
436: and application_id = 222 ));
437:
438:

Line 750: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type

746: | |
747: +===========================================================================*/
748:
749: PROCEDURE reverse_revrec_effect (
750: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
751: ) IS
752:
753: l_line_rec ra_customer_trx_lines%rowtype;
754: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 753: l_line_rec ra_customer_trx_lines%rowtype;

749: PROCEDURE reverse_revrec_effect (
750: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
751: ) IS
752:
753: l_line_rec ra_customer_trx_lines%rowtype;
754: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
755: BEGIN
756:
757: arp_util.debug('arp_process_header.reverse_revrec_effect()+');

Line 824: | Inserts a record into ra_customer_trx. |

820: | PROCEDURE |
821: | insert_header |
822: | |
823: | DESCRIPTION |
824: | Inserts a record into ra_customer_trx. |
825: | |
826: | SCOPE - PUBLIC |
827: | |
828: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 857: p_trx_rec IN ra_customer_trx%rowtype,

853:
854: PROCEDURE insert_header(
855: p_form_name IN varchar2,
856: p_form_version IN number,
857: p_trx_rec IN ra_customer_trx%rowtype,
858: p_trx_class IN ra_cust_trx_types.type%type,
859: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
860: p_term_in_use_flag IN varchar2,
861: p_commitment_rec IN arp_process_commitment.commitment_rec_type,

Line 862: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,

858: p_trx_class IN ra_cust_trx_types.type%type,
859: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
860: p_term_in_use_flag IN varchar2,
861: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
862: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
863: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
864: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
865: p_row_id OUT NOCOPY rowid,
866: p_status OUT NOCOPY varchar2,

Line 863: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

859: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
860: p_term_in_use_flag IN varchar2,
861: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
862: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
863: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
864: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
865: p_row_id OUT NOCOPY rowid,
866: p_status OUT NOCOPY varchar2,
867: p_receivable_ccid IN gl_code_combinations.code_combination_id%type

Line 864: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,

860: p_term_in_use_flag IN varchar2,
861: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
862: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
863: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
864: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
865: p_row_id OUT NOCOPY rowid,
866: p_status OUT NOCOPY varchar2,
867: p_receivable_ccid IN gl_code_combinations.code_combination_id%type
868: DEFAULT NULL,

Line 874: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

870: p_create_default_sc_flag IN varchar2 DEFAULT 'Y' )
871:
872: IS
873:
874: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
875: l_result number;
876: l_ccid number;
877: l_concat_segments varchar2(2000);
878: l_num_failed_dist_rows number;

Line 882: l_trx_rec ra_customer_trx%rowtype;

878: l_num_failed_dist_rows number;
879: l_errorbuf varchar2(200);
880:
881: l_remit_to_address_rec arp_trx_defaults_3.address_rec_type;
882: l_trx_rec ra_customer_trx%rowtype;
883: l_status1 varchar2(100);
884: l_status2 varchar2(100);
885: --Bug# 2750340
886: l_ev_rec arp_xla_events.xla_events_type;

Line 1105: | Updates a record into ra_customer_trx. |

1101: | PROCEDURE |
1102: | update_header |
1103: | |
1104: | DESCRIPTION |
1105: | Updates a record into ra_customer_trx. |
1106: | |
1107: | SCOPE - PUBLIC |
1108: | |
1109: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1133: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

1129:
1130: PROCEDURE update_header(
1131: p_form_name IN varchar2,
1132: p_form_version IN number,
1133: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1134: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1135: p_trx_amount IN number,
1136: p_trx_class IN ra_cust_trx_types.type%type,
1137: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 1134: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1130: PROCEDURE update_header(
1131: p_form_name IN varchar2,
1132: p_form_version IN number,
1133: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1134: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1135: p_trx_amount IN number,
1136: p_trx_class IN ra_cust_trx_types.type%type,
1137: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1138: p_initial_customer_trx_line_id IN

Line 1139: ra_customer_trx_lines.initial_customer_trx_line_id%type

1135: p_trx_amount IN number,
1136: p_trx_class IN ra_cust_trx_types.type%type,
1137: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1138: p_initial_customer_trx_line_id IN
1139: ra_customer_trx_lines.initial_customer_trx_line_id%type
1140: default null,
1141: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1142: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
1143: p_term_in_use_flag IN varchar2,

Line 1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;

1159: l_dispute_changed_flag boolean;
1160: l_cust_trx_type_changed_flag boolean;
1161:
1162: l_initial_customer_trx_line_id
1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1164: l_exchange_rate ra_customer_trx.exchange_rate%type;
1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;

Line 1164: l_exchange_rate ra_customer_trx.exchange_rate%type;

1160: l_cust_trx_type_changed_flag boolean;
1161:
1162: l_initial_customer_trx_line_id
1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1164: l_exchange_rate ra_customer_trx.exchange_rate%type;
1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;
1168: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;

1161:
1162: l_initial_customer_trx_line_id
1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1164: l_exchange_rate ra_customer_trx.exchange_rate%type;
1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;
1168: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1169:

Line 1167: l_line_rec ra_customer_trx_lines%rowtype;

1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1164: l_exchange_rate ra_customer_trx.exchange_rate%type;
1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;
1168: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1169:
1170: l_old_trx_rec ra_customer_trx%rowtype;
1171:

Line 1170: l_old_trx_rec ra_customer_trx%rowtype;

1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;
1168: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1169:
1170: l_old_trx_rec ra_customer_trx%rowtype;
1171:
1172: l_number_of_pay_scheds NUMBER;
1173: l_new_tax_amount NUMBER;
1174: l_recalc_tax BOOLEAN;

Line 1405: FROM ra_customer_trx_lines

1401: THEN
1402: arp_util.debug('Clearing Lines and dist Rule Info ()+');
1403: BEGIN
1404: Select 'X' INTO l_dummy_flag
1405: FROM ra_customer_trx_lines
1406: WHERE customer_trx_id = p_customer_trx_id
1407: AND rownum = 1;
1408:
1409: arp_ctl_pkg.set_to_dummy( l_line_rec );

Line 1605: -- update ra_customer_trx_lines.initial_customer_trx_line_id

1601: AND
1602: nvl(p_trx_rec.initial_customer_trx_id, 0) <> pg_number_dummy)
1603: )
1604: THEN
1605: -- update ra_customer_trx_lines.initial_customer_trx_line_id
1606: IF (p_trx_rec.initial_customer_trx_id IS NOT NULL
1607: AND
1608: p_initial_customer_trx_line_id IS NULL)
1609: THEN

Line 1613: FROM ra_customer_trx_lines ctl

1609: THEN
1610: BEGIN
1611: SELECT customer_trx_line_id
1612: INTO l_initial_customer_trx_line_id
1613: FROM ra_customer_trx_lines ctl
1614: WHERE ctl.customer_trx_id = p_trx_rec.initial_customer_trx_id
1615: AND ctl.line_type = 'LINE';
1616: END;
1617: ELSE

Line 1747: ra_customer_trx ct ,

1743: l_event_source_info.application_id,
1744: l_post_to_gl,
1745: l_event_status_code
1746: from
1747: ra_customer_trx ct ,
1748: ra_cust_trx_types ctt,
1749: xla_transaction_entities_upg xet ,
1750: xla_events xe
1751: where ct.customer_trx_id = p_customer_trx_id

Line 1841: from ra_customer_trx_lines ctl,

1837:
1838: PROCEDURE delete_cont_defer_data(p_customer_trx_id IN NUMBER) IS
1839: CURSOR cont_cursor IS
1840: select alc.customer_trx_line_id
1841: from ra_customer_trx_lines ctl,
1842: ar_line_conts alc
1843: where
1844: ctl.customer_trx_id = p_customer_trx_id
1845: and ctl.customer_trx_line_id = alc.customer_trx_line_id

Line 1884: | deletes row from ra_customer_trx. Also deletes all child rows. |

1880: | PROCEDURE |
1881: | delete_header |
1882: | |
1883: | DESCRIPTION |
1884: | deletes row from ra_customer_trx. Also deletes all child rows. |
1885: | |
1886: | SCOPE - PUBLIC |
1887: | |
1888: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2008: ra_customer_trx.customer_trx_id%type,

2004: +===========================================================================*/
2005: PROCEDURE post_commit( p_form_name IN varchar2,
2006: p_form_version IN number,
2007: p_customer_trx_id IN
2008: ra_customer_trx.customer_trx_id%type,
2009: p_previous_customer_trx_id IN
2010: ra_customer_trx.previous_customer_trx_id%type,
2011: p_complete_flag IN
2012: ra_customer_trx.complete_flag%type,

Line 2010: ra_customer_trx.previous_customer_trx_id%type,

2006: p_form_version IN number,
2007: p_customer_trx_id IN
2008: ra_customer_trx.customer_trx_id%type,
2009: p_previous_customer_trx_id IN
2010: ra_customer_trx.previous_customer_trx_id%type,
2011: p_complete_flag IN
2012: ra_customer_trx.complete_flag%type,
2013: p_trx_open_receivables_flag IN
2014: ra_cust_trx_types.accounting_affect_flag%type,

Line 2012: ra_customer_trx.complete_flag%type,

2008: ra_customer_trx.customer_trx_id%type,
2009: p_previous_customer_trx_id IN
2010: ra_customer_trx.previous_customer_trx_id%type,
2011: p_complete_flag IN
2012: ra_customer_trx.complete_flag%type,
2013: p_trx_open_receivables_flag IN
2014: ra_cust_trx_types.accounting_affect_flag%type,
2015: p_prev_open_receivables_flag IN
2016: ra_cust_trx_types.accounting_affect_flag%type,

Line 2087: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

2083:
2084: PROCEDURE update_header_freight_cover(
2085: p_form_name IN varchar2,
2086: p_form_version IN number,
2087: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2088: p_trx_class IN ra_cust_trx_types.type%type,
2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2090: p_ship_via IN ra_customer_trx.ship_via%type,
2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

Line 2090: p_ship_via IN ra_customer_trx.ship_via%type,

2086: p_form_version IN number,
2087: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2088: p_trx_class IN ra_cust_trx_types.type%type,
2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2090: p_ship_via IN ra_customer_trx.ship_via%type,
2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2092: p_waybill_number IN ra_customer_trx.waybill_number%type,
2093: p_fob_point IN ra_customer_trx.fob_point%type,
2094: p_status OUT NOCOPY varchar2)

Line 2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

2087: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2088: p_trx_class IN ra_cust_trx_types.type%type,
2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2090: p_ship_via IN ra_customer_trx.ship_via%type,
2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2092: p_waybill_number IN ra_customer_trx.waybill_number%type,
2093: p_fob_point IN ra_customer_trx.fob_point%type,
2094: p_status OUT NOCOPY varchar2)
2095:

Line 2092: p_waybill_number IN ra_customer_trx.waybill_number%type,

2088: p_trx_class IN ra_cust_trx_types.type%type,
2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2090: p_ship_via IN ra_customer_trx.ship_via%type,
2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2092: p_waybill_number IN ra_customer_trx.waybill_number%type,
2093: p_fob_point IN ra_customer_trx.fob_point%type,
2094: p_status OUT NOCOPY varchar2)
2095:
2096: IS

Line 2093: p_fob_point IN ra_customer_trx.fob_point%type,

2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2090: p_ship_via IN ra_customer_trx.ship_via%type,
2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2092: p_waybill_number IN ra_customer_trx.waybill_number%type,
2093: p_fob_point IN ra_customer_trx.fob_point%type,
2094: p_status OUT NOCOPY varchar2)
2095:
2096: IS
2097:

Line 2098: l_trx_rec ra_customer_trx%rowtype;

2094: p_status OUT NOCOPY varchar2)
2095:
2096: IS
2097:
2098: l_trx_rec ra_customer_trx%rowtype;
2099: l_commit_rec arp_process_commitment.commitment_rec_type;
2100: l_dummy varchar2(80);
2101:
2102: BEGIN

Line 2161: | This procedure was created so that the ra_customer_trx_v view could |

2157: | - The transaction is a commitment |
2158: | - The transaction is a credit memo against a specific transaction |
2159: | (not on account). |
2160: | |
2161: | This procedure was created so that the ra_customer_trx_v view could |
2162: | be simplified by removing koins to support these special cases. |
2163: | |
2164: | SCOPE - PUBLIC |
2165: | |

Line 2338: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;

2334: p_commit_memo_line_id OUT NOCOPY number,
2335: p_commit_memo_line_desc OUT NOCOPY varchar2
2336: ) IS
2337:
2338: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2339: l_ct_commitment_number ra_customer_trx.trx_number%type;
2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;

Line 2339: l_ct_commitment_number ra_customer_trx.trx_number%type;

2335: p_commit_memo_line_desc OUT NOCOPY varchar2
2336: ) IS
2337:
2338: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2339: l_ct_commitment_number ra_customer_trx.trx_number%type;
2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;

Line 2342: ra_customer_trx_lines.customer_trx_line_id%type;

2338: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2339: l_ct_commitment_number ra_customer_trx.trx_number%type;
2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context

Line 2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;

2339: l_ct_commitment_number ra_customer_trx.trx_number%type;
2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;

Line 2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;

2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1

Line 2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;

2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;

Line 2347: ra_customer_trx_lines.interface_line_context%type;

2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;

Line 2349: ra_customer_trx_lines.interface_line_attribute1%type;

2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;

Line 2351: ra_customer_trx_lines.interface_line_attribute2%type;

2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;

Line 2353: ra_customer_trx_lines.interface_line_attribute3%type;

2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;

Line 2355: ra_customer_trx_lines.interface_line_attribute4%type;

2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;

Line 2357: ra_customer_trx_lines.interface_line_attribute5%type;

2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;

Line 2359: ra_customer_trx_lines.interface_line_attribute6%type;

2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;

Line 2361: ra_customer_trx_lines.interface_line_attribute7%type;

2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;

Line 2363: ra_customer_trx_lines.interface_line_attribute8%type;

2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;

Line 2365: ra_customer_trx_lines.interface_line_attribute9%type;

2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;

Line 2367: ra_customer_trx_lines.interface_line_attribute10%type;

2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;

Line 2369: ra_customer_trx_lines.interface_line_attribute11%type;

2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;

Line 2371: ra_customer_trx_lines.interface_line_attribute12%type;

2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;

Line 2373: ra_customer_trx_lines.interface_line_attribute13%type;

2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;

Line 2375: ra_customer_trx_lines.interface_line_attribute14%type;

2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;

Line 2377: ra_customer_trx_lines.interface_line_attribute15%type;

2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;

Line 2379: ra_customer_trx_lines.attribute_category%type;

2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;

Line 2381: ra_customer_trx_lines.attribute1%type;

2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;

Line 2383: ra_customer_trx_lines.attribute2%type;

2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;

Line 2385: ra_customer_trx_lines.attribute3%type;

2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;

Line 2387: ra_customer_trx_lines.attribute4%type;

2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;

Line 2389: ra_customer_trx_lines.attribute5%type;

2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;

Line 2391: ra_customer_trx_lines.attribute6%type;

2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;

Line 2393: ra_customer_trx_lines.attribute7%type;

2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;

Line 2395: ra_customer_trx_lines.attribute8%type;

2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;

Line 2397: ra_customer_trx_lines.attribute9%type;

2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;

Line 2399: ra_customer_trx_lines.attribute10%type;

2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;

Line 2401: ra_customer_trx_lines.attribute11%type;

2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;

Line 2403: ra_customer_trx_lines.attribute12%type;

2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;

Line 2405: ra_customer_trx_lines.attribute13%type;

2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;

Line 2407: ra_customer_trx_lines.attribute14%type;

2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;
2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;

Line 2409: ra_customer_trx_lines.attribute15%type;

2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;
2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2413: l_ct_prev_trx_reference

Line 2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;

2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;
2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2413: l_ct_prev_trx_reference
2414: ra_customer_trx.interface_header_attribute1%type;
2415: l_ct_prev_inv_currency_code

Line 2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;

2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;
2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2413: l_ct_prev_trx_reference
2414: ra_customer_trx.interface_header_attribute1%type;
2415: l_ct_prev_inv_currency_code
2416: ra_customer_trx.invoice_currency_code%type;

Line 2414: ra_customer_trx.interface_header_attribute1%type;

2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2413: l_ct_prev_trx_reference
2414: ra_customer_trx.interface_header_attribute1%type;
2415: l_ct_prev_inv_currency_code
2416: ra_customer_trx.invoice_currency_code%type;
2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;

Line 2416: ra_customer_trx.invoice_currency_code%type;

2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2413: l_ct_prev_trx_reference
2414: ra_customer_trx.interface_header_attribute1%type;
2415: l_ct_prev_inv_currency_code
2416: ra_customer_trx.invoice_currency_code%type;
2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;

Line 2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;

2413: l_ct_prev_trx_reference
2414: ra_customer_trx.interface_header_attribute1%type;
2415: l_ct_prev_inv_currency_code
2416: ra_customer_trx.invoice_currency_code%type;
2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;

Line 2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;

2414: ra_customer_trx.interface_header_attribute1%type;
2415: l_ct_prev_inv_currency_code
2416: ra_customer_trx.invoice_currency_code%type;
2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;

Line 2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;

2415: l_ct_prev_inv_currency_code
2416: ra_customer_trx.invoice_currency_code%type;
2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;

Line 2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;

2416: ra_customer_trx.invoice_currency_code%type;
2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;

Line 2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;

2417: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;

Line 2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;

2418: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;

Line 2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;

2419: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;

Line 2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;

2420: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;

Line 2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;

2421: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2429: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;

Line 2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;

2422: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2429: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2430: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

Line 2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;

2423: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2429: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2430: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2431: l_prev_trx_original number;

Line 2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;

2424: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2429: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2430: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2431: l_prev_trx_original number;
2432: l_prev_trx_balance number;

Line 2429: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;

2425: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2429: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2430: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2431: l_prev_trx_original number;
2432: l_prev_trx_balance number;
2433: l_rac_prev_bill_to_cust_name hz_parties.party_name%type;

Line 2447: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;

2443: l_ct_prev_post_to_gl_flag
2444: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2445: l_al_cm_reason_meaning ar_lookups.meaning%type;
2446: l_ct_prev_rowid rowid;
2447: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;
2448: l_commit_memo_line_desc ar_memo_lines.description%type;
2449:
2450: BEGIN
2451:

Line 2544: FROM ra_customer_trx ct_commit,

2540: INTO l_ct_commitment_trx_date,
2541: l_ct_commitment_number,
2542: l_gd_commitment_gl_date,
2543: l_ctl_commitment_inv_item_id
2544: FROM ra_customer_trx ct_commit,
2545: ra_cust_trx_line_gl_dist gd_commit,
2546: ra_customer_trx_lines ctl_commit
2547: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2548: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id

Line 2546: ra_customer_trx_lines ctl_commit

2542: l_gd_commitment_gl_date,
2543: l_ctl_commitment_inv_item_id
2544: FROM ra_customer_trx ct_commit,
2545: ra_cust_trx_line_gl_dist gd_commit,
2546: ra_customer_trx_lines ctl_commit
2547: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2548: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id
2549: AND ct_commit.customer_trx_id = gd_commit.customer_trx_id
2550: AND 'REC' = gd_commit.account_class(+)

Line 2644: FROM ra_customer_trx_lines ctl_commit

2640: l_attribute14,
2641: l_attribute15,
2642: l_default_ussgl_trx_code,
2643: l_commit_memo_line_id
2644: FROM ra_customer_trx_lines ctl_commit
2645: WHERE ctl_commit.customer_trx_id = p_customer_trx_id
2646: AND 1 = ctl_commit.line_number
2647: AND 'LINE' = ctl_commit.line_type;
2648:

Line 2783: FROM ra_customer_trx ct,

2779: l_ctt_prev_natural_app_only,
2780: l_ct_prev_open_receivables, /* Bug-3954193 */
2781: l_ct_prev_post_to_gl_flag, /* Bug-3954193 */
2782: l_al_cm_reason_meaning
2783: FROM ra_customer_trx ct,
2784: ra_customer_trx ct_prev,
2785: ra_cust_trx_line_gl_dist gd_prev,
2786: hz_cust_accounts rac_prev,
2787: hz_parties party,

Line 2784: ra_customer_trx ct_prev,

2780: l_ct_prev_open_receivables, /* Bug-3954193 */
2781: l_ct_prev_post_to_gl_flag, /* Bug-3954193 */
2782: l_al_cm_reason_meaning
2783: FROM ra_customer_trx ct,
2784: ra_customer_trx ct_prev,
2785: ra_cust_trx_line_gl_dist gd_prev,
2786: hz_cust_accounts rac_prev,
2787: hz_parties party,
2788: ra_batch_sources bs_prev,