689:
690: exception
691: when no_data_found then
692: x_last_update_date := SYSDATE;
693: x_last_updated_by := FND_GLOBAL.USER_ID ;
694: x_creation_date := SYSDATE;
695: x_created_by := FND_GLOBAL.USER_ID;
696: x_last_update_login := FND_GLOBAL.LOGIN_ID;
697: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
691: when no_data_found then
692: x_last_update_date := SYSDATE;
693: x_last_updated_by := FND_GLOBAL.USER_ID ;
694: x_creation_date := SYSDATE;
695: x_created_by := FND_GLOBAL.USER_ID;
696: x_last_update_login := FND_GLOBAL.LOGIN_ID;
697: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
698: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
699: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
692: x_last_update_date := SYSDATE;
693: x_last_updated_by := FND_GLOBAL.USER_ID ;
694: x_creation_date := SYSDATE;
695: x_created_by := FND_GLOBAL.USER_ID;
696: x_last_update_login := FND_GLOBAL.LOGIN_ID;
697: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
698: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
699: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
700: x_program_update_date := SYSDATE;
693: x_last_updated_by := FND_GLOBAL.USER_ID ;
694: x_creation_date := SYSDATE;
695: x_created_by := FND_GLOBAL.USER_ID;
696: x_last_update_login := FND_GLOBAL.LOGIN_ID;
697: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
698: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
699: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
700: x_program_update_date := SYSDATE;
701:
694: x_creation_date := SYSDATE;
695: x_created_by := FND_GLOBAL.USER_ID;
696: x_last_update_login := FND_GLOBAL.LOGIN_ID;
697: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
698: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
699: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
700: x_program_update_date := SYSDATE;
701:
702: end;
695: x_created_by := FND_GLOBAL.USER_ID;
696: x_last_update_login := FND_GLOBAL.LOGIN_ID;
697: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
698: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
699: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
700: x_program_update_date := SYSDATE;
701:
702: end;
703: /* --------------------------------------------------------- *
817: x_to_entity_name => 'WIP_DISCRETE_OPERATIONS',
818: x_to_pk1_value => to_char(p_wip_entity_id),
819: x_to_pk2_value => to_char(p_op_seq_num),
820: x_to_pk3_value => to_char(p_org_id),
821: x_created_by => fnd_global.user_id,
822: x_last_update_login => fnd_global.login_id,
823: x_program_application_id => fnd_global.prog_appl_id,
824: x_program_id => fnd_global.conc_program_id,
825: x_request_id => fnd_global.conc_request_id);
818: x_to_pk1_value => to_char(p_wip_entity_id),
819: x_to_pk2_value => to_char(p_op_seq_num),
820: x_to_pk3_value => to_char(p_org_id),
821: x_created_by => fnd_global.user_id,
822: x_last_update_login => fnd_global.login_id,
823: x_program_application_id => fnd_global.prog_appl_id,
824: x_program_id => fnd_global.conc_program_id,
825: x_request_id => fnd_global.conc_request_id);
826: END LOOP;
819: x_to_pk2_value => to_char(p_op_seq_num),
820: x_to_pk3_value => to_char(p_org_id),
821: x_created_by => fnd_global.user_id,
822: x_last_update_login => fnd_global.login_id,
823: x_program_application_id => fnd_global.prog_appl_id,
824: x_program_id => fnd_global.conc_program_id,
825: x_request_id => fnd_global.conc_request_id);
826: END LOOP;
827:
820: x_to_pk3_value => to_char(p_org_id),
821: x_created_by => fnd_global.user_id,
822: x_last_update_login => fnd_global.login_id,
823: x_program_application_id => fnd_global.prog_appl_id,
824: x_program_id => fnd_global.conc_program_id,
825: x_request_id => fnd_global.conc_request_id);
826: END LOOP;
827:
828: exception
821: x_created_by => fnd_global.user_id,
822: x_last_update_login => fnd_global.login_id,
823: x_program_application_id => fnd_global.prog_appl_id,
824: x_program_id => fnd_global.conc_program_id,
825: x_request_id => fnd_global.conc_request_id);
826: END LOOP;
827:
828: exception
829: when No_Data_Found then