645: program_update_date,
646: program_id)
647: VALUES ( l_imp_batch_id,
648: fnd_message.get_string('IGS','IGS_UC_IMP_ACAD_HIST_BATCH_ID'),
649: fnd_global.user_id,
650: SYSDATE,
651: fnd_global.user_id,
652: SYSDATE,
653: fnd_global.login_id,
647: VALUES ( l_imp_batch_id,
648: fnd_message.get_string('IGS','IGS_UC_IMP_ACAD_HIST_BATCH_ID'),
649: fnd_global.user_id,
650: SYSDATE,
651: fnd_global.user_id,
652: SYSDATE,
653: fnd_global.login_id,
654: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
655: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
649: fnd_global.user_id,
650: SYSDATE,
651: fnd_global.user_id,
652: SYSDATE,
653: fnd_global.login_id,
654: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
655: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
656: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
657: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
650: SYSDATE,
651: fnd_global.user_id,
652: SYSDATE,
653: fnd_global.login_id,
654: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
655: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
656: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
657: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
658: );
651: fnd_global.user_id,
652: SYSDATE,
653: fnd_global.login_id,
654: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
655: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
656: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
657: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
658: );
659: END IF;
652: SYSDATE,
653: fnd_global.login_id,
654: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
655: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
656: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
657: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
658: );
659: END IF;
660:
653: fnd_global.login_id,
654: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
655: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
656: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
657: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
658: );
659: END IF;
660:
661: IF l_interface_id IS NULL THEN
693: l_person_info_rec.birth_dt,
694: '1', --status
695: '2', --record_status,
696: '15', --Match_Ind
697: fnd_global.user_id,
698: SYSDATE,
699: fnd_global.user_id,
700: SYSDATE,
701: fnd_global.login_id,
695: '2', --record_status,
696: '15', --Match_Ind
697: fnd_global.user_id,
698: SYSDATE,
699: fnd_global.user_id,
700: SYSDATE,
701: fnd_global.login_id,
702: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
703: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
697: fnd_global.user_id,
698: SYSDATE,
699: fnd_global.user_id,
700: SYSDATE,
701: fnd_global.login_id,
702: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
703: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
704: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
705: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
698: SYSDATE,
699: fnd_global.user_id,
700: SYSDATE,
701: fnd_global.login_id,
702: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
703: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
704: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
705: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
706: RETURNING interface_id INTO l_interface_id;
699: fnd_global.user_id,
700: SYSDATE,
701: fnd_global.login_id,
702: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
703: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
704: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
705: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
706: RETURNING interface_id INTO l_interface_id;
707: END IF;
700: SYSDATE,
701: fnd_global.login_id,
702: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
703: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
704: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
705: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
706: RETURNING interface_id INTO l_interface_id;
707: END IF;
708:
701: fnd_global.login_id,
702: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
703: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
704: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
705: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
706: RETURNING interface_id INTO l_interface_id;
707: END IF;
708:
709: l_interface_stat_id := NULL;
724: l_interface_id,
725: l_oss_ethnic_origin,
726: l_oss_religion_cd,
727: '2',
728: fnd_global.user_id,
729: SYSDATE,
730: fnd_global.user_id,
731: SYSDATE,
732: fnd_global.login_id )
726: l_oss_religion_cd,
727: '2',
728: fnd_global.user_id,
729: SYSDATE,
730: fnd_global.user_id,
731: SYSDATE,
732: fnd_global.login_id )
733: RETURNING interface_stat_id INTO l_interface_stat_id;
734:
728: fnd_global.user_id,
729: SYSDATE,
730: fnd_global.user_id,
731: SYSDATE,
732: fnd_global.login_id )
733: RETURNING interface_stat_id INTO l_interface_stat_id;
734:
735: l_stat_int_rec_populated := 'Y';
736: