21: CURSOR c_check_program IS
22: SELECT COUNT(*)
23: FROM fnd_concurrent_programs
24: WHERE concurrent_program_name = p_program_name
25: AND concurrent_program_id = FND_GLOBAL.Conc_Program_Id
26: AND application_id = FND_GLOBAL.Prog_Appl_Id;
27:
28: l_count NUMBER;
29: l_message VARCHAR2(1000);
22: SELECT COUNT(*)
23: FROM fnd_concurrent_programs
24: WHERE concurrent_program_name = p_program_name
25: AND concurrent_program_id = FND_GLOBAL.Conc_Program_Id
26: AND application_id = FND_GLOBAL.Prog_Appl_Id;
27:
28: l_count NUMBER;
29: l_message VARCHAR2(1000);
30:
134:
135: -- Update concurrent process details to loaded records
136: UPDATE igi_imp_iac_intermediate
137: SET request_id = l_request_id
138: ,program_id = FND_GLOBAL.Conc_Program_Id
139: ,program_application_id = FND_GLOBAL.Prog_Appl_Id
140: ,program_update_date = SYSDATE
141: WHERE errored_flag IS NULL;
142:
135: -- Update concurrent process details to loaded records
136: UPDATE igi_imp_iac_intermediate
137: SET request_id = l_request_id
138: ,program_id = FND_GLOBAL.Conc_Program_Id
139: ,program_application_id = FND_GLOBAL.Prog_Appl_Id
140: ,program_update_date = SYSDATE
141: WHERE errored_flag IS NULL;
142:
143: COMMIT;