APPS.CS_SR_ACTION_DETAILS_PKG dependencies on CS_SR_ACTION_DETAILS

Line 1: package body CS_SR_ACTION_DETAILS_PKG as

1: package body CS_SR_ACTION_DETAILS_PKG as
2: /* $Header: csxtnadb.pls 120.0 2005/08/12 15:28:48 aneemuch noship $ */
3:
4: procedure INSERT_ROW (
5: PX_EVENT_ACTION_DETAIL_ID in out NOCOPY NUMBER,

Line 32: insert into CS_SR_ACTION_DETAILS (

28: FETCH C2 INTO px_EVENT_ACTION_DETAIL_ID;
29: CLOSE C2;
30: End If;
31:
32: insert into CS_SR_ACTION_DETAILS (
33: EVENT_ACTION_DETAIL_ID,
34: EVENT_CONDITION_ID,
35: RESOLUTION_CODE,
36: INCIDENT_STATUS_ID,

Line 78: from CS_SR_ACTION_DETAILS

74: P_OBJECT_VERSION_NUMBER in NUMBER
75: ) is
76: cursor c is select
77: OBJECT_VERSION_NUMBER
78: from CS_SR_ACTION_DETAILS
79: where EVENT_ACTION_DETAIL_ID = P_EVENT_ACTION_DETAIL_ID
80: for update of EVENT_ACTION_DETAIL_ID nowait;
81:
82: l_object_version_number number := 0;

Line 121: update CS_SR_ACTION_DETAILS set

117: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
118: ) is
119: l_object_Version_number number;
120: begin
121: update CS_SR_ACTION_DETAILS set
122: RESOLUTION_CODE = P_RESOLUTION_CODE,
123: INCIDENT_STATUS_ID = P_INCIDENT_STATUS_ID,
124: START_DATE_ACTIVE = P_START_DATE_ACTIVE,
125: END_DATE_ACTIVE = P_END_DATE_ACTIVE,

Line 151: delete from CS_SR_ACTION_DETAILS

147: procedure DELETE_ROW (
148: P_EVENT_ACTION_DETAIL_ID in NUMBER
149: ) is
150: begin
151: delete from CS_SR_ACTION_DETAILS
152: where EVENT_ACTION_DETAIL_ID = P_EVENT_ACTION_DETAIL_ID;
153:
154:
155: if (sql%notfound) then

Line 244: end CS_SR_ACTION_DETAILS_PKG;

240: );
241:
242: END LOAD_ROW;
243:
244: end CS_SR_ACTION_DETAILS_PKG;