644: l_oss_sex_val igs_ad_interface_all.sex%TYPE;
645:
646: BEGIN
647: -- initialize variables
648: l_created_by := fnd_global.user_id;
649: l_last_updated_by := l_created_by;
650: l_last_update_login := fnd_global.login_id;
651: l_creation_date := SYSDATE;
652: l_last_update_date := l_creation_date;
646: BEGIN
647: -- initialize variables
648: l_created_by := fnd_global.user_id;
649: l_last_updated_by := l_created_by;
650: l_last_update_login := fnd_global.login_id;
651: l_creation_date := SYSDATE;
652: l_last_update_date := l_creation_date;
653:
654: -- initialize variables
1090: program_update_date,
1091: program_id)
1092: VALUES ( l_adm_batch_id,
1093: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
1094: fnd_global.user_id,
1095: SYSDATE,
1096: fnd_global.user_id,
1097: SYSDATE,
1098: fnd_global.login_id,
1092: VALUES ( l_adm_batch_id,
1093: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
1094: fnd_global.user_id,
1095: SYSDATE,
1096: fnd_global.user_id,
1097: SYSDATE,
1098: fnd_global.login_id,
1099: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1100: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1094: fnd_global.user_id,
1095: SYSDATE,
1096: fnd_global.user_id,
1097: SYSDATE,
1098: fnd_global.login_id,
1099: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1100: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1101: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1102: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1095: SYSDATE,
1096: fnd_global.user_id,
1097: SYSDATE,
1098: fnd_global.login_id,
1099: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1100: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1101: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1102: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1103: );
1096: fnd_global.user_id,
1097: SYSDATE,
1098: fnd_global.login_id,
1099: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1100: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1101: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1102: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1103: );
1104:
1097: SYSDATE,
1098: fnd_global.login_id,
1099: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1100: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1101: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1102: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1103: );
1104:
1105: EXCEPTION
1098: fnd_global.login_id,
1099: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1100: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1101: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1102: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1103: );
1104:
1105: EXCEPTION
1106: WHEN OTHERS THEN