PACKAGE: APPS.IGI_EXP_POSITION_ACTION_PKG

Source

1 PACKAGE IGI_EXP_POSITION_ACTION_PKG AUTHID CURRENT_USER AS
2 --$Header: igiexpos.pls 115.4 2002/11/19 05:27:48 sowsubra ship $
3 /* THIS PACKAGE IS FOR THE TABLE IGI_EXP_POSITION_ACTION */
4   PROCEDURE INSERT_ROW(
5         X_ROWID IN OUT NOCOPY VARCHAR2,
6         X_WKF_ID        NUMBER,
7         X_FLOW_ID       NUMBER,
8         X_STEP_NO       NUMBER,
9         X_POSITION_ID   NUMBER,
10         X_POSITION_STRUCTURE_ID NUMBER,
11         X_CREATE_DOC    VARCHAR2,
12         X_APPROVE       VARCHAR2,
13         X_REJECT        VARCHAR2,
14         X_HOLD          VARCHAR2,
15         X_PEC           VARCHAR2,
16         X_REQUISITION   VARCHAR2,
17         X_CREATION_DATE DATE,
18         X_CREATED_BY    NUMBER,
19         X_LAST_UPDATE_LOGIN NUMBER,
20         X_LAST_UPDATE_DATE DATE,
21         X_LAST_UPDATED_BY NUMBER );
22 
23   PROCEDURE LOCK_ROW(
24         X_ROWID IN OUT NOCOPY VARCHAR2,
25         X_WKF_ID        NUMBER,
26         X_FLOW_ID       NUMBER,
27         X_STEP_NO       NUMBER,
28         X_POSITION_ID   NUMBER,
29         X_POSITION_STRUCTURE_ID NUMBER,
30         X_CREATE_DOC    VARCHAR2,
31         X_APPROVE       VARCHAR2,
32         X_REJECT        VARCHAR2,
33         X_HOLD          VARCHAR2,
34         X_PEC           VARCHAR2,
35         X_REQUISITION   VARCHAR2,
36         X_CREATION_DATE DATE,
37         X_CREATED_BY    NUMBER,
38         X_LAST_UPDATE_LOGIN NUMBER,
39         X_LAST_UPDATE_DATE DATE,
40         X_LAST_UPDATED_BY NUMBER );
41 
42   PROCEDURE UPDATE_ROW(
43         X_ROWID IN OUT NOCOPY VARCHAR2,
44         X_WKF_ID        NUMBER,
45         X_FLOW_ID       NUMBER,
46         X_STEP_NO       NUMBER,
47         X_POSITION_ID   NUMBER,
48         X_POSITION_STRUCTURE_ID NUMBER,
49         X_CREATE_DOC    VARCHAR2,
50         X_APPROVE       VARCHAR2,
51         X_REJECT        VARCHAR2,
52         X_HOLD          VARCHAR2,
53         X_PEC           VARCHAR2,
54         X_REQUISITION   VARCHAR2,
55         X_CREATION_DATE DATE,
56         X_CREATED_BY    NUMBER,
57         X_LAST_UPDATE_LOGIN NUMBER,
58         X_LAST_UPDATE_DATE DATE,
59         X_LAST_UPDATED_BY NUMBER );
60 
61   PROCEDURE DELETE_ROW(X_ROWID VARCHAR2);
62 END IGI_EXP_POSITION_ACTION_PKG;