PACKAGE: APPS.IGS_PR_VAL_SPC

Source

1 PACKAGE IGS_PR_VAL_SPC AUTHID CURRENT_USER AS
2 /* $Header: IGSPR20S.pls 115.8 2002/11/29 02:49:06 nsidana ship $ */
3   -------------------------------------------------------------------------------------------
4   --Change History:
5   --Who         When            What
6   --smadathi    29-AUG-2001     Bug No. 1956374 .The function declaration of prgp_val_crv_active removed
7 
8   -------------------------------------------------------------------------------------------
9    /* Bug 1956374
10    Who msrinivi
11    What duplicate removal Rremoved genp_prc_clear_rowid,genp_set_row_id
12   */
13   --
14 
15   TYPE r_spc_record_type IS RECORD
16 
17   (
18 
19   person_id IGS_PR_STDNT_PR_OU_ALL.PERSON_ID%TYPE,
20 
21   course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%TYPE,
22 
23   sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE);
24 
25   --
26 
27   --
28 
29   TYPE t_spc_table IS TABLE OF
30 
31   IGS_PR_VAL_SPC.r_spc_record_type
32 
33 
34   INDEX BY BINARY_INTEGER;
35 
36   --
37 
38   --
39 
40   gt_rowid_table t_spc_table;
41 
42   --
43 
44   --
45 
46   gt_empty_table t_spc_table;
47 
48   --
49 
50   --
51 
52   gv_table_index BINARY_INTEGER;
53 
54 
55 
56   -- Validate student progression course / outcome relationship
57 
58   FUNCTION prgp_val_spc_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_message_name OUT NOCOPY VARCHAR2 )
67 
68 
69 RETURN BOOLEAN;
70 
71   --
72 
73 
74   --
75 
76   -- Routine to process rowids in a PL/SQL TABLE for the current commit.
77 
78   FUNCTION prgp_prc_spc_rowids(
79 
80   p_inserting IN BOOLEAN ,
81 
82   p_updating IN BOOLEAN ,
83 
84   p_deleting IN BOOLEAN ,
85 
86 
87   p_message_name OUT NOCOPY VARCHAR2 )
88 
89 RETURN BOOLEAN;
90 
91   --
92 
93   -- Routine to save key in a PL/SQL TABLE for the current commit.
94 
95   PROCEDURE prgp_set_spc_rowid(
96 
97   p_person_id IN NUMBER ,
98 
99   p_course_cd IN VARCHAR2 ,
100 
101   p_sequence_number IN NUMBER )
102 
103 ;
104 
105 END IGS_PR_VAL_SPC;