APPS.IGS_PS_WF_EVENT_HOOK_PKG dependencies on IGS_PS_WF_EVENT_HOOK_PKG

Line 1: PACKAGE BODY IGS_PS_WF_EVENT_HOOK_PKG AS

1: PACKAGE BODY IGS_PS_WF_EVENT_HOOK_PKG AS
2: /* $Header: IGSPS79B.pls 120.2 2006/01/31 01:52:02 sommukhe noship $ */
3: procedure wf_get_shadow_values( p_uoo_id IN NUMBER,
4: p_unit_section_occurrence_id IN NUMBER,
5: p_type IN VARCHAR2,

Line 6: p_old_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCUROLD,

2: /* $Header: IGSPS79B.pls 120.2 2006/01/31 01:52:02 sommukhe noship $ */
3: procedure wf_get_shadow_values( p_uoo_id IN NUMBER,
4: p_unit_section_occurrence_id IN NUMBER,
5: p_type IN VARCHAR2,
6: p_old_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCUROLD,
7: p_new_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCURNEW,
8: p_unit_dtls IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.UNITDTLS)
9: IS
10: /**********************************************************

Line 7: p_new_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCURNEW,

3: procedure wf_get_shadow_values( p_uoo_id IN NUMBER,
4: p_unit_section_occurrence_id IN NUMBER,
5: p_type IN VARCHAR2,
6: p_old_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCUROLD,
7: p_new_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCURNEW,
8: p_unit_dtls IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.UNITDTLS)
9: IS
10: /**********************************************************
11: Created By :

Line 8: p_unit_dtls IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.UNITDTLS)

4: p_unit_section_occurrence_id IN NUMBER,
5: p_type IN VARCHAR2,
6: p_old_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCUROLD,
7: p_new_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCURNEW,
8: p_unit_dtls IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.UNITDTLS)
9: IS
10: /**********************************************************
11: Created By :
12:

Line 87: p_students IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.StudentDetails,

83:
84: procedure wf_event_audience (p_uoo_id IN NUMBER,
85: p_unit_section_occurrence_id IN NUMBER,
86: p_type IN VARCHAR2,
87: p_students IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.StudentDetails,
88: p_instructors IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.InstructorDetails)
89: IS
90: CURSOR c_notify IS SELECT a.inst_notify_ind,
91: b.instructor_id

Line 88: p_instructors IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.InstructorDetails)

84: procedure wf_event_audience (p_uoo_id IN NUMBER,
85: p_unit_section_occurrence_id IN NUMBER,
86: p_type IN VARCHAR2,
87: p_students IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.StudentDetails,
88: p_instructors IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.InstructorDetails)
89: IS
90: CURSOR c_notify IS SELECT a.inst_notify_ind,
91: b.instructor_id
92: FROM IGS_PS_USEC_OCCURS a,

Line 156: END IGS_PS_WF_EVENT_HOOK_PKG;

152: END LOOP;
153: END IF;
154: CLOSE c_notify;
155: END wf_event_audience;
156: END IGS_PS_WF_EVENT_HOOK_PKG;