PACKAGE: APPS.FND_SVC_COMP_REQUESTS_PKG

Source

1 package FND_SVC_COMP_REQUESTS_PKG authid current_user as
2 /* $Header: AFSVCRTS.pls 115.2 2003/01/17 20:47:29 ankung noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_COMPONENT_REQUEST_ID in NUMBER,
7   X_COMPONENT_ID in NUMBER,
8   X_EVENT_NAME in VARCHAR2,
9   X_EVENT_DATE in DATE,
10   X_REQUESTED_BY_USER in VARCHAR2,
11   X_JOB_ID in NUMBER,
12   X_EVENT_PARAMS in VARCHAR2,
13   X_EVENT_FREQUENCY in NUMBER,
14   X_OBJECT_VERSION_NUMBER in NUMBER default 1,
15   X_CREATION_DATE in DATE default sysdate,
16   X_CREATED_BY in NUMBER,
17   X_LAST_UPDATE_DATE in DATE default sysdate,
18   X_LAST_UPDATED_BY in NUMBER,
19   X_LAST_UPDATE_LOGIN in NUMBER);
20 
21 procedure LOCK_ROW (
22   X_COMPONENT_REQUEST_ID in NUMBER,
23   X_COMPONENT_ID in NUMBER,
24   X_EVENT_NAME in VARCHAR2,
25   X_EVENT_DATE in DATE,
26   X_REQUESTED_BY_USER in VARCHAR2,
27   X_JOB_ID in NUMBER,
28   X_EVENT_PARAMS in VARCHAR2,
29   X_EVENT_FREQUENCY in NUMBER,
30   X_OBJECT_VERSION_NUMBER in NUMBER
31 );
32 
33 procedure UPDATE_ROW (
34   X_COMPONENT_REQUEST_ID in NUMBER,
35   X_COMPONENT_ID in NUMBER,
36   X_EVENT_NAME in VARCHAR2,
37   X_EVENT_DATE in DATE,
38   X_REQUESTED_BY_USER in VARCHAR2,
39   X_JOB_ID in NUMBER,
40   X_EVENT_PARAMS in VARCHAR2,
41   X_EVENT_FREQUENCY in NUMBER,
42   X_OBJECT_VERSION_NUMBER in NUMBER,
43   X_LAST_UPDATE_DATE in DATE default sysdate,
44   X_LAST_UPDATED_BY in NUMBER,
45   X_LAST_UPDATE_LOGIN in NUMBER
46 );
47 
48 procedure DELETE_ROW (
49   X_COMPONENT_REQUEST_ID in NUMBER
50 );
51 
52 procedure LOAD_ROW (
53   X_COMPONENT_NAME in VARCHAR2,
54   X_EVENT_NAME in VARCHAR2,
55   X_EVENT_DATE in DATE,
56   X_REQUESTED_BY_USER in VARCHAR2,
57   X_EVENT_PARAMS in VARCHAR2,
58   X_EVENT_FREQUENCY in NUMBER,
59   X_OBJECT_VERSION_NUMBER in NUMBER,
60   X_OWNER in VARCHAR2
61 );
62 
63 end FND_SVC_COMP_REQUESTS_PKG;