PACKAGE: APPS.IGS_PR_VAL_SPUS

Source

1 PACKAGE IGS_PR_VAL_SPUS AUTHID CURRENT_USER AS
2 /* $Header: IGSPR23S.pls 115.7 2002/11/29 02:49:59 nsidana ship $ */
3 
4   /* Bug 1956374
5    Who msrinivi
6    What duplicate removal Rremoved genp_prc_clear_rowid
7   */
8 
9   --
10 
11   TYPE r_spus_record_type IS RECORD
12 
13   (
14 
15   person_id IGS_PR_STDNT_PR_OU_ALL.PERSON_ID%TYPE,
16 
17   course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%TYPE,
18 
19   sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE);
20 
21   --
22 
23   --
24 
25   TYPE t_spus_table IS TABLE OF
26 
27   IGS_PR_VAL_SPUS.r_spus_record_type
28 
29 
30   INDEX BY BINARY_INTEGER;
31 
32   --
33 
34   --
35 
36   gt_rowid_table t_spus_table;
37 
38   --
39 
40   --
41 
42   gt_empty_table t_spus_table;
43 
44   --
45 
46   --
47 
48   gv_table_index BINARY_INTEGER;
49 
50   --
51 
52 
53   -- Validate student progression unit set / outcome relationship
54 
55   FUNCTION prgp_val_spus_spo(
56 
57   p_person_id IN NUMBER ,
58 
59   p_course_cd IN VARCHAR2 ,
60 
61   p_sequence_number IN NUMBER ,
62 
63   p_message_name OUT NOCOPY VARCHAR2 )
64 
65 RETURN BOOLEAN;
66 
67   --
68 
69   -- Validate that the unit set is active
70 
71   FUNCTION prgp_val_us_active(
72 
73   p_unit_set_cd IN VARCHAR2 ,
74 
75   p_version_number IN NUMBER ,
76 
77 
78   p_message_name OUT NOCOPY VARCHAR2 )
79 
80 RETURN BOOLEAN;
81 
82   --
83 
84 
85   --
86 
87   -- Routine to process rowids in a PL/SQL TABLE for the current commit.
88 
89   FUNCTION prgp_prc_spus_rowids(
90 
91   p_inserting IN BOOLEAN ,
92 
93   p_updating IN BOOLEAN ,
94 
95 
96   p_deleting IN BOOLEAN ,
97 
98   p_message_name OUT NOCOPY VARCHAR2 )
99 
100 RETURN BOOLEAN;
101 
102   --
103 
104   -- Routine to save key in a PL/SQL TABLE for the current commit.
105 
106   PROCEDURE prgp_set_spus_rowid(
107 
108   p_person_id IN NUMBER ,
109 
110   p_course_cd IN VARCHAR2 ,
111 
112   p_sequence_number IN NUMBER )
113 
114 ;
115 
116 END IGS_PR_VAL_SPUS;