eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
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;