18: , x_return_status OUT NOCOPY VARCHAR2
19: )
20: IS
21: BEGIN
22: Eng_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
23: Eng_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
24: Eng_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
25: Eng_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
26: Eng_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
19: )
20: IS
21: BEGIN
22: Eng_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
23: Eng_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
24: Eng_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
25: Eng_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
26: Eng_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
27: END Init_System_Info_Rec;
20: IS
21: BEGIN
22: Eng_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
23: Eng_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
24: Eng_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
25: Eng_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
26: Eng_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
27: END Init_System_Info_Rec;
28:
21: BEGIN
22: Eng_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
23: Eng_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
24: Eng_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
25: Eng_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
26: Eng_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
27: END Init_System_Info_Rec;
28:
29:
22: Eng_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
23: Eng_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
24: Eng_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
25: Eng_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
26: Eng_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
27: END Init_System_Info_Rec;
28:
29:
30: -- Check transaction_type validity
521: SET approval_status_type = 1,
522: approval_request_date = null,
523: approval_date = null,
524: last_update_date = SYSDATE,
525: last_updated_by = FND_GLOBAL.USER_ID,
526: last_update_login = FND_GLOBAL.LOGIN_ID
527: WHERE organization_id = p_organization_id
528: AND change_notice = p_change_notice;
529:
522: approval_request_date = null,
523: approval_date = null,
524: last_update_date = SYSDATE,
525: last_updated_by = FND_GLOBAL.USER_ID,
526: last_update_login = FND_GLOBAL.LOGIN_ID
527: WHERE organization_id = p_organization_id
528: AND change_notice = p_change_notice;
529:
530: -- Set all "Scheduled" revised items to "Open"
531:
532: UPDATE eng_revised_items
533: SET status_type = 1,
534: last_update_date = SYSDATE,
535: last_updated_by = FND_GLOBAL.USER_ID,
536: last_update_login = FND_GLOBAL.LOGIN_ID
537: WHERE organization_id = p_organization_id
538: AND change_notice = p_change_notice
539: AND status_type = 4;
532: UPDATE eng_revised_items
533: SET status_type = 1,
534: last_update_date = SYSDATE,
535: last_updated_by = FND_GLOBAL.USER_ID,
536: last_update_login = FND_GLOBAL.LOGIN_ID
537: WHERE organization_id = p_organization_id
538: AND change_notice = p_change_notice
539: AND status_type = 4;
540: