DBA Data[Home] [Help]

APPS.CS_SR_ACTION_TRIGGERS_PKG dependencies on CS_SR_ACTION_TRIGGERS_S

Line 20: CURSOR C2 IS SELECT CS_SR_ACTION_TRIGGERS_S.nextval FROM sys.dual;

16: P_LAST_UPDATED_BY in NUMBER,
17: P_LAST_UPDATE_LOGIN in NUMBER,
18: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
19: ) is
20: CURSOR C2 IS SELECT CS_SR_ACTION_TRIGGERS_S.nextval FROM sys.dual;
21: l_object_version_number number := 1;
22: begin
23: If (px_EVENT_CONDITION_ID IS NULL) OR (px_EVENT_CONDITION_ID = FND_API.G_MISS_NUM) then
24: OPEN C2;

Line 117: update CS_SR_ACTION_TRIGGERS set

113: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
114: ) is
115: l_object_Version_number number;
116: begin
117: update CS_SR_ACTION_TRIGGERS set
118: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
119: FROM_TO_STATUS_CODE = P_FROM_TO_STATUS_CODE,
120: INCIDENT_STATUS_ID = P_INCIDENT_STATUS_ID,
121: RELATIONSHIP_TYPE_ID = P_RELATIONSHIP_TYPE_ID,