[Home] [Help]
PACKAGE: APPS.CN_PAY_APPROVAL_FLOW_PKG
Source
1 PACKAGE CN_PAY_APPROVAL_FLOW_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntpflws.pls 120.0 2005/06/06 17:51:12 appldev noship $*/
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
6 -- * ------------------------------------------------------------------+
7
8 TYPE PAY_APPROVAL_FLOW_REC_TYPE IS RECORD
9 (
10 PAY_APPROVAL_FLOW_ID NUMBER ,
11 PAYRUN_ID NUMBER ,
12 PAYMENT_WORKSHEET_ID NUMBER ,
13 SUBMIT_BY_RESOURCE_ID NUMBER ,
14 SUBMIT_BY_USER_ID NUMBER ,
15 SUBMIT_BY_EMAIL VARCHAR2(2000) ,
16 SUBMIT_TO_RESOURCE_ID NUMBER ,
17 SUBMIT_TO_USER_ID NUMBER ,
18 SUBMIT_TO_EMAIL VARCHAR2(2000) ,
19 APPROVAL_STATUS VARCHAR2(30) ,
20 UPDATED_BY_RESOURCE_ID NUMBER ,
21 ORG_ID NUMBER ,
22 SECURITY_GROUP_ID NUMBER ,
23 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
24 ATTRIBUTE1 VARCHAR2(150) ,
25 ATTRIBUTE2 VARCHAR2(150) ,
26 ATTRIBUTE3 VARCHAR2(150) ,
27 ATTRIBUTE4 VARCHAR2(150) ,
28 ATTRIBUTE5 VARCHAR2(150) ,
29 ATTRIBUTE6 VARCHAR2(150) ,
30 ATTRIBUTE7 VARCHAR2(150) ,
31 ATTRIBUTE8 VARCHAR2(150) ,
32 ATTRIBUTE9 VARCHAR2(150) ,
33 ATTRIBUTE10 VARCHAR2(150) ,
34 ATTRIBUTE11 VARCHAR2(150) ,
35 ATTRIBUTE12 VARCHAR2(150) ,
36 ATTRIBUTE13 VARCHAR2(150) ,
37 ATTRIBUTE14 VARCHAR2(150) ,
38 ATTRIBUTE15 VARCHAR2(150) ,
39 CREATION_DATE DATE ,
40 CREATED_BY NUMBER ,
41 LAST_UPDATE_DATE DATE ,
42 LAST_UPDATED_BY NUMBER ,
43 LAST_UPDATE_LOGIN NUMBER ,
44 OBJECT_VERSION_NUMBER NUMBER
45 );
46
47 G_NULL_PAY_APPROVAL_FLOW_REC PAY_APPROVAL_FLOW_REC_TYPE;
48
49 -- * -------------------------------------------------------------------------*
50 -- Procedure Name
51 -- Insert_row
52 -- Purpose
53 -- Main insert procedure
54 -- Note
55 -- 1. Primary key should be populated from sequence before call
56 -- this procedure. No refernece to sequence in this procedure.
57 -- 2. All paramaters are IN parameter.
58 -- * -------------------------------------------------------------------------*
59 PROCEDURE insert_row
60 ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE);
61
62 -- * -------------------------------------------------------------------------*
63 -- Procedure Name
64 -- update_row
65 -- Purpose
66 -- Main update procedure
67 -- Note
68 -- 1. No object version checking, overwrite may happen
69 -- 2. Calling lock_update for object version checking
70 -- 3. All paramaters are IN parameter.
71 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
72 -- * -------------------------------------------------------------------------*
73 PROCEDURE update_row
74 ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE);
75
76 -- * -------------------------------------------------------------------------*
77 -- Procedure Name
78 -- lock_update_row
79 -- Purpose
80 -- Main lcok and update procedure
81 -- Note
82 -- 1. Object version checking is performed before checking
83 -- 2. Calling update_row if you don not want object version checking
84 -- 3. All paramaters are IN parameter.
85 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
86 -- * -------------------------------------------------------------------------*
87 PROCEDURE lock_update_row
88 ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE);
89
90 -- * -------------------------------------------------------------------------*
91 -- Procedure Name
92 -- delete_row
93 -- Purpose
94 -- Main lcok and update procedure
95 -- Note
96 -- 1. All paramaters are IN parameter.
97 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
98 -- * -------------------------------------------------------------------------*
99 PROCEDURE delete_row
100 (
101 p_pay_approval_flow_id NUMBER
102 );
103
104 END CN_PAY_APPROVAL_FLOW_PKG;