APPS.CSI_T_TRANSACTION_LINES_PKG dependencies on CSI_T_TRANSACTION_LINES

Line 1: PACKAGE BODY CSI_T_TRANSACTION_LINES_PKG as

1: PACKAGE BODY CSI_T_TRANSACTION_LINES_PKG as
2: /* $Header: csitttlb.pls 115.7 2002/11/12 00:27:20 rmamidip noship $ */
3: -- Package name : CSI_T_TRANSACTION_LINES_PKG
4: -- Purpose : Table Handler for csi_t_transaction_lines
5: -- History : brmanesh created 12-MAY-2001

Line 3: -- Package name : CSI_T_TRANSACTION_LINES_PKG

1: PACKAGE BODY CSI_T_TRANSACTION_LINES_PKG as
2: /* $Header: csitttlb.pls 115.7 2002/11/12 00:27:20 rmamidip noship $ */
3: -- Package name : CSI_T_TRANSACTION_LINES_PKG
4: -- Purpose : Table Handler for csi_t_transaction_lines
5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:

Line 4: -- Purpose : Table Handler for csi_t_transaction_lines

1: PACKAGE BODY CSI_T_TRANSACTION_LINES_PKG as
2: /* $Header: csitttlb.pls 115.7 2002/11/12 00:27:20 rmamidip noship $ */
3: -- Package name : CSI_T_TRANSACTION_LINES_PKG
4: -- Purpose : Table Handler for csi_t_transaction_lines
5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_T_TRANSACTION_LINES_PKG';

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_T_TRANSACTION_LINES_PKG';

4: -- Purpose : Table Handler for csi_t_transaction_lines
5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_T_TRANSACTION_LINES_PKG';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitttlb.pls';
10:
11: PROCEDURE Insert_Row(
12: px_TRANSACTION_LINE_ID IN OUT NOCOPY NUMBER,

Line 49: CURSOR C2 IS SELECT CSI_T_TRANSACTION_LINES_S.nextval FROM sys.dual;

45: p_OBJECT_VERSION_NUMBER NUMBER,
46: p_CONTEXT VARCHAR2)
47:
48: IS
49: CURSOR C2 IS SELECT CSI_T_TRANSACTION_LINES_S.nextval FROM sys.dual;
50: BEGIN
51: If (px_TRANSACTION_LINE_ID IS NULL) OR (px_TRANSACTION_LINE_ID = FND_API.G_MISS_NUM) then
52: OPEN C2;
53: FETCH C2 INTO px_TRANSACTION_LINE_ID;

Line 56: INSERT INTO CSI_T_TRANSACTION_LINES(

52: OPEN C2;
53: FETCH C2 INTO px_TRANSACTION_LINE_ID;
54: CLOSE C2;
55: End If;
56: INSERT INTO CSI_T_TRANSACTION_LINES(
57: TRANSACTION_LINE_ID,
58: SOURCE_TRANSACTION_TYPE_ID,
59: SOURCE_TRANSACTION_TABLE,
60: SOURCE_TXN_HEADER_ID,

Line 169: Update CSI_T_TRANSACTION_LINES

165: p_CONTEXT VARCHAR2)
166:
167: IS
168: BEGIN
169: Update CSI_T_TRANSACTION_LINES
170: SET
171: SOURCE_TRANSACTION_TYPE_ID = decode( p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, SOURCE_TRANSACTION_ID, p_SOURCE_TRANSACTION_TYPE_ID),
172: SOURCE_TRANSACTION_TABLE = decode( p_SOURCE_TRANSACTION_TABLE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TABLE, p_SOURCE_TRANSACTION_TABLE),
173: SOURCE_TXN_HEADER_ID = decode( p_SOURCE_TXN_HEADER_ID,

Line 217: DELETE FROM CSI_T_TRANSACTION_LINES

213: PROCEDURE Delete_Row(
214: p_TRANSACTION_LINE_ID NUMBER)
215: IS
216: BEGIN
217: DELETE FROM CSI_T_TRANSACTION_LINES
218: WHERE TRANSACTION_LINE_ID = p_TRANSACTION_LINE_ID;
219: If (SQL%NOTFOUND) then
220: RAISE NO_DATA_FOUND;
221: End If;

Line 264: FROM CSI_T_TRANSACTION_LINES

260:
261: IS
262: CURSOR C IS
263: SELECT *
264: FROM CSI_T_TRANSACTION_LINES
265: WHERE TRANSACTION_LINE_ID = p_TRANSACTION_LINE_ID
266: FOR UPDATE of TRANSACTION_LINE_ID NOWAIT;
267: Recinfo C%ROWTYPE;
268: BEGIN

Line 389: End CSI_T_TRANSACTION_LINES_PKG;

385: APP_EXCEPTION.RAISE_EXCEPTION;
386: End If;
387: END Lock_Row;
388:
389: End CSI_T_TRANSACTION_LINES_PKG;