APPS.PAY_ELE_CLASS_RULES_PKG dependencies on PAY_ELE_CLASSIFICATION_RULES

Line 95: from pay_ele_classification_rules ecr

91: ) is
92: --
93: cursor csr_ele_class_rule is
94: select ecr.classification_id
95: from pay_ele_classification_rules ecr
96: where ecr.element_set_id = p_element_set_id
97: and ecr.classification_id = p_classification_id
98: and (p_rowid is null or
99: (p_rowid is not null and chartorowid(p_rowid) <> ecr.rowid));

Line 202: CURSOR C IS SELECT rowid FROM pay_ele_classification_rules

198: X_Classification_Id NUMBER,
199: -- Extra Columns
200: X_Element_Set_Type VARCHAR2) IS
201: --
202: CURSOR C IS SELECT rowid FROM pay_ele_classification_rules
203: WHERE element_set_id = X_Element_Set_Id
204: AND classification_id = X_Classification_Id;
205: --
206: BEGIN

Line 227: INSERT INTO pay_ele_classification_rules

223: X_Classification_Id);
224: --
225: end if;
226: --
227: INSERT INTO pay_ele_classification_rules
228: (element_set_id,
229: classification_id)
230: VALUES
231: (X_Element_Set_Id,

Line 265: CURSOR C IS SELECT * FROM pay_ele_classification_rules

261: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
262: X_Element_Set_Id NUMBER,
263: X_Classification_Id NUMBER) IS
264: --
265: CURSOR C IS SELECT * FROM pay_ele_classification_rules
266: WHERE rowid = X_Rowid FOR UPDATE of Element_Set_Id NOWAIT;
267: --
268: Recinfo C%ROWTYPE;
269: --

Line 315: UPDATE pay_ele_classification_rules

311: X_Element_Set_Id NUMBER,
312: X_Classification_Id NUMBER) IS
313: BEGIN
314: --
315: UPDATE pay_ele_classification_rules
316: SET element_set_id = X_Element_Set_Id,
317: classification_id = X_Classification_Id
318: WHERE rowid = X_rowid;
319: --

Line 355: DELETE FROM pay_ele_classification_rules

351: chk_delete_ele_classification
352: (X_Element_Set_Id,
353: X_Classification_Id);
354: --
355: DELETE FROM pay_ele_classification_rules
356: WHERE rowid = X_Rowid;
357: --
358: if (SQL%NOTFOUND) then
359: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');