226: x_err_code => l_error_code,
227: p_rep_wip_entity_id => c_algorithm_rec.copy_parent_wip_entity_id,
228: p_new_wip_entity_id => c_algorithm_rec.wip_entity_id,
229: p_last_update_date => sysdate,
230: p_last_updated_by => FND_GLOBAL.USER_ID,
231: p_last_update_login => FND_GLOBAL.LOGIN_ID,
232: p_creation_date => sysdate,
233: p_created_by => FND_GLOBAL.USER_ID,
234: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
227: p_rep_wip_entity_id => c_algorithm_rec.copy_parent_wip_entity_id,
228: p_new_wip_entity_id => c_algorithm_rec.wip_entity_id,
229: p_last_update_date => sysdate,
230: p_last_updated_by => FND_GLOBAL.USER_ID,
231: p_last_update_login => FND_GLOBAL.LOGIN_ID,
232: p_creation_date => sysdate,
233: p_created_by => FND_GLOBAL.USER_ID,
234: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
235: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
229: p_last_update_date => sysdate,
230: p_last_updated_by => FND_GLOBAL.USER_ID,
231: p_last_update_login => FND_GLOBAL.LOGIN_ID,
232: p_creation_date => sysdate,
233: p_created_by => FND_GLOBAL.USER_ID,
234: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
235: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
236: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
237: p_program_update_date => sysdate,
230: p_last_updated_by => FND_GLOBAL.USER_ID,
231: p_last_update_login => FND_GLOBAL.LOGIN_ID,
232: p_creation_date => sysdate,
233: p_created_by => FND_GLOBAL.USER_ID,
234: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
235: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
236: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
237: p_program_update_date => sysdate,
238: p_inf_sch_flag => 'Y',
231: p_last_update_login => FND_GLOBAL.LOGIN_ID,
232: p_creation_date => sysdate,
233: p_created_by => FND_GLOBAL.USER_ID,
234: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
235: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
236: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
237: p_program_update_date => sysdate,
238: p_inf_sch_flag => 'Y',
239: p_inf_sch_mode => NULL,
232: p_creation_date => sysdate,
233: p_created_by => FND_GLOBAL.USER_ID,
234: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
235: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
236: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
237: p_program_update_date => sysdate,
238: p_inf_sch_flag => 'Y',
239: p_inf_sch_mode => NULL,
240: p_inf_sch_date => NULL
319:
320: p_bom_rev_date => c_algorithm_rec.bom_revision_date,
321: p_wip_supply_type => c_algorithm_rec.wip_supply_type,
322: p_last_update_date => sysdate,
323: p_last_updated_by => FND_GLOBAL.USER_ID,
324: p_last_update_login => FND_GLOBAL.LOGIN_ID,
325: p_creation_date => sysdate,
326: p_created_by => FND_GLOBAL.USER_ID,
327: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
320: p_bom_rev_date => c_algorithm_rec.bom_revision_date,
321: p_wip_supply_type => c_algorithm_rec.wip_supply_type,
322: p_last_update_date => sysdate,
323: p_last_updated_by => FND_GLOBAL.USER_ID,
324: p_last_update_login => FND_GLOBAL.LOGIN_ID,
325: p_creation_date => sysdate,
326: p_created_by => FND_GLOBAL.USER_ID,
327: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
328: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
322: p_last_update_date => sysdate,
323: p_last_updated_by => FND_GLOBAL.USER_ID,
324: p_last_update_login => FND_GLOBAL.LOGIN_ID,
325: p_creation_date => sysdate,
326: p_created_by => FND_GLOBAL.USER_ID,
327: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
328: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
329: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
330: p_program_update_date => sysdate,
323: p_last_updated_by => FND_GLOBAL.USER_ID,
324: p_last_update_login => FND_GLOBAL.LOGIN_ID,
325: p_creation_date => sysdate,
326: p_created_by => FND_GLOBAL.USER_ID,
327: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
328: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
329: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
330: p_program_update_date => sysdate,
331: p_inf_sch_flag => 'Y',
324: p_last_update_login => FND_GLOBAL.LOGIN_ID,
325: p_creation_date => sysdate,
326: p_created_by => FND_GLOBAL.USER_ID,
327: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
328: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
329: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
330: p_program_update_date => sysdate,
331: p_inf_sch_flag => 'Y',
332: p_inf_sch_mode => NULL, -- Create_JobCopies to figure out
325: p_creation_date => sysdate,
326: p_created_by => FND_GLOBAL.USER_ID,
327: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
328: p_program_app_id => FND_GLOBAL.PROG_APPL_ID,
329: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
330: p_program_update_date => sysdate,
331: p_inf_sch_flag => 'Y',
332: p_inf_sch_mode => NULL, -- Create_JobCopies to figure out
333: p_inf_sch_date => NULL, -- Create_JobCopies to figure out
636: order by transaction_date,header_id;
637:
638: BEGIN
639: l_stmt_num := 5;
640: g_user_id := FND_GLOBAL.USER_ID;
641: g_user_login_id := FND_GLOBAL.LOGIN_ID;
642: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
643: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
644: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
637:
638: BEGIN
639: l_stmt_num := 5;
640: g_user_id := FND_GLOBAL.USER_ID;
641: g_user_login_id := FND_GLOBAL.LOGIN_ID;
642: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
643: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
644: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
645:
638: BEGIN
639: l_stmt_num := 5;
640: g_user_id := FND_GLOBAL.USER_ID;
641: g_user_login_id := FND_GLOBAL.LOGIN_ID;
642: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
643: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
644: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
645:
646: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered LOAD procedure'); --Remove
639: l_stmt_num := 5;
640: g_user_id := FND_GLOBAL.USER_ID;
641: g_user_login_id := FND_GLOBAL.LOGIN_ID;
642: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
643: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
644: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
645:
646: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered LOAD procedure'); --Remove
647: if( g_log_level_statement >= l_log_level ) then
640: g_user_id := FND_GLOBAL.USER_ID;
641: g_user_login_id := FND_GLOBAL.LOGIN_ID;
642: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
643: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
644: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
645:
646: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered LOAD procedure'); --Remove
647: if( g_log_level_statement >= l_log_level ) then
648: l_msg_tokens.delete;