DBA Data[Home] [Help]

APPS.IGI_IMP_IAC_PREPARE_PKG dependencies on FND_GLOBAL

Line 139: Request_id = fnd_global.conc_request_id,

135: l_path_name := g_path||'set_process_status';
136:
137: Update igi_imp_iac_controls
138: Set Request_status = p_flag,
139: Request_id = fnd_global.conc_request_id,
140: Request_date = sysdate,
141: Last_updated_by = fnd_global.user_id,
142: last_update_date = sysdate,
143: last_update_login = fnd_global.login_id

Line 141: Last_updated_by = fnd_global.user_id,

137: Update igi_imp_iac_controls
138: Set Request_status = p_flag,
139: Request_id = fnd_global.conc_request_id,
140: Request_date = sysdate,
141: Last_updated_by = fnd_global.user_id,
142: last_update_date = sysdate,
143: last_update_login = fnd_global.login_id
144: Where book_type_code = p_book;
145: If Sql%found Then

Line 143: last_update_login = fnd_global.login_id

139: Request_id = fnd_global.conc_request_id,
140: Request_date = sysdate,
141: Last_updated_by = fnd_global.user_id,
142: last_update_date = sysdate,
143: last_update_login = fnd_global.login_id
144: Where book_type_code = p_book;
145: If Sql%found Then
146: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
147: p_full_path => l_path_name,

Line 304: fnd_global.user_id,

300: last_update_login)
301: Values(
302: p_book,
303: p_category_id,
304: fnd_global.user_id,
305: sysdate,
306: 'N' ,
307: fnd_global.user_id,
308: sysdate,

Line 307: fnd_global.user_id,

303: p_category_id,
304: fnd_global.user_id,
305: sysdate,
306: 'N' ,
307: fnd_global.user_id,
308: sysdate,
309: fnd_global.login_id);
310: If Sql%found Then
311: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 309: fnd_global.login_id);

305: sysdate,
306: 'N' ,
307: fnd_global.user_id,
308: sysdate,
309: fnd_global.login_id);
310: If Sql%found Then
311: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
312: p_full_path => l_path_name,
313: p_string => 'Created a record in igi_imp_iac_interface_ctrl for Book ' || p_book );

Line 904: l_imp_interface.created_by := fnd_global.user_id;

900: l_imp_interface.export_file := NULL;
901: l_imp_interface.export_date := NULL;
902: l_imp_interface.import_file := NULL;
903: l_imp_interface.import_date := NULL;
904: l_imp_interface.created_by := fnd_global.user_id;
905: l_imp_interface.creation_date := sysdate;
906: l_imp_interface.last_updated_by := fnd_global.user_id;
907: l_imp_interface.last_update_date := sysdate;
908: l_imp_interface.last_update_login := fnd_global.login_id;

Line 906: l_imp_interface.last_updated_by := fnd_global.user_id;

902: l_imp_interface.import_file := NULL;
903: l_imp_interface.import_date := NULL;
904: l_imp_interface.created_by := fnd_global.user_id;
905: l_imp_interface.creation_date := sysdate;
906: l_imp_interface.last_updated_by := fnd_global.user_id;
907: l_imp_interface.last_update_date := sysdate;
908: l_imp_interface.last_update_login := fnd_global.login_id;
909: l_imp_interface.request_id := fnd_global.conc_request_id;
910: l_imp_interface.program_application_id := fnd_global.prog_appl_id;

Line 908: l_imp_interface.last_update_login := fnd_global.login_id;

904: l_imp_interface.created_by := fnd_global.user_id;
905: l_imp_interface.creation_date := sysdate;
906: l_imp_interface.last_updated_by := fnd_global.user_id;
907: l_imp_interface.last_update_date := sysdate;
908: l_imp_interface.last_update_login := fnd_global.login_id;
909: l_imp_interface.request_id := fnd_global.conc_request_id;
910: l_imp_interface.program_application_id := fnd_global.prog_appl_id;
911: l_imp_interface.program_id := fnd_global.conc_program_id;
912: l_imp_interface.program_update_date := sysdate;

Line 909: l_imp_interface.request_id := fnd_global.conc_request_id;

905: l_imp_interface.creation_date := sysdate;
906: l_imp_interface.last_updated_by := fnd_global.user_id;
907: l_imp_interface.last_update_date := sysdate;
908: l_imp_interface.last_update_login := fnd_global.login_id;
909: l_imp_interface.request_id := fnd_global.conc_request_id;
910: l_imp_interface.program_application_id := fnd_global.prog_appl_id;
911: l_imp_interface.program_id := fnd_global.conc_program_id;
912: l_imp_interface.program_update_date := sysdate;
913:

Line 910: l_imp_interface.program_application_id := fnd_global.prog_appl_id;

906: l_imp_interface.last_updated_by := fnd_global.user_id;
907: l_imp_interface.last_update_date := sysdate;
908: l_imp_interface.last_update_login := fnd_global.login_id;
909: l_imp_interface.request_id := fnd_global.conc_request_id;
910: l_imp_interface.program_application_id := fnd_global.prog_appl_id;
911: l_imp_interface.program_id := fnd_global.conc_program_id;
912: l_imp_interface.program_update_date := sysdate;
913:
914: Populate_Interface(l_imp_interface);

Line 911: l_imp_interface.program_id := fnd_global.conc_program_id;

907: l_imp_interface.last_update_date := sysdate;
908: l_imp_interface.last_update_login := fnd_global.login_id;
909: l_imp_interface.request_id := fnd_global.conc_request_id;
910: l_imp_interface.program_application_id := fnd_global.prog_appl_id;
911: l_imp_interface.program_id := fnd_global.conc_program_id;
912: l_imp_interface.program_update_date := sysdate;
913:
914: Populate_Interface(l_imp_interface);
915: l_cat_records := l_cat_records + 1;

Line 1503: l_imp_interface.Created_by := fnd_global.user_id;

1499: l_imp_interface.Export_file := NULL;
1500: l_imp_interface.Export_date := NULL;
1501: l_imp_interface.Import_file := NULL;
1502: l_imp_interface.Import_date := NULL;
1503: l_imp_interface.Created_by := fnd_global.user_id;
1504: l_imp_interface.Creation_date := sysdate;
1505: l_imp_interface.Last_Updated_by := fnd_global.user_id;
1506: l_imp_interface.Last_Update_date := sysdate;
1507: l_imp_interface.Last_update_login := fnd_global.login_id;

Line 1505: l_imp_interface.Last_Updated_by := fnd_global.user_id;

1501: l_imp_interface.Import_file := NULL;
1502: l_imp_interface.Import_date := NULL;
1503: l_imp_interface.Created_by := fnd_global.user_id;
1504: l_imp_interface.Creation_date := sysdate;
1505: l_imp_interface.Last_Updated_by := fnd_global.user_id;
1506: l_imp_interface.Last_Update_date := sysdate;
1507: l_imp_interface.Last_update_login := fnd_global.login_id;
1508: l_imp_interface.Request_id := fnd_global.conc_request_id;
1509: l_imp_interface.Program_application_id := fnd_global.prog_appl_id;

Line 1507: l_imp_interface.Last_update_login := fnd_global.login_id;

1503: l_imp_interface.Created_by := fnd_global.user_id;
1504: l_imp_interface.Creation_date := sysdate;
1505: l_imp_interface.Last_Updated_by := fnd_global.user_id;
1506: l_imp_interface.Last_Update_date := sysdate;
1507: l_imp_interface.Last_update_login := fnd_global.login_id;
1508: l_imp_interface.Request_id := fnd_global.conc_request_id;
1509: l_imp_interface.Program_application_id := fnd_global.prog_appl_id;
1510: l_imp_interface.Program_id := fnd_global.conc_program_id;
1511: l_imp_interface.Program_update_date := sysdate;

Line 1508: l_imp_interface.Request_id := fnd_global.conc_request_id;

1504: l_imp_interface.Creation_date := sysdate;
1505: l_imp_interface.Last_Updated_by := fnd_global.user_id;
1506: l_imp_interface.Last_Update_date := sysdate;
1507: l_imp_interface.Last_update_login := fnd_global.login_id;
1508: l_imp_interface.Request_id := fnd_global.conc_request_id;
1509: l_imp_interface.Program_application_id := fnd_global.prog_appl_id;
1510: l_imp_interface.Program_id := fnd_global.conc_program_id;
1511: l_imp_interface.Program_update_date := sysdate;
1512:

Line 1509: l_imp_interface.Program_application_id := fnd_global.prog_appl_id;

1505: l_imp_interface.Last_Updated_by := fnd_global.user_id;
1506: l_imp_interface.Last_Update_date := sysdate;
1507: l_imp_interface.Last_update_login := fnd_global.login_id;
1508: l_imp_interface.Request_id := fnd_global.conc_request_id;
1509: l_imp_interface.Program_application_id := fnd_global.prog_appl_id;
1510: l_imp_interface.Program_id := fnd_global.conc_program_id;
1511: l_imp_interface.Program_update_date := sysdate;
1512:
1513:

Line 1510: l_imp_interface.Program_id := fnd_global.conc_program_id;

1506: l_imp_interface.Last_Update_date := sysdate;
1507: l_imp_interface.Last_update_login := fnd_global.login_id;
1508: l_imp_interface.Request_id := fnd_global.conc_request_id;
1509: l_imp_interface.Program_application_id := fnd_global.prog_appl_id;
1510: l_imp_interface.Program_id := fnd_global.conc_program_id;
1511: l_imp_interface.Program_update_date := sysdate;
1512:
1513:
1514: If C_Book_Info_Rec.period_counter_fully_reserved is not null then