APPS.PA_PM_CONTROL_RULES_PKG dependencies on PA_PM_PRODUCT_CONTROL_RULES

Line 17: CURSOR C IS SELECT rowid FROM pa_pm_product_control_rules

13: X_Last_Updated_By IN NUMBER,
14: X_Last_Update_Login IN NUMBER
15: ) IS
16:
17: CURSOR C IS SELECT rowid FROM pa_pm_product_control_rules
18: WHERE control_rule_id = X_Control_Rule_id
19: AND pm_product_code = X_Pm_product_code ;
20: BEGIN
21:

Line 22: INSERT INTO pa_pm_product_control_rules(

18: WHERE control_rule_id = X_Control_Rule_id
19: AND pm_product_code = X_Pm_product_code ;
20: BEGIN
21:
22: INSERT INTO pa_pm_product_control_rules(
23: control_rule_id,
24: pm_product_code,
25: field_value_code,
26: start_date_active,

Line 66: FROM pa_pm_product_control_rules

62: ) IS
63:
64: CURSOR C IS
65: SELECT *
66: FROM pa_pm_product_control_rules
67: WHERE rowid = X_Rowid
68: FOR UPDATE of end_date_active NOWAIT;
69: Recinfo C%ROWTYPE;
70:

Line 109: UPDATE pa_pm_product_control_rules

105: X_Last_Update_Login IN NUMBER
106:
107: ) IS
108: BEGIN
109: UPDATE pa_pm_product_control_rules
110: SET
111: start_date_active = x_start_date,
112: end_date_active = X_end_date
113: WHERE rowid = X_Rowid;

Line 122: DELETE FROM pa_pm_product_control_rules

118: END Update_Row;
119:
120: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
121: BEGIN
122: DELETE FROM pa_pm_product_control_rules
123: WHERE rowid = X_Rowid;
124:
125: if (SQL%NOTFOUND) then
126: Raise NO_DATA_FOUND;