DBA Data[Home] [Help]

APPS.IGIRGLOBE dependencies on IGI_AR_SYSTEM_OPTIONS

Line 62: from igi_ar_system_options_all

58: sysdate creation_date, sysdate last_update_date,
59: -1 last_updated_by, -1 created_by, -1 last_update_login
60: from ar_system_parameters_all aspa
61: where not exists ( select 'Already set up'
62: from igi_ar_system_options_all
63: where set_of_books_id = aspa.set_of_books_id
64: and org_id = aspa.org_id )
65: ;
66:

Line 71: insert into igi_ar_system_options_all ( set_of_books_id

67: BEGIN
68:
69:
70: for l_asp in c_ar_system_options loop
71: insert into igi_ar_system_options_all ( set_of_books_id
72: , accounting_method
73: , org_id
74: , creation_date
75: , created_by

Line 92: DELETE FROM igi_ar_system_options_all a

88: );
89: end loop;
90:
91: /* Start Bug 3749634 */
92: DELETE FROM igi_ar_system_options_all a
93: WHERE NOT EXISTS
94: (
95: SELECT 'X'
96: FROM ar_system_parameters_all

Line 991: from igi_ar_system_options;

987: , rpi_line_generate_seq
988: , rpi_line_charge_line_num
989: , rpi_line_price_break_num
990: , USERENV('LANG') language
991: from igi_ar_system_options;
992: BEGIN
993: FOR l_rpi in C_rpi LOOP
994: PopulateRPIFlex
995: ( pp_header_txn_context => l_rpi.rpi_header_context_code