PACKAGE: APPS.IGS_PR_VAL_SPU

Source

1 PACKAGE IGS_PR_VAL_SPU AUTHID CURRENT_USER AS
2 /* $Header: IGSPR22S.pls 115.7 2002/11/29 02:49:44 nsidana ship $ */
3 
4   /* Bug 1956374
5    Who msrinivi
6    What duplicate removal Rremoved genp_prc_clear_rowid
7   */
8 /*
9 ||  Bug ID 1956374 - Removal of Duplicate Program Units from OSS.
10 ||  Removed program unit (PRGP_VAL_UV_ACTIVE) - from the spec and body. -- kdande
11 */
12   --
13 
14   TYPE r_spu_record_type IS RECORD
15 
16   (
17 
18   person_id IGS_PR_STDNT_PR_OU_ALL.PERSON_ID%TYPE,
19 
20   course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%TYPE,
21 
22   sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE);
23 
24   --
25 
26   --
27 
28   TYPE t_spu_table IS TABLE OF
29 
30   IGS_PR_VAL_SPU.r_spu_record_type
31 
32 
33   INDEX BY BINARY_INTEGER;
34 
35   --
36 
37   --
38 
39   gt_rowid_table t_spu_table;
40 
41   --
42 
43   --
44 
45   gt_empty_table t_spu_table;
46 
47   --
48 
49   --
50 
51   gv_table_index BINARY_INTEGER;
52 
53   --
54 
55 
56   -- Validate student progression unit / outcome relationship
57 
58   FUNCTION prgp_val_spu_spo(
59 
60   p_person_id IN NUMBER ,
61 
62   p_course_cd IN VARCHAR2 ,
63 
64   p_sequence_number IN NUMBER ,
65 
66   p_s_unit_type IN VARCHAR2 ,
67 
68   p_message_name OUT NOCOPY VARCHAR2 )
69 
70 RETURN BOOLEAN;
71 
72   --
73 
74 
75   -- Routine to process rowids in a PL/SQL TABLE for the current commit.
76 
77   FUNCTION prgp_prc_spu_rowids(
78 
79   p_inserting IN BOOLEAN ,
80 
81   p_updating IN BOOLEAN ,
82 
83 
84   p_deleting IN BOOLEAN ,
85 
86   p_message_name OUT NOCOPY VARCHAR2 )
87 
88 RETURN BOOLEAN;
89 
90   --
91 
92   -- Routine to save key in a PL/SQL TABLE for the current commit.
93 
94   PROCEDURE prgp_set_spu_rowid(
95 
96   p_person_id IN NUMBER ,
97 
98   p_course_cd IN VARCHAR2 ,
99 
100   p_sequence_number IN NUMBER )
101 
102 ;
103 
104 
105 END IGS_PR_VAL_SPU;