APPS.PAY_FUNCTIONAL_TRIGGERS_PKG dependencies on PAY_FUNCTIONAL_TRIGGERS

Line 1: PACKAGE BODY pay_functional_triggers_pkg AS

1: PACKAGE BODY pay_functional_triggers_pkg AS
2: -- $Header: pypftapi.pkb 115.2 2002/12/11 15:13:31 exjones noship $
3: --
4: PROCEDURE lock_row(
5: p_row_id IN VARCHAR2,

Line 13: FROM pay_functional_triggers

9: ) IS
10: --
11: CURSOR csr_functional_trigger IS
12: SELECT *
13: FROM pay_functional_triggers
14: WHERE rowid = p_row_id
15: FOR UPDATE OF
16: trigger_id NOWAIT;
17: --

Line 28: 'PAY_FUNCTIONAL_TRIGGERS_PKG.LOCK_ROW'

24: CLOSE csr_functional_trigger;
25: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
26: Hr_Utility.Set_Message_Token(
27: 'PROCEDURE',
28: 'PAY_FUNCTIONAL_TRIGGERS_PKG.LOCK_ROW'
29: );
30: END IF;
31: CLOSE csr_functional_trigger;
32: --

Line 55: SELECT pay_functional_triggers_s.NEXTVAL

51: p_event_id IN NUMBER
52: ) IS
53: --
54: CURSOR csr_new_id IS
55: SELECT pay_functional_triggers_s.NEXTVAL
56: FROM dual;
57: --
58: CURSOR csr_trigger_rowid IS
59: SELECT rowid

Line 60: FROM pay_functional_triggers

56: FROM dual;
57: --
58: CURSOR csr_trigger_rowid IS
59: SELECT rowid
60: FROM pay_functional_triggers
61: WHERE trigger_id = p_trigger_id;
62: --
63: BEGIN
64: --

Line 69: INSERT INTO pay_functional_triggers(

65: OPEN csr_new_id;
66: FETCH csr_new_id INTO p_trigger_id;
67: CLOSE csr_new_id;
68: --
69: INSERT INTO pay_functional_triggers(
70: trigger_id,
71: area_id,
72: event_id
73: ) VALUES (

Line 86: 'PAY_FUNCTIONAL_TRIGGERS_PKG.INSERT_ROW'

82: CLOSE csr_trigger_rowid;
83: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
84: Hr_Utility.Set_Message_Token(
85: 'PROCEDURE',
86: 'PAY_FUNCTIONAL_TRIGGERS_PKG.INSERT_ROW'
87: );
88: END IF;
89: CLOSE csr_trigger_rowid;
90: --

Line 100: UPDATE pay_functional_triggers

96: p_area_id IN NUMBER,
97: p_event_id IN NUMBER
98: ) IS
99: BEGIN
100: UPDATE pay_functional_triggers
101: SET trigger_id = p_trigger_id,
102: area_id = p_area_id,
103: event_id = p_event_id
104: WHERE rowid = p_row_id;

Line 110: 'PAY_FUNCTIONAL_TRIGGERS_PKG.UPDATE_ROW'

106: IF SQL%NOTFOUND THEN
107: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
108: Hr_Utility.Set_Message_Token(
109: 'PROCEDURE',
110: 'PAY_FUNCTIONAL_TRIGGERS_PKG.UPDATE_ROW'
111: );
112: END IF;
113: END update_row;
114: --

Line 121: FROM pay_functional_triggers

117: p_trigger_id IN NUMBER
118: ) IS
119: BEGIN
120: DELETE
121: FROM pay_functional_triggers
122: WHERE rowid = p_row_id;
123: --
124: IF SQL%NOTFOUND THEN
125: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 128: 'PAY_FUNCTIONAL_TRIGGERS_PKG.DELETE_ROW'

124: IF SQL%NOTFOUND THEN
125: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: Hr_Utility.Set_Message_Token(
127: 'PROCEDURE',
128: 'PAY_FUNCTIONAL_TRIGGERS_PKG.DELETE_ROW'
129: );
130: END IF;
131: END delete_row;
132: --

Line 133: END pay_functional_triggers_pkg;

129: );
130: END IF;
131: END delete_row;
132: --
133: END pay_functional_triggers_pkg;