APPS.CS_SR_EVENT_ACTIONS_PKG dependencies on CS_SR_EVENT_ACTIONS

Line 1: package body CS_SR_EVENT_ACTIONS_PKG as

1: package body CS_SR_EVENT_ACTIONS_PKG as
2: /* $Header: csxtneab.pls 120.0 2005/08/12 15:29:53 aneemuch noship $ */
3: procedure INSERT_ROW (
4: PX_EVENT_CODE in out NOCOPY VARCHAR2,
5: PX_ACTION_CODE in out NOCOPY VARCHAR2,

Line 19: insert into CS_SR_EVENT_ACTIONS (

15: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
16: ) is
17: l_object_Version_number number := 1;
18: begin
19: insert into CS_SR_EVENT_ACTIONS (
20: EVENT_CODE,
21: ACTION_CODE,
22: SEEDED_FLAG,
23: APPLICATION_ID,

Line 57: from CS_SR_EVENT_ACTIONS

53: P_OBJECT_VERSION_NUMBER in NUMBER
54: ) is
55: cursor c is select
56: OBJECT_VERSION_NUMBER
57: from CS_SR_EVENT_ACTIONS
58: where EVENT_CODE = P_EVENT_CODE
59: and ACTION_CODE = P_ACTION_CODE
60: for update of EVENT_CODE nowait;
61:

Line 98: update CS_SR_EVENT_ACTIONS set

94: P_LAST_UPDATE_LOGIN in NUMBER,
95: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
96: ) is
97: begin
98: update CS_SR_EVENT_ACTIONS set
99: SEEDED_FLAG = P_SEEDED_FLAG,
100: APPLICATION_ID = P_APPLICATION_ID,
101: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
102: START_DATE_ACTIVE = P_START_DATE_ACTIVE,

Line 122: delete from CS_SR_EVENT_ACTIONS

118: P_EVENT_CODE in VARCHAR2,
119: P_ACTION_CODE in VARCHAR2
120: ) is
121: begin
122: delete from CS_SR_EVENT_ACTIONS
123: where EVENT_CODE = P_EVENT_CODE
124: and ACTION_CODE = P_ACTION_CODE;
125:
126: if (sql%notfound) then

Line 201: end CS_SR_EVENT_ACTIONS_PKG;

197: );
198:
199: END LOAD_ROW;
200:
201: end CS_SR_EVENT_ACTIONS_PKG;