APPS.PV_PEC_RULES_PKG dependencies on PV_PG_ENRL_CHANGE_RULES

Line 67: INSERT INTO pv_pg_enrl_change_rules(

63:
64: px_object_version_number := nvl(px_object_version_number, 1);
65:
66:
67: INSERT INTO pv_pg_enrl_change_rules(
68: enrl_change_rule_id,
69: object_version_number,
70: change_from_program_id,
71: change_to_program_id,

Line 128: Update pv_pg_enrl_change_rules

124: p_last_update_login NUMBER)
125:
126: IS
127: BEGIN
128: Update pv_pg_enrl_change_rules
129: SET
130: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
131: object_version_number = object_version_number + 1 ,
132: change_from_program_id = DECODE( p_change_from_program_id, null, change_from_program_id, FND_API.G_MISS_NUM, null, p_change_from_program_id),

Line 173: DELETE FROM pv_pg_enrl_change_rules

169: p_enrl_change_rule_id NUMBER,
170: p_object_version_number NUMBER)
171: IS
172: BEGIN
173: DELETE FROM pv_pg_enrl_change_rules
174: WHERE enrl_change_rule_id = p_enrl_change_rule_id
175: AND object_version_number = p_object_version_number;
176: If (SQL%NOTFOUND) then
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 203: FROM pv_pg_enrl_change_rules

199: p_object_version_number NUMBER)
200: IS
201: CURSOR C IS
202: SELECT *
203: FROM pv_pg_enrl_change_rules
204: WHERE enrl_change_rule_id = p_enrl_change_rule_id
205: AND object_version_number = p_object_version_number
206: FOR UPDATE OF enrl_change_rule_id NOWAIT;
207: Recinfo C%ROWTYPE;