APPS.PA_CI_ACTIONS_PKG dependencies on PA_CI_ACTIONS

Line 1: package body PA_CI_ACTIONS_PKG as

1: package body PA_CI_ACTIONS_PKG as
2: /* $Header: PACIACTB.pls 120.0 2005/06/03 13:47:53 appldev noship $ */
3: procedure INSERT_ROW (
4: P_CI_ACTION_ID out NOCOPY NUMBER,
5: P_CI_ID in NUMBER,

Line 25: FROM PA_CI_ACTIONS

21: ) IS
22: -- Enter the procedure variables here. As shown below
23: CURSOR c1 IS
24: SELECT rowid
25: FROM PA_CI_ACTIONS
26: WHERE ci_action_id = p_ci_action_id;
27:
28: l_row_id ROWID;
29:

Line 32: Insert into PA_CI_ACTIONS (

28: l_row_id ROWID;
29:
30: BEGIN
31:
32: Insert into PA_CI_ACTIONS (
33: CI_ACTION_ID,
34: CI_ID,
35: CI_ACTION_NUMBER,
36: STATUS_CODE,

Line 51: ( PA_CI_ACTIONS_S.NEXTVAL,

47: LAST_UPDATE_DATE,
48: LAST_UPDATE_LOGIN,
49: RECORD_VERSION_NUMBER
50: ) VALUES
51: ( PA_CI_ACTIONS_S.NEXTVAL,
52: P_CI_ID,
53: P_CI_ACTION_NUMBER,
54: P_STATUS_CODE,
55: P_TYPE_CODE,

Line 95: UPDATE PA_CI_ACTIONS

91: P_LAST_UPDATE_LOGIN in NUMBER,
92: P_RECORD_VERSION_NUMBER in NUMBER
93: ) IS
94: BEGIN
95: UPDATE PA_CI_ACTIONS
96: SET
97: CI_ID = P_CI_ID,
98: STATUS_CODE = P_STATUS_CODE,
99: TYPE_CODE = P_TYPE_CODE,

Line 125: DELETE FROM PA_CI_ACTIONS

121: P_CI_ACTION_ID in NUMBER
122: )
123: IS
124: BEGIN
125: DELETE FROM PA_CI_ACTIONS
126: WHERE CI_ACTION_ID = P_CI_ACTION_ID;
127:
128: EXCEPTION
129: WHEN OTHERS THEN

Line 135: END PA_CI_ACTIONS_PKG; -- Package Body PA_CI_ACTION_PKG

131: END DELETE_ROW;
132:
133:
134: -- Enter further code below as specified in the Package spec.
135: END PA_CI_ACTIONS_PKG; -- Package Body PA_CI_ACTION_PKG
136:
137: