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 693: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type

689: | |
690: +===========================================================================*/
691:
692: PROCEDURE reverse_revrec_effect (
693: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
694: ) IS
695:
696: l_line_rec ra_customer_trx_lines%rowtype;
697: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 696: l_line_rec ra_customer_trx_lines%rowtype;

692: PROCEDURE reverse_revrec_effect (
693: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
694: ) IS
695:
696: l_line_rec ra_customer_trx_lines%rowtype;
697: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
698: BEGIN
699:
700: arp_util.debug('arp_process_header.reverse_revrec_effect()+');

Line 767: | Inserts a record into ra_customer_trx. |

763: | PROCEDURE |
764: | insert_header |
765: | |
766: | DESCRIPTION |
767: | Inserts a record into ra_customer_trx. |
768: | |
769: | SCOPE - PUBLIC |
770: | |
771: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 800: p_trx_rec IN ra_customer_trx%rowtype,

796:
797: PROCEDURE insert_header(
798: p_form_name IN varchar2,
799: p_form_version IN number,
800: p_trx_rec IN ra_customer_trx%rowtype,
801: p_trx_class IN ra_cust_trx_types.type%type,
802: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
803: p_term_in_use_flag IN varchar2,
804: p_commitment_rec IN arp_process_commitment.commitment_rec_type,

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

801: p_trx_class IN ra_cust_trx_types.type%type,
802: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
803: p_term_in_use_flag IN varchar2,
804: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
805: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
806: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
807: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
808: p_row_id OUT NOCOPY rowid,
809: p_status OUT NOCOPY varchar2,

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

802: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
803: p_term_in_use_flag IN varchar2,
804: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
805: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
806: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
807: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
808: p_row_id OUT NOCOPY rowid,
809: p_status OUT NOCOPY varchar2,
810: p_receivable_ccid IN gl_code_combinations.code_combination_id%type

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

803: p_term_in_use_flag IN varchar2,
804: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
805: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
806: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
807: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
808: p_row_id OUT NOCOPY rowid,
809: p_status OUT NOCOPY varchar2,
810: p_receivable_ccid IN gl_code_combinations.code_combination_id%type
811: DEFAULT NULL,

Line 817: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

813: p_create_default_sc_flag IN varchar2 DEFAULT 'Y' )
814:
815: IS
816:
817: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
818: l_result number;
819: l_ccid number;
820: l_concat_segments varchar2(2000);
821: l_num_failed_dist_rows number;

Line 825: l_trx_rec ra_customer_trx%rowtype;

821: l_num_failed_dist_rows number;
822: l_errorbuf varchar2(200);
823:
824: l_remit_to_address_rec arp_trx_defaults_3.address_rec_type;
825: l_trx_rec ra_customer_trx%rowtype;
826: l_status1 varchar2(100);
827: l_status2 varchar2(100);
828: --Bug# 2750340
829: l_ev_rec arp_xla_events.xla_events_type;

Line 1048: | Updates a record into ra_customer_trx. |

1044: | PROCEDURE |
1045: | update_header |
1046: | |
1047: | DESCRIPTION |
1048: | Updates a record into ra_customer_trx. |
1049: | |
1050: | SCOPE - PUBLIC |
1051: | |
1052: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1076: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

1072:
1073: PROCEDURE update_header(
1074: p_form_name IN varchar2,
1075: p_form_version IN number,
1076: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1078: p_trx_amount IN number,
1079: p_trx_class IN ra_cust_trx_types.type%type,
1080: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 1077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1073: PROCEDURE update_header(
1074: p_form_name IN varchar2,
1075: p_form_version IN number,
1076: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1078: p_trx_amount IN number,
1079: p_trx_class IN ra_cust_trx_types.type%type,
1080: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1081: p_initial_customer_trx_line_id IN

Line 1082: ra_customer_trx_lines.initial_customer_trx_line_id%type

1078: p_trx_amount IN number,
1079: p_trx_class IN ra_cust_trx_types.type%type,
1080: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1081: p_initial_customer_trx_line_id IN
1082: ra_customer_trx_lines.initial_customer_trx_line_id%type
1083: default null,
1084: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1085: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
1086: p_term_in_use_flag IN varchar2,

Line 1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;

1102: l_dispute_changed_flag boolean;
1103: l_cust_trx_type_changed_flag boolean;
1104:
1105: l_initial_customer_trx_line_id
1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1107: l_exchange_rate ra_customer_trx.exchange_rate%type;
1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;

Line 1107: l_exchange_rate ra_customer_trx.exchange_rate%type;

1103: l_cust_trx_type_changed_flag boolean;
1104:
1105: l_initial_customer_trx_line_id
1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1107: l_exchange_rate ra_customer_trx.exchange_rate%type;
1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;
1111: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line 1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;

1104:
1105: l_initial_customer_trx_line_id
1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1107: l_exchange_rate ra_customer_trx.exchange_rate%type;
1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;
1111: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1112:

Line 1110: l_line_rec ra_customer_trx_lines%rowtype;

1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1107: l_exchange_rate ra_customer_trx.exchange_rate%type;
1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;
1111: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1112:
1113: l_old_trx_rec ra_customer_trx%rowtype;
1114:

Line 1113: l_old_trx_rec ra_customer_trx%rowtype;

1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;
1111: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1112:
1113: l_old_trx_rec ra_customer_trx%rowtype;
1114:
1115: l_number_of_pay_scheds NUMBER;
1116: l_new_tax_amount NUMBER;
1117: l_recalc_tax BOOLEAN;

Line 1348: FROM ra_customer_trx_lines

1344: THEN
1345: arp_util.debug('Clearing Lines and dist Rule Info ()+');
1346: BEGIN
1347: Select 'X' INTO l_dummy_flag
1348: FROM ra_customer_trx_lines
1349: WHERE customer_trx_id = p_customer_trx_id
1350: AND rownum = 1;
1351:
1352: arp_ctl_pkg.set_to_dummy( l_line_rec );

Line 1525: -- update ra_customer_trx_lines.initial_customer_trx_line_id

1521: AND
1522: nvl(p_trx_rec.initial_customer_trx_id, 0) <> pg_number_dummy)
1523: )
1524: THEN
1525: -- update ra_customer_trx_lines.initial_customer_trx_line_id
1526: IF (p_trx_rec.initial_customer_trx_id IS NOT NULL
1527: AND
1528: p_initial_customer_trx_line_id IS NULL)
1529: THEN

Line 1533: FROM ra_customer_trx_lines ctl

1529: THEN
1530: BEGIN
1531: SELECT customer_trx_line_id
1532: INTO l_initial_customer_trx_line_id
1533: FROM ra_customer_trx_lines ctl
1534: WHERE ctl.customer_trx_id = p_trx_rec.initial_customer_trx_id
1535: AND ctl.line_type = 'LINE';
1536: END;
1537: ELSE

Line 1667: ra_customer_trx ct ,

1663: l_event_source_info.application_id,
1664: l_post_to_gl,
1665: l_event_status_code
1666: from
1667: ra_customer_trx ct ,
1668: ra_cust_trx_types ctt,
1669: xla_transaction_entities_upg xet ,
1670: xla_events xe
1671: where ct.customer_trx_id = p_customer_trx_id

Line 1761: from ra_customer_trx_lines ctl,

1757:
1758: PROCEDURE delete_cont_defer_data(p_customer_trx_id IN NUMBER) IS
1759: CURSOR cont_cursor IS
1760: select alc.customer_trx_line_id
1761: from ra_customer_trx_lines ctl,
1762: ar_line_conts alc
1763: where
1764: ctl.customer_trx_id = p_customer_trx_id
1765: and ctl.customer_trx_line_id = alc.customer_trx_line_id

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

1800: | PROCEDURE |
1801: | delete_header |
1802: | |
1803: | DESCRIPTION |
1804: | deletes row from ra_customer_trx. Also deletes all child rows. |
1805: | |
1806: | SCOPE - PUBLIC |
1807: | |
1808: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1928: ra_customer_trx.customer_trx_id%type,

1924: +===========================================================================*/
1925: PROCEDURE post_commit( p_form_name IN varchar2,
1926: p_form_version IN number,
1927: p_customer_trx_id IN
1928: ra_customer_trx.customer_trx_id%type,
1929: p_previous_customer_trx_id IN
1930: ra_customer_trx.previous_customer_trx_id%type,
1931: p_complete_flag IN
1932: ra_customer_trx.complete_flag%type,

Line 1930: ra_customer_trx.previous_customer_trx_id%type,

1926: p_form_version IN number,
1927: p_customer_trx_id IN
1928: ra_customer_trx.customer_trx_id%type,
1929: p_previous_customer_trx_id IN
1930: ra_customer_trx.previous_customer_trx_id%type,
1931: p_complete_flag IN
1932: ra_customer_trx.complete_flag%type,
1933: p_trx_open_receivables_flag IN
1934: ra_cust_trx_types.accounting_affect_flag%type,

Line 1932: ra_customer_trx.complete_flag%type,

1928: ra_customer_trx.customer_trx_id%type,
1929: p_previous_customer_trx_id IN
1930: ra_customer_trx.previous_customer_trx_id%type,
1931: p_complete_flag IN
1932: ra_customer_trx.complete_flag%type,
1933: p_trx_open_receivables_flag IN
1934: ra_cust_trx_types.accounting_affect_flag%type,
1935: p_prev_open_receivables_flag IN
1936: ra_cust_trx_types.accounting_affect_flag%type,

Line 2007: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

2003:
2004: PROCEDURE update_header_freight_cover(
2005: p_form_name IN varchar2,
2006: p_form_version IN number,
2007: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2008: p_trx_class IN ra_cust_trx_types.type%type,
2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2010: p_ship_via IN ra_customer_trx.ship_via%type,
2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

Line 2010: p_ship_via IN ra_customer_trx.ship_via%type,

2006: p_form_version IN number,
2007: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2008: p_trx_class IN ra_cust_trx_types.type%type,
2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2010: p_ship_via IN ra_customer_trx.ship_via%type,
2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2012: p_waybill_number IN ra_customer_trx.waybill_number%type,
2013: p_fob_point IN ra_customer_trx.fob_point%type,
2014: p_status OUT NOCOPY varchar2)

Line 2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

2007: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2008: p_trx_class IN ra_cust_trx_types.type%type,
2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2010: p_ship_via IN ra_customer_trx.ship_via%type,
2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2012: p_waybill_number IN ra_customer_trx.waybill_number%type,
2013: p_fob_point IN ra_customer_trx.fob_point%type,
2014: p_status OUT NOCOPY varchar2)
2015:

Line 2012: p_waybill_number IN ra_customer_trx.waybill_number%type,

2008: p_trx_class IN ra_cust_trx_types.type%type,
2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2010: p_ship_via IN ra_customer_trx.ship_via%type,
2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2012: p_waybill_number IN ra_customer_trx.waybill_number%type,
2013: p_fob_point IN ra_customer_trx.fob_point%type,
2014: p_status OUT NOCOPY varchar2)
2015:
2016: IS

Line 2013: p_fob_point IN ra_customer_trx.fob_point%type,

2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2010: p_ship_via IN ra_customer_trx.ship_via%type,
2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2012: p_waybill_number IN ra_customer_trx.waybill_number%type,
2013: p_fob_point IN ra_customer_trx.fob_point%type,
2014: p_status OUT NOCOPY varchar2)
2015:
2016: IS
2017:

Line 2018: l_trx_rec ra_customer_trx%rowtype;

2014: p_status OUT NOCOPY varchar2)
2015:
2016: IS
2017:
2018: l_trx_rec ra_customer_trx%rowtype;
2019: l_commit_rec arp_process_commitment.commitment_rec_type;
2020: l_dummy varchar2(80);
2021:
2022: BEGIN

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

2077: | - The transaction is a commitment |
2078: | - The transaction is a credit memo against a specific transaction |
2079: | (not on account). |
2080: | |
2081: | This procedure was created so that the ra_customer_trx_v view could |
2082: | be simplified by removing koins to support these special cases. |
2083: | |
2084: | SCOPE - PUBLIC |
2085: | |

Line 2258: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;

2254: p_commit_memo_line_id OUT NOCOPY number,
2255: p_commit_memo_line_desc OUT NOCOPY varchar2
2256: ) IS
2257:
2258: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2259: l_ct_commitment_number ra_customer_trx.trx_number%type;
2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;

Line 2259: l_ct_commitment_number ra_customer_trx.trx_number%type;

2255: p_commit_memo_line_desc OUT NOCOPY varchar2
2256: ) IS
2257:
2258: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2259: l_ct_commitment_number ra_customer_trx.trx_number%type;
2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;

Line 2262: ra_customer_trx_lines.customer_trx_line_id%type;

2258: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2259: l_ct_commitment_number ra_customer_trx.trx_number%type;
2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context

Line 2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;

2259: l_ct_commitment_number ra_customer_trx.trx_number%type;
2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;

Line 2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;

2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1

Line 2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;

2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;

Line 2267: ra_customer_trx_lines.interface_line_context%type;

2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;

Line 2269: ra_customer_trx_lines.interface_line_attribute1%type;

2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;

Line 2271: ra_customer_trx_lines.interface_line_attribute2%type;

2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;

Line 2273: ra_customer_trx_lines.interface_line_attribute3%type;

2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;

Line 2275: ra_customer_trx_lines.interface_line_attribute4%type;

2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;

Line 2277: ra_customer_trx_lines.interface_line_attribute5%type;

2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;

Line 2279: ra_customer_trx_lines.interface_line_attribute6%type;

2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;

Line 2281: ra_customer_trx_lines.interface_line_attribute7%type;

2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;

Line 2283: ra_customer_trx_lines.interface_line_attribute8%type;

2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;

Line 2285: ra_customer_trx_lines.interface_line_attribute9%type;

2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;

Line 2287: ra_customer_trx_lines.interface_line_attribute10%type;

2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;

Line 2289: ra_customer_trx_lines.interface_line_attribute11%type;

2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;

Line 2291: ra_customer_trx_lines.interface_line_attribute12%type;

2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;

Line 2293: ra_customer_trx_lines.interface_line_attribute13%type;

2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;

Line 2295: ra_customer_trx_lines.interface_line_attribute14%type;

2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;

Line 2297: ra_customer_trx_lines.interface_line_attribute15%type;

2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;

Line 2299: ra_customer_trx_lines.attribute_category%type;

2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;

Line 2301: ra_customer_trx_lines.attribute1%type;

2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;

Line 2303: ra_customer_trx_lines.attribute2%type;

2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;

Line 2305: ra_customer_trx_lines.attribute3%type;

2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;

Line 2307: ra_customer_trx_lines.attribute4%type;

2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;

Line 2309: ra_customer_trx_lines.attribute5%type;

2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;

Line 2311: ra_customer_trx_lines.attribute6%type;

2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;

Line 2313: ra_customer_trx_lines.attribute7%type;

2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;

Line 2315: ra_customer_trx_lines.attribute8%type;

2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;

Line 2317: ra_customer_trx_lines.attribute9%type;

2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;

Line 2319: ra_customer_trx_lines.attribute10%type;

2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;

Line 2321: ra_customer_trx_lines.attribute11%type;

2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;

Line 2323: ra_customer_trx_lines.attribute12%type;

2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;

Line 2325: ra_customer_trx_lines.attribute13%type;

2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;

Line 2327: ra_customer_trx_lines.attribute14%type;

2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;
2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;

Line 2329: ra_customer_trx_lines.attribute15%type;

2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;
2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2333: l_ct_prev_trx_reference

Line 2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;

2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;
2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2333: l_ct_prev_trx_reference
2334: ra_customer_trx.interface_header_attribute1%type;
2335: l_ct_prev_inv_currency_code

Line 2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;

2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;
2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2333: l_ct_prev_trx_reference
2334: ra_customer_trx.interface_header_attribute1%type;
2335: l_ct_prev_inv_currency_code
2336: ra_customer_trx.invoice_currency_code%type;

Line 2334: ra_customer_trx.interface_header_attribute1%type;

2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2333: l_ct_prev_trx_reference
2334: ra_customer_trx.interface_header_attribute1%type;
2335: l_ct_prev_inv_currency_code
2336: ra_customer_trx.invoice_currency_code%type;
2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;

Line 2336: ra_customer_trx.invoice_currency_code%type;

2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2333: l_ct_prev_trx_reference
2334: ra_customer_trx.interface_header_attribute1%type;
2335: l_ct_prev_inv_currency_code
2336: ra_customer_trx.invoice_currency_code%type;
2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;

Line 2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;

2333: l_ct_prev_trx_reference
2334: ra_customer_trx.interface_header_attribute1%type;
2335: l_ct_prev_inv_currency_code
2336: ra_customer_trx.invoice_currency_code%type;
2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;

Line 2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;

2334: ra_customer_trx.interface_header_attribute1%type;
2335: l_ct_prev_inv_currency_code
2336: ra_customer_trx.invoice_currency_code%type;
2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;

Line 2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;

2335: l_ct_prev_inv_currency_code
2336: ra_customer_trx.invoice_currency_code%type;
2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;

Line 2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;

2336: ra_customer_trx.invoice_currency_code%type;
2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;

Line 2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;

2337: l_ct_prev_trx_date ra_customer_trx.trx_date%type;
2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;

Line 2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;

2338: l_ct_prev_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;

Line 2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;

2339: l_ct_prev_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;

Line 2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;

2340: l_ct_prev_sold_to_customer_id ra_customer_trx.sold_to_customer_id%type;
2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;

Line 2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;

2341: l_ct_prev_paying_customer_id ra_customer_trx.paying_customer_id%type;
2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2349: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;

Line 2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;

2342: l_ct_prev_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2349: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2350: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

Line 2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;

2343: l_ct_prev_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2349: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2350: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2351: l_prev_trx_original number;

Line 2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;

2344: l_ct_prev_paying_site_use_id ra_customer_trx.paying_site_use_id%type;
2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2349: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2350: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2351: l_prev_trx_original number;
2352: l_prev_trx_balance number;

Line 2349: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;

2345: l_ct_prev_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2349: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2350: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2351: l_prev_trx_original number;
2352: l_prev_trx_balance number;
2353: l_rac_prev_bill_to_cust_name hz_parties.party_name%type;

Line 2367: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;

2363: l_ct_prev_post_to_gl_flag
2364: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2365: l_al_cm_reason_meaning ar_lookups.meaning%type;
2366: l_ct_prev_rowid rowid;
2367: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;
2368: l_commit_memo_line_desc ar_memo_lines.description%type;
2369:
2370: BEGIN
2371:

Line 2464: FROM ra_customer_trx ct_commit,

2460: INTO l_ct_commitment_trx_date,
2461: l_ct_commitment_number,
2462: l_gd_commitment_gl_date,
2463: l_ctl_commitment_inv_item_id
2464: FROM ra_customer_trx ct_commit,
2465: ra_cust_trx_line_gl_dist gd_commit,
2466: ra_customer_trx_lines ctl_commit
2467: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2468: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id

Line 2466: ra_customer_trx_lines ctl_commit

2462: l_gd_commitment_gl_date,
2463: l_ctl_commitment_inv_item_id
2464: FROM ra_customer_trx ct_commit,
2465: ra_cust_trx_line_gl_dist gd_commit,
2466: ra_customer_trx_lines ctl_commit
2467: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2468: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id
2469: AND ct_commit.customer_trx_id = gd_commit.customer_trx_id
2470: AND 'REC' = gd_commit.account_class(+)

Line 2564: FROM ra_customer_trx_lines ctl_commit

2560: l_attribute14,
2561: l_attribute15,
2562: l_default_ussgl_trx_code,
2563: l_commit_memo_line_id
2564: FROM ra_customer_trx_lines ctl_commit
2565: WHERE ctl_commit.customer_trx_id = p_customer_trx_id
2566: AND 1 = ctl_commit.line_number
2567: AND 'LINE' = ctl_commit.line_type;
2568:

Line 2703: FROM ra_customer_trx ct,

2699: l_ctt_prev_natural_app_only,
2700: l_ct_prev_open_receivables, /* Bug-3954193 */
2701: l_ct_prev_post_to_gl_flag, /* Bug-3954193 */
2702: l_al_cm_reason_meaning
2703: FROM ra_customer_trx ct,
2704: ra_customer_trx ct_prev,
2705: ra_cust_trx_line_gl_dist gd_prev,
2706: hz_cust_accounts rac_prev,
2707: hz_parties party,

Line 2704: ra_customer_trx ct_prev,

2700: l_ct_prev_open_receivables, /* Bug-3954193 */
2701: l_ct_prev_post_to_gl_flag, /* Bug-3954193 */
2702: l_al_cm_reason_meaning
2703: FROM ra_customer_trx ct,
2704: ra_customer_trx ct_prev,
2705: ra_cust_trx_line_gl_dist gd_prev,
2706: hz_cust_accounts rac_prev,
2707: hz_parties party,
2708: ra_batch_sources bs_prev,