eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 32: (p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,

28: --Fwd Declarations
29: PROCEDURE logHeader(p_proc_name VARCHAR2, p_mode VARCHAR2);
30: PROCEDURE logDetail(p_debug_msg VARCHAR2, p_mode VARCHAR2);
31: FUNCTION create_application_detail
32: (p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
33: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE,
34: p_ss_adm_appl_number IN NUMBER) RETURN BOOLEAN;
35: FUNCTION create_application(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,
36: p_message_name OUT NOCOPY VARCHAR2,

Line 33: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE,

29: PROCEDURE logHeader(p_proc_name VARCHAR2, p_mode VARCHAR2);
30: PROCEDURE logDetail(p_debug_msg VARCHAR2, p_mode VARCHAR2);
31: FUNCTION create_application_detail
32: (p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
33: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE,
34: p_ss_adm_appl_number IN NUMBER) RETURN BOOLEAN;
35: FUNCTION create_application(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,
36: p_message_name OUT NOCOPY VARCHAR2,
37: p_return_status OUT NOCOPY VARCHAR2,

Line 44: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,

40: FUNCTION create_program(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,
41: p_message_name OUT NOCOPY VARCHAR2,
42: p_return_status OUT NOCOPY VARCHAR2,
43: p_adm_appl_number IN NUMBER) RETURN BOOLEAN;
44: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
45: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
46: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
47: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE);
48: --dhan

Line 45: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,

41: p_message_name OUT NOCOPY VARCHAR2,
42: p_return_status OUT NOCOPY VARCHAR2,
43: p_adm_appl_number IN NUMBER) RETURN BOOLEAN;
44: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
45: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
46: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
47: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE);
48: --dhan
49: PROCEDURE insert_othinst(p_person_id IN NUMBER,

Line 46: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,

42: p_return_status OUT NOCOPY VARCHAR2,
43: p_adm_appl_number IN NUMBER) RETURN BOOLEAN;
44: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
45: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
46: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
47: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE);
48: --dhan
49: PROCEDURE insert_othinst(p_person_id IN NUMBER,
50: p_adm_appl_id IN NUMBER,

Line 47: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE);

43: p_adm_appl_number IN NUMBER) RETURN BOOLEAN;
44: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
45: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
46: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
47: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE);
48: --dhan
49: PROCEDURE insert_othinst(p_person_id IN NUMBER,
50: p_adm_appl_id IN NUMBER,
51: p_admission_appl_number IN NUMBER);

Line 645: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,

641: App_Exception.Raise_Exception;
642:
643: END create_program;
644:
645: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
646: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
647: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
648: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE) AS
649:

Line 646: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,

642:
643: END create_program;
644:
645: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
646: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
647: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
648: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE) AS
649:
650: /*****************************************************************************************

Line 647: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,

643: END create_program;
644:
645: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
646: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
647: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
648: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE) AS
649:
650: /*****************************************************************************************
651: Created By: [email protected]

Line 648: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE) AS

644:
645: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
646: p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE,
647: p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
648: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE) AS
649:
650: /*****************************************************************************************
651: Created By: [email protected]
652: Date Created : 11-DEC-2001

Line 5830: (p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,

5826:
5827: END CHECK_INSTANCE_SECURITY;
5828:
5829: FUNCTION create_application_detail
5830: (p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
5831: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE,
5832: p_ss_adm_appl_number IN NUMBER) RETURN BOOLEAN IS
5833: lRetStat VARCHAR2(1);
5834: BEGIN

Line 5831: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE,

5827: END CHECK_INSTANCE_SECURITY;
5828:
5829: FUNCTION create_application_detail
5830: (p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
5831: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE,
5832: p_ss_adm_appl_number IN NUMBER) RETURN BOOLEAN IS
5833: lRetStat VARCHAR2(1);
5834: BEGIN
5835: lRetStat := 'S';