APPS.PAY_NET_CALCULATION_RULES_PKG dependencies on PAY_NET_CALCULATION_RULES

Line 1: PACKAGE BODY PAY_NET_CALCULATION_RULES_PKG as

1: PACKAGE BODY PAY_NET_CALCULATION_RULES_PKG as
2: /* $Header: pyapncr.pkb 115.1 99/07/17 05:42:06 porting ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,

Line 12: CURSOR C IS SELECT rowid FROM PAY_NET_CALCULATION_RULES

8: X_Business_Group_Id NUMBER,
9: X_Input_Value_Id NUMBER,
10: X_Add_Or_Subtract VARCHAR2
11: ) IS
12: CURSOR C IS SELECT rowid FROM PAY_NET_CALCULATION_RULES
13:
14: WHERE net_calculation_rule_id = X_Net_Calculation_Rule_Id;
15:
16:

Line 20: CURSOR C2 IS SELECT pay_net_calculation_rules_s.nextval FROM sys.dual;

16:
17:
18:
19:
20: CURSOR C2 IS SELECT pay_net_calculation_rules_s.nextval FROM sys.dual;
21: BEGIN
22:
23: if (X_Net_Calculation_Rule_Id is NULL) then
24: OPEN C2;

Line 28: INSERT INTO PAY_NET_CALCULATION_RULES(

24: OPEN C2;
25: FETCH C2 INTO X_Net_Calculation_Rule_Id;
26: CLOSE C2;
27: end if;
28: INSERT INTO PAY_NET_CALCULATION_RULES(
29: net_calculation_rule_id,
30: accrual_plan_id,
31: business_group_id,
32: input_value_id,

Line 59: FROM PAY_NET_CALCULATION_RULES

55: X_Add_Or_Subtract VARCHAR2
56: ) IS
57: CURSOR C IS
58: SELECT *
59: FROM PAY_NET_CALCULATION_RULES
60: WHERE rowid = X_Rowid
61: FOR UPDATE of Net_Calculation_Rule_Id NOWAIT;
62: Recinfo C%ROWTYPE;
63: BEGIN

Line 103: UPDATE PAY_NET_CALCULATION_RULES

99: X_Input_Value_Id NUMBER,
100: X_Add_Or_Subtract VARCHAR2
101: ) IS
102: BEGIN
103: UPDATE PAY_NET_CALCULATION_RULES
104: SET
105: net_calculation_rule_id = X_Net_Calculation_Rule_Id,
106: accrual_plan_id = X_Accrual_Plan_Id,
107: business_group_id = X_Business_Group_Id,

Line 120: DELETE FROM PAY_NET_CALCULATION_RULES

116: END Update_Row;
117:
118: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
119: BEGIN
120: DELETE FROM PAY_NET_CALCULATION_RULES
121: WHERE rowid = X_Rowid;
122:
123: if (SQL%NOTFOUND) then
124: RAISE NO_DATA_FOUND;

Line 136: from pay_net_calculation_rules

132: l_comb_exists VARCHAR2(2);
133: --
134: CURSOR dup_rec IS
135: select 'Y'
136: from pay_net_calculation_rules
137: where
138: ((p_net_calculation_rule_id is null)
139: or (p_net_calculation_rule_id is not null
140: and net_calculation_rule_id <> p_net_calculation_rule_id))

Line 165: END PAY_NET_CALCULATION_RULES_PKG;

161: END IF;
162: --
163: END DUP_INPUT_VALUE;
164:
165: END PAY_NET_CALCULATION_RULES_PKG;