PACKAGE: APPS.IGS_PR_VAL_POUS

Source

1 PACKAGE IGS_PR_VAL_POUS AUTHID CURRENT_USER AS
2 /* $Header: IGSPR18S.pls 115.7 2002/11/29 02:48:35 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_US_ACTIVE) - from the spec and body. -- kdande
11 */
12   --
13 
14   TYPE r_pous_record_type IS RECORD
15 
16   (
17 
18   progression_rule_cat IGS_PR_OU_UNIT_SET_ALL.PROGRESSION_RULE_CAT%TYPE,
19 
20   pra_sequence_number IGS_PR_OU_UNIT_SET_ALL.PRA_SEQUENCE_NUMBER%TYPE,
21 
22 
23   pro_sequence_number IGS_PR_OU_UNIT_SET_ALL.PRO_SEQUENCE_NUMBER%TYPE,
24 
25   unit_set_cd IGS_PR_OU_UNIT_SET_ALL.UNIT_SET_CD%TYPE,
26 
27   us_version_number IGS_PR_OU_UNIT_SET_ALL.US_VERSION_NUMBER%TYPE);
28 
29   --
30 
31   --
32 
33   TYPE t_pous_table IS TABLE OF
34 
35 
36   IGS_PR_VAL_POUS.r_pous_record_type
37 
38   INDEX BY BINARY_INTEGER;
39 
40   --
41 
42   --
43 
44   gt_rowid_table t_pous_table;
45 
46   --
47 
48   --
49 
50 
51   gt_empty_table t_pous_table;
52 
53   --
54 
55   --
56 
57   gv_table_index BINARY_INTEGER;
58 
59   --
60 
61   -- Validate that a prg_outcome_unit_set record can be created
62 
63 
64   FUNCTION prgp_val_pous_pro(
65 
66   p_progression_rule_cat IN VARCHAR2 ,
67 
68   p_pra_sequence_number IN NUMBER ,
69 
70   p_sequence_number IN NUMBER ,
71 
72   p_message_name OUT NOCOPY VARCHAR2 )
73 
74 RETURN BOOLEAN;
75 
76   --
77 
78 
79   -- Validate progression rule outcome automatically apply indicator
80 
81   FUNCTION prgp_val_pous_auto(
82 
83   p_progression_rule_cat IN VARCHAR2 ,
84 
85   p_pra_sequence_number IN NUMBER ,
86 
87   p_pro_sequence_number IN NUMBER ,
88 
89   p_unit_set_cd IN VARCHAR2 ,
90 
91 
92   p_us_version_number IN NUMBER ,
93 
94   p_message_name OUT NOCOPY VARCHAR2 )
95 
96 RETURN BOOLEAN;
97 
98   --
99 
100   --
101 
102   -- Routine to process rowids in a PL/SQL TABLE for the current commit.
103 
104   FUNCTION prgp_prc_pous_rowids(
105 
106   p_inserting IN BOOLEAN ,
107 
108   p_updating IN BOOLEAN ,
109 
110   p_deleting IN BOOLEAN ,
111 
112 
113   p_message_name OUT NOCOPY VARCHAR2 )
114 
115 RETURN BOOLEAN;
116 
117   --
118 
119   -- Routine to save key in a PL/SQL TABLE for the current commit.
120 
121   PROCEDURE prgp_set_pous_rowid(
122 
123   p_progression_rule_cat IN VARCHAR2 ,
124 
125   p_pra_sequence_number IN NUMBER ,
126 
127 
128   p_pro_sequence_number IN NUMBER ,
129 
130   p_unit_set_cd IN VARCHAR2 ,
131 
132   p_us_version_number IN NUMBER )
133 
134 ;
135 END IGS_PR_VAL_POUS;