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_CONSINV dependencies on AR_CONS_INV_ALL

Line 5: correspond to customer merge as status of AR_CONS_INV_ALL table.

1: PACKAGE BODY arp_consinv AS
2: /* $Header: ARPCBIB.pls 120.27 2005/06/14 18:53:10 vcrisost ship $ */
3:
4: /* bug2778646 : Added 'MERGE_PENDING','DRAFT_MERGE' and 'MERGED' status to
5: correspond to customer merge as status of AR_CONS_INV_ALL table.
6:
7: MERGE_PENDING -- Not merged yet. Next CBI has to pick up.
8: DRAFT_MERGE -- Merged to new draft CBI. Other CBI cannot get it untill
9: the new draft CBI is rejected.

Line 99: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;

95: | |
96: *----------------------------------------------------------------------------*/
97: PROCEDURE accept (P_consinv_id IN NUMBER, P_request_id IN NUMBER) IS
98: -- bug2778646 start
99: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;
100: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;
101: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;
102:
103: l_site_use_id tab_site_use_id ;

Line 100: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;

96: *----------------------------------------------------------------------------*/
97: PROCEDURE accept (P_consinv_id IN NUMBER, P_request_id IN NUMBER) IS
98: -- bug2778646 start
99: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;
100: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;
101: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;
102:
103: l_site_use_id tab_site_use_id ;
104: l_currency_code tab_currency_code;

Line 101: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;

97: PROCEDURE accept (P_consinv_id IN NUMBER, P_request_id IN NUMBER) IS
98: -- bug2778646 start
99: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;
100: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;
101: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;
102:
103: l_site_use_id tab_site_use_id ;
104: l_currency_code tab_currency_code;
105: l_cut_off_date tab_cut_off_date ;

Line 195: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;

191: *----------------------------------------------------------------------------*/
192: PROCEDURE reject (P_consinv_id IN NUMBER, P_request_id IN NUMBER) IS
193:
194: -- bug2778646 start
195: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;
196: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;
197: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;
198:
199: l_site_use_id tab_site_use_id ;

Line 196: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;

192: PROCEDURE reject (P_consinv_id IN NUMBER, P_request_id IN NUMBER) IS
193:
194: -- bug2778646 start
195: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;
196: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;
197: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;
198:
199: l_site_use_id tab_site_use_id ;
200: l_currency_code tab_currency_code;

Line 197: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;

193:
194: -- bug2778646 start
195: TYPE tab_site_use_id IS TABLE OF ar_cons_inv_all.site_use_id%TYPE;
196: TYPE tab_currency_code IS TABLE OF ar_cons_inv_all.currency_code%TYPE;
197: TYPE tab_cut_off_date IS TABLE OF ar_cons_inv_all.cut_off_date%TYPE;
198:
199: l_site_use_id tab_site_use_id ;
200: l_currency_code tab_currency_code;
201: l_cut_off_date tab_cut_off_date ;