APPS.PAY_BACKPAY_RULES_PKG dependencies on PAY_BACKPAY_RULES

Line 1: PACKAGE BODY PAY_BACKPAY_RULES_PKG AS

1: PACKAGE BODY PAY_BACKPAY_RULES_PKG AS
2: /* $Header: pybkr01t.pkb 115.0 99/07/17 05:45:41 porting ship $ */
3: -----------------------------------------------------------------------------
4: -----------------------------------------------------------------------------
5: --

Line 15: from pay_backpay_rules

11: p_input_value_id number,
12: p_backpay_set_id number) is
13: cursor c1 is
14: select rowid
15: from pay_backpay_rules
16: where backpay_set_id = P_BACKPAY_SET_ID
17: and defined_balance_id = P_DEFINED_BALANCE_ID
18: and input_value_id = P_INPUT_VALUE_ID;
19: begin

Line 21: insert into pay_backpay_rules(

17: and defined_balance_id = P_DEFINED_BALANCE_ID
18: and input_value_id = P_INPUT_VALUE_ID;
19: begin
20: begin
21: insert into pay_backpay_rules(
22: defined_balance_id,
23: input_value_id,
24: backpay_set_id)
25: values (p_defined_balance_id,

Line 41: delete from pay_backpay_rules

37: -- Standard delete procedure
38: --
39: procedure delete_row(p_row_id varchar2) is
40: begin
41: delete from pay_backpay_rules
42: where rowid = chartorowid(P_ROW_ID);
43: end delete_row;
44: -----------------------------------------------------------------------------
45: --

Line 56: from pay_backpay_rules

52: p_backpay_set_id number) is
53: --
54: cursor CUR is
55: select *
56: from pay_backpay_rules
57: where rowid = chartorowid(P_ROW_ID)
58: FOR UPDATE OF BACKPAY_SET_ID NOWAIT;
59: --
60: rule_rec CUR%rowtype;

Line 100: update pay_backpay_rules

96: p_defined_balance_id number,
97: p_input_value_id number,
98: p_backpay_set_id number) is
99: begin
100: update pay_backpay_rules
101: set defined_balance_id = P_DEFINED_BALANCE_ID,
102: input_value_id = P_INPUT_VALUE_ID,
103: backpay_set_id = P_BACKPAY_SET_ID
104: where rowid = chartorowid(P_ROW_ID);

Line 123: from pay_backpay_rules br,

119: into l_null
120: from sys.dual
121: where not exists (
122: select null
123: from pay_backpay_rules br,
124: pay_defined_balances db
125: where br.backpay_set_id = P_BACKPAY_SET_ID
126: and br.defined_balance_id = db.defined_balance_id
127: and db.balance_type_id = P_BALANCE_TYPE_ID

Line 174: from pay_backpay_rules br,

170: into l_null
171: from sys.dual
172: where not exists (
173: select bf1.input_value_id, bf2.balance_type_id
174: from pay_backpay_rules br,
175: pay_defined_balances db,
176: pay_balance_feeds bf1,
177: pay_balance_feeds bf2
178: where bf1.balance_type_id = db.balance_type_id

Line 192: END PAY_BACKPAY_RULES_PKG;

188: end;
189: --
190: end chk_overlap_bal_feeds;
191: -----------------------------------------------------------------------------
192: END PAY_BACKPAY_RULES_PKG;