PACKAGE: APPS.IGS_PR_VAL_POPU

Source

1 PACKAGE IGS_PR_VAL_POPU AUTHID CURRENT_USER AS
2 /* $Header: IGSPR17S.pls 115.7 2002/11/29 02:48:20 nsidana ship $ */
3 
4   --
5    /* Bug 1956374
6    Who msrinivi
7    What duplicate removal Rremoved genp_prc_clear_rowid,genp_set_row_id
8   */
9   --
10 
11   TYPE r_popu_record_type IS RECORD
12 
13   (
14 
15   progression_rule_cat IGS_PR_OU_UNIT_ALL.PROGRESSION_RULE_CAT%TYPE,
16 
17   pra_sequence_number IGS_PR_OU_UNIT_ALL.PRA_SEQUENCE_NUMBER%TYPE,
18 
19 
20   pro_sequence_number IGS_PR_OU_UNIT_ALL.PRO_SEQUENCE_NUMBER%TYPE,
21 
22   unit_cd IGS_PR_OU_UNIT_ALL.UNIT_CD%TYPE,
23 
24   old_s_unit_type IGS_PR_OU_UNIT_ALL.S_UNIT_TYPE%TYPE);
25 
26   --
27 
28   --
29 
30   TYPE t_popu_table IS TABLE OF
31 
32 
33   IGS_PR_VAL_POPU.r_popu_record_type
34 
35   INDEX BY BINARY_INTEGER;
36 
37   --
38 
39   --
40 
41   gt_rowid_table t_popu_table;
42 
43   --
44 
45   --
46 
47 
48   gt_empty_table t_popu_table;
49 
50   --
51 
52   --
53 
54   gv_table_index BINARY_INTEGER;
55 
56   --
57 
58   -- Validate that a prg_outcome_unit record can be created
59 
60 
61   FUNCTION prgp_val_popu_pro(
62 
63   p_progression_rule_cat IN VARCHAR2 ,
64 
65   p_pra_sequence_number IN NUMBER ,
66 
67   p_sequence_number IN NUMBER ,
68 
69   p_s_unit_type IN VARCHAR2 ,
70 
71   p_message_name OUT NOCOPY VARCHAR2 )
72 
73 RETURN BOOLEAN;
74 
75 
76   --
77 
78   -- Validate progression rule outcome automatically apply indicator
79 
80   FUNCTION prgp_val_popu_auto(
81 
82   p_progression_rule_cat IN VARCHAR2 ,
83 
84   p_pra_sequence_number IN NUMBER ,
85 
86   p_pro_sequence_number IN NUMBER ,
87 
88 
89   p_unit_cd IN VARCHAR2 ,
90 
91   p_old_s_unit_type IN VARCHAR2 ,
92 
93   p_message_name OUT NOCOPY VARCHAR2 )
94 
95 RETURN BOOLEAN;
96 
97   --
98 
99   -- Routine to process rowids in a PL/SQL TABLE for the current commit.
100 
101   FUNCTION prgp_prc_popu_rowids(
102 
103   p_inserting IN BOOLEAN ,
104 
105   p_updating IN BOOLEAN ,
106 
107 
108   p_deleting IN BOOLEAN ,
109 
110   p_message_name OUT NOCOPY VARCHAR2 )
111 
112 RETURN BOOLEAN;
113 
114   --
115 
116   -- Routine to save key in a PL/SQL TABLE for the current commit.
117 
118   PROCEDURE prgp_set_popu_rowid(
119 
120   p_progression_rule_cat IN VARCHAR2 ,
121 
122 
123   p_pra_sequence_number IN NUMBER ,
124 
125   p_pro_sequence_number IN NUMBER ,
126 
127   p_unit_cd IN VARCHAR2 ,
128 
129   p_old_s_unit_type IN VARCHAR2 )
130 
131 ;
132 
133   --
134 
135 
136   -- Warn if the unit does not have an active unit version
137 
138   FUNCTION prgp_val_uv_active(
139 
140   p_unit_cd IN VARCHAR2 ,
141 
142   p_message_name OUT NOCOPY VARCHAR2 )
143 
144 RETURN BOOLEAN;
145 
146 END IGS_PR_VAL_POPU;