DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on FND_GLOBAL

Line 649: fnd_global.user_id,

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,

Line 651: fnd_global.user_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),

Line 653: fnd_global.login_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)

Line 654: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_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: );

Line 655: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

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;

Line 656: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),

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:

Line 657: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)

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

Line 697: fnd_global.user_id,

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,

Line 699: fnd_global.user_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),

Line 701: fnd_global.login_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) )

Line 702: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_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;

Line 703: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_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;

Line 704: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),

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:

Line 705: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )

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;

Line 728: fnd_global.user_id,

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 )

Line 730: fnd_global.user_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:

Line 732: fnd_global.login_id )

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: