[Home] [Help]
PACKAGE: APPS.CSI_T_TRANSACTION_LINES_PKG
Source
1 PACKAGE CSI_T_TRANSACTION_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: csitttls.pls 115.7 2002/11/12 00:27:33 rmamidip noship $ */
3 -- Package name : CSI_T_TRANSACTION_LINES_PKG
4 -- Purpose : Table handler for CSI_T_TRANSACTION_LINES
5 -- History : bmanesh created 12-MAY-2001
6 -- NOTE :
7
8
9 ---Added (Start) for m-to-m enhancements
10 -- p_SOURCE_TXN_HEADER_ID added to various modules
11 ---Added (End) for m-to-m enhancements
12
13 -- Added for CZ Integration (Begin)
14 -- Following attributes are added to various modules
15 --P_CONFIG_SESSION_HDR_ID NUMBER
16 --P_CONFIG_SESSION_REV_NUM NUMBER
17 --P_CONFIG_SESSION_ITEM_ID NUMBER
18 --P_CONFIG_VALID_STATUS VARCHAR2
19 --P_SOURCE_TRANSACTION_STATUS VARCHAR2
20 -- Added for CZ Integration (End)
21
22 PROCEDURE Insert_Row(
23 px_TRANSACTION_LINE_ID IN OUT NOCOPY NUMBER,
24 p_SOURCE_TRANSACTION_TYPE_ID NUMBER,
25 p_SOURCE_TRANSACTION_TABLE VARCHAR2,
26 p_SOURCE_TXN_HEADER_ID NUMBER,
27 p_SOURCE_TRANSACTION_ID NUMBER,
28 P_CONFIG_SESSION_HDR_ID NUMBER ,
29 P_CONFIG_SESSION_REV_NUM NUMBER ,
30 P_CONFIG_SESSION_ITEM_ID NUMBER ,
31 P_CONFIG_VALID_STATUS VARCHAR2 ,
32 P_SOURCE_TRANSACTION_STATUS VARCHAR2 ,
33 p_ERROR_CODE VARCHAR2,
34 p_ERROR_EXPLANATION VARCHAR2,
35 p_PROCESSING_STATUS VARCHAR2,
36 p_ATTRIBUTE1 VARCHAR2,
37 p_ATTRIBUTE2 VARCHAR2,
38 p_ATTRIBUTE3 VARCHAR2,
39 p_ATTRIBUTE4 VARCHAR2,
40 p_ATTRIBUTE5 VARCHAR2,
41 p_ATTRIBUTE6 VARCHAR2,
42 p_ATTRIBUTE7 VARCHAR2,
43 p_ATTRIBUTE8 VARCHAR2,
44 p_ATTRIBUTE9 VARCHAR2,
45 p_ATTRIBUTE10 VARCHAR2,
46 p_ATTRIBUTE11 VARCHAR2,
47 p_ATTRIBUTE12 VARCHAR2,
48 p_ATTRIBUTE13 VARCHAR2,
49 p_ATTRIBUTE14 VARCHAR2,
50 p_ATTRIBUTE15 VARCHAR2,
51 p_CREATED_BY NUMBER,
52 p_CREATION_DATE DATE,
53 p_LAST_UPDATED_BY NUMBER,
54 p_LAST_UPDATE_DATE DATE,
55 p_LAST_UPDATE_LOGIN NUMBER,
56 p_OBJECT_VERSION_NUMBER NUMBER,
57 p_CONTEXT VARCHAR2);
58
59 PROCEDURE Update_Row(
60 p_TRANSACTION_LINE_ID NUMBER,
61 p_SOURCE_TRANSACTION_TYPE_ID NUMBER,
62 p_SOURCE_TRANSACTION_TABLE VARCHAR2,
63 p_SOURCE_TXN_HEADER_ID NUMBER,
64 p_SOURCE_TRANSACTION_ID NUMBER,
65 P_CONFIG_SESSION_HDR_ID NUMBER ,
66 P_CONFIG_SESSION_REV_NUM NUMBER ,
67 P_CONFIG_SESSION_ITEM_ID NUMBER ,
68 P_CONFIG_VALID_STATUS VARCHAR2 ,
69 P_SOURCE_TRANSACTION_STATUS VARCHAR2 ,
70 p_ERROR_CODE VARCHAR2,
71 p_ERROR_EXPLANATION VARCHAR2,
72 p_PROCESSING_STATUS VARCHAR2,
73 p_ATTRIBUTE1 VARCHAR2,
74 p_ATTRIBUTE2 VARCHAR2,
75 p_ATTRIBUTE3 VARCHAR2,
76 p_ATTRIBUTE4 VARCHAR2,
77 p_ATTRIBUTE5 VARCHAR2,
78 p_ATTRIBUTE6 VARCHAR2,
79 p_ATTRIBUTE7 VARCHAR2,
80 p_ATTRIBUTE8 VARCHAR2,
81 p_ATTRIBUTE9 VARCHAR2,
82 p_ATTRIBUTE10 VARCHAR2,
83 p_ATTRIBUTE11 VARCHAR2,
84 p_ATTRIBUTE12 VARCHAR2,
85 p_ATTRIBUTE13 VARCHAR2,
86 p_ATTRIBUTE14 VARCHAR2,
87 p_ATTRIBUTE15 VARCHAR2,
88 p_CREATED_BY NUMBER,
89 p_CREATION_DATE DATE,
90 p_LAST_UPDATED_BY NUMBER,
91 p_LAST_UPDATE_DATE DATE,
92 p_LAST_UPDATE_LOGIN NUMBER,
93 p_OBJECT_VERSION_NUMBER NUMBER,
94 p_CONTEXT VARCHAR2);
95
96 PROCEDURE Lock_Row(
97 p_TRANSACTION_LINE_ID NUMBER,
98 p_SOURCE_TRANSACTION_TYPE_ID NUMBER,
99 p_SOURCE_TRANSACTION_TABLE VARCHAR2,
100 p_SOURCE_TXN_HEADER_ID NUMBER,
101 p_SOURCE_TRANSACTION_ID NUMBER,
102 P_CONFIG_SESSION_HDR_ID NUMBER ,
103 P_CONFIG_SESSION_REV_NUM NUMBER ,
104 P_CONFIG_SESSION_ITEM_ID NUMBER ,
105 P_CONFIG_VALID_STATUS VARCHAR2 ,
106 P_SOURCE_TRANSACTION_STATUS VARCHAR2 ,
107 p_ERROR_CODE VARCHAR2,
108 p_ERROR_EXPLANATION VARCHAR2,
109 p_PROCESSING_STATUS VARCHAR2,
110 p_ATTRIBUTE1 VARCHAR2,
111 p_ATTRIBUTE2 VARCHAR2,
112 p_ATTRIBUTE3 VARCHAR2,
113 p_ATTRIBUTE4 VARCHAR2,
114 p_ATTRIBUTE5 VARCHAR2,
115 p_ATTRIBUTE6 VARCHAR2,
116 p_ATTRIBUTE7 VARCHAR2,
117 p_ATTRIBUTE8 VARCHAR2,
118 p_ATTRIBUTE9 VARCHAR2,
119 p_ATTRIBUTE10 VARCHAR2,
120 p_ATTRIBUTE11 VARCHAR2,
121 p_ATTRIBUTE12 VARCHAR2,
122 p_ATTRIBUTE13 VARCHAR2,
123 p_ATTRIBUTE14 VARCHAR2,
124 p_ATTRIBUTE15 VARCHAR2,
125 p_CREATED_BY NUMBER,
126 p_CREATION_DATE DATE,
127 p_LAST_UPDATED_BY NUMBER,
128 p_LAST_UPDATE_DATE DATE,
129 p_LAST_UPDATE_LOGIN NUMBER,
130 p_OBJECT_VERSION_NUMBER NUMBER,
131 p_CONTEXT VARCHAR2);
132
133 PROCEDURE Delete_Row(
134 p_TRANSACTION_LINE_ID NUMBER);
135 End CSI_T_TRANSACTION_LINES_PKG;