PACKAGE: APPS.CS_SR_ACTION_DETAILS_PKG

Source

1 package CS_SR_ACTION_DETAILS_PKG AUTHID CURRENT_USER as
2 /* $Header: csxtnads.pls 120.0 2005/08/12 15:28:34 aneemuch noship $ */
3 
4 procedure INSERT_ROW (
5   PX_EVENT_ACTION_DETAIL_ID   in out NOCOPY NUMBER,
6   P_EVENT_CONDITION_ID in NUMBER,
7   P_RESOLUTION_CODE in VARCHAR2,
8   P_INCIDENT_STATUS_ID in NUMBER,
9   P_START_DATE_ACTIVE in DATE,
10   P_END_DATE_ACTIVE in DATE,
11   P_RELATIONSHIP_TYPE_ID in NUMBER,
12   P_SEEDED_FLAG in VARCHAR2,
13   P_APPLICATION_ID in NUMBER,
14   P_NOTIFICATION_TEMPLATE_ID in VARCHAR2,
15   P_ACTION_CODE in VARCHAR2,
16   P_CREATION_DATE in DATE,
17   P_CREATED_BY in NUMBER,
18   P_LAST_UPDATE_DATE in DATE,
19   P_LAST_UPDATED_BY in NUMBER,
20   P_LAST_UPDATE_LOGIN in NUMBER,
21   X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
22 );
23 
24 procedure LOCK_ROW (
25   P_EVENT_ACTION_DETAIL_ID in NUMBER,
26   P_OBJECT_VERSION_NUMBER in NUMBER
27 );
28 
29 procedure UPDATE_ROW (
30   P_EVENT_ACTION_DETAIL_ID   IN NUMBER,
31   P_EVENT_CONDITION_ID in NUMBER,
32   P_RESOLUTION_CODE in VARCHAR2,
33   P_INCIDENT_STATUS_ID in NUMBER,
34   P_START_DATE_ACTIVE in DATE,
35   P_END_DATE_ACTIVE in DATE,
36   P_RELATIONSHIP_TYPE_ID in NUMBER,
37   P_SEEDED_FLAG in VARCHAR2,
38   P_APPLICATION_ID in NUMBER,
39   P_NOTIFICATION_TEMPLATE_ID in VARCHAR2,
40   P_ACTION_CODE in VARCHAR2,
41   P_LAST_UPDATE_DATE in DATE,
42   P_LAST_UPDATED_BY in NUMBER,
43   P_LAST_UPDATE_LOGIN in NUMBER,
44   X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
45 );
46 
47 procedure DELETE_ROW (
48   P_EVENT_ACTION_DETAIL_ID in NUMBER
49 );
50 
51 PROCEDURE LOAD_ROW (
52   P_EVENT_CONDITION_ID       IN NUMBER,
53   P_RESOLUTION_CODE          IN VARCHAR2,
54   P_INCIDENT_STATUS_ID       IN NUMBER,
55   P_START_DATE_ACTIVE        IN VARCHAR2,
56   P_END_DATE_ACTIVE          IN VARCHAR2,
57   P_RELATIONSHIP_TYPE_ID     IN NUMBER,
58   P_SEEDED_FLAG              IN VARCHAR2,
59   P_APPLICATION_ID           IN NUMBER,
60   P_NOTIFICATION_TEMPLATE_ID IN VARCHAR2,
61   P_ACTION_CODE              IN VARCHAR2,
62   P_OWNER                    IN VARCHAR2,
63   P_CREATION_DATE            IN VARCHAR2,
64   P_CREATED_BY               IN NUMBER,
65   P_LAST_UPDATE_DATE         IN VARCHAR2,
66   P_LAST_UPDATED_BY          IN NUMBER,
67   P_LAST_UPDATE_LOGIN        IN NUMBER,
68   P_OBJECT_VERSION_NUMBER    IN NUMBER,
69   P_EVENT_ACTION_DETAIL_ID   IN NUMBER
70 );
71 
72 end CS_SR_ACTION_DETAILS_PKG;