5644: END IF;
5645: --}
5646: END IF;
5647: --
5648: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
5649: ec_debug.disable_debug;
5650: END IF;
5651: --
5652: v_progress := '080';
8185: INTMED_SHIP_TO_ORG_ID_TAB INTMED_SHIP_TO_ORG_ID_T;
8186: SHIP_TO_CUSTOMER_ID_TAB SHIP_TO_CUSTOMER_ID_T;
8187: --
8188: v_last_update_date DATE := sysdate;
8189: v_last_updated_by NUMBER := fnd_global.user_id;
8190: v_last_update_login NUMBER := fnd_global.login_id;
8191: v_request_id NUMBER := fnd_global.conc_REQUEST_ID;
8192: v_program_application_id NUMBER := fnd_global.PROG_APPL_ID;
8193: v_program_id NUMBER := fnd_global.conc_program_id;
8186: SHIP_TO_CUSTOMER_ID_TAB SHIP_TO_CUSTOMER_ID_T;
8187: --
8188: v_last_update_date DATE := sysdate;
8189: v_last_updated_by NUMBER := fnd_global.user_id;
8190: v_last_update_login NUMBER := fnd_global.login_id;
8191: v_request_id NUMBER := fnd_global.conc_REQUEST_ID;
8192: v_program_application_id NUMBER := fnd_global.PROG_APPL_ID;
8193: v_program_id NUMBER := fnd_global.conc_program_id;
8194: v_program_update_date DATE := sysdate;
8187: --
8188: v_last_update_date DATE := sysdate;
8189: v_last_updated_by NUMBER := fnd_global.user_id;
8190: v_last_update_login NUMBER := fnd_global.login_id;
8191: v_request_id NUMBER := fnd_global.conc_REQUEST_ID;
8192: v_program_application_id NUMBER := fnd_global.PROG_APPL_ID;
8193: v_program_id NUMBER := fnd_global.conc_program_id;
8194: v_program_update_date DATE := sysdate;
8195: --
8188: v_last_update_date DATE := sysdate;
8189: v_last_updated_by NUMBER := fnd_global.user_id;
8190: v_last_update_login NUMBER := fnd_global.login_id;
8191: v_request_id NUMBER := fnd_global.conc_REQUEST_ID;
8192: v_program_application_id NUMBER := fnd_global.PROG_APPL_ID;
8193: v_program_id NUMBER := fnd_global.conc_program_id;
8194: v_program_update_date DATE := sysdate;
8195: --
8196: BEGIN
8189: v_last_updated_by NUMBER := fnd_global.user_id;
8190: v_last_update_login NUMBER := fnd_global.login_id;
8191: v_request_id NUMBER := fnd_global.conc_REQUEST_ID;
8192: v_program_application_id NUMBER := fnd_global.PROG_APPL_ID;
8193: v_program_id NUMBER := fnd_global.conc_program_id;
8194: v_program_update_date DATE := sysdate;
8195: --
8196: BEGIN
8197: --
8900: SCHEDULE_PURPOSE_EXT = g_header_rec.SCHEDULE_PURPOSE_EXT ,
8901: SCHEDULE_REFERENCE_NUM = g_header_rec.SCHEDULE_REFERENCE_NUM ,
8902: SCHEDULE_SOURCE = g_header_rec.SCHEDULE_SOURCE ,
8903: LAST_UPDATE_DATE = sysdate,
8904: LAST_UPDATED_BY = fnd_global.user_id ,
8905: CREATION_DATE = g_header_rec.CREATION_DATE ,
8906: CREATED_BY = g_header_rec.CREATED_BY ,
8907: ATTRIBUTE_CATEGORY = g_header_rec.ATTRIBUTE_CATEGORY ,
8908: ATTRIBUTE1 = g_header_rec.ATTRIBUTE1 ,
8919: ATTRIBUTE12 = g_header_rec.ATTRIBUTE12 ,
8920: ATTRIBUTE13 = g_header_rec.ATTRIBUTE13 ,
8921: ATTRIBUTE14 = g_header_rec.ATTRIBUTE14 ,
8922: ATTRIBUTE15 = g_header_rec.ATTRIBUTE15 ,
8923: LAST_UPDATE_LOGIN = fnd_global.login_id ,
8924: REQUEST_ID = fnd_global.conc_REQUEST_ID ,
8925: PROGRAM_APPLICATION_ID = fnd_global.PROG_APPL_ID ,
8926: PROGRAM_ID = fnd_global.conc_PROGRAM_ID ,
8927: PROGRAM_UPDATE_DATE = sysdate
8920: ATTRIBUTE13 = g_header_rec.ATTRIBUTE13 ,
8921: ATTRIBUTE14 = g_header_rec.ATTRIBUTE14 ,
8922: ATTRIBUTE15 = g_header_rec.ATTRIBUTE15 ,
8923: LAST_UPDATE_LOGIN = fnd_global.login_id ,
8924: REQUEST_ID = fnd_global.conc_REQUEST_ID ,
8925: PROGRAM_APPLICATION_ID = fnd_global.PROG_APPL_ID ,
8926: PROGRAM_ID = fnd_global.conc_PROGRAM_ID ,
8927: PROGRAM_UPDATE_DATE = sysdate
8928: WHERE header_id = g_header_rec.header_id;
8921: ATTRIBUTE14 = g_header_rec.ATTRIBUTE14 ,
8922: ATTRIBUTE15 = g_header_rec.ATTRIBUTE15 ,
8923: LAST_UPDATE_LOGIN = fnd_global.login_id ,
8924: REQUEST_ID = fnd_global.conc_REQUEST_ID ,
8925: PROGRAM_APPLICATION_ID = fnd_global.PROG_APPL_ID ,
8926: PROGRAM_ID = fnd_global.conc_PROGRAM_ID ,
8927: PROGRAM_UPDATE_DATE = sysdate
8928: WHERE header_id = g_header_rec.header_id;
8929:
8922: ATTRIBUTE15 = g_header_rec.ATTRIBUTE15 ,
8923: LAST_UPDATE_LOGIN = fnd_global.login_id ,
8924: REQUEST_ID = fnd_global.conc_REQUEST_ID ,
8925: PROGRAM_APPLICATION_ID = fnd_global.PROG_APPL_ID ,
8926: PROGRAM_ID = fnd_global.conc_PROGRAM_ID ,
8927: PROGRAM_UPDATE_DATE = sysdate
8928: WHERE header_id = g_header_rec.header_id;
8929:
8930: --