APPS.CSI_T_TXN_LINE_DETAILS_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 1: PACKAGE BODY CSI_T_TXN_LINE_DETAILS_PKG as

1: PACKAGE BODY CSI_T_TXN_LINE_DETAILS_PKG as
2: /* $Header: csitttdb.pls 120.1 2005/06/17 01:51:18 appldev $ */
3: -- Package name : CSI_T_TXN_LINE_DETAILS_PKG
4: -- Purpose : Table Handler for csi_t_txn_line_details
5: -- History : brmanesh created 12-MAY-2001

Line 3: -- Package name : CSI_T_TXN_LINE_DETAILS_PKG

1: PACKAGE BODY CSI_T_TXN_LINE_DETAILS_PKG as
2: /* $Header: csitttdb.pls 120.1 2005/06/17 01:51:18 appldev $ */
3: -- Package name : CSI_T_TXN_LINE_DETAILS_PKG
4: -- Purpose : Table Handler for csi_t_txn_line_details
5: -- History : brmanesh created 12-MAY-2001
6: -- : epajaril 15-AUG-2003 added the instance_status_id
7: -- : rmamidip 19-NOV-2003 added install_location_tyype_code and install_location_id

Line 4: -- Purpose : Table Handler for csi_t_txn_line_details

1: PACKAGE BODY CSI_T_TXN_LINE_DETAILS_PKG as
2: /* $Header: csitttdb.pls 120.1 2005/06/17 01:51:18 appldev $ */
3: -- Package name : CSI_T_TXN_LINE_DETAILS_PKG
4: -- Purpose : Table Handler for csi_t_txn_line_details
5: -- History : brmanesh created 12-MAY-2001
6: -- : epajaril 15-AUG-2003 added the instance_status_id
7: -- : rmamidip 19-NOV-2003 added install_location_tyype_code and install_location_id
8: -- : epajaril 17-MAR-2004 added the parent_instance_id

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_TXN_LINE_DETAILS_PKG';

8: -- : epajaril 17-MAR-2004 added the parent_instance_id
9: -- NOTE :
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_TXN_LINE_DETAILS_PKG';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitttdb.pls';
14:
15: -- Added for CZ Integration (Begin)
16: -- Following attributes are added to various modules.

Line 107: CURSOR C2 IS SELECT CSI_T_TXN_LINE_DETAILS_S.nextval FROM sys.dual;

103: p_assc_txn_line_detail_id NUMBER,
104: p_OVERRIDING_CSI_TXN_ID NUMBER)
105:
106: IS
107: CURSOR C2 IS SELECT CSI_T_TXN_LINE_DETAILS_S.nextval FROM sys.dual;
108: BEGIN
109: If (px_TXN_LINE_DETAIL_ID IS NULL) OR (px_TXN_LINE_DETAIL_ID = FND_API.G_MISS_NUM) then
110: OPEN C2;
111: FETCH C2 INTO px_TXN_LINE_DETAIL_ID;

Line 114: INSERT INTO CSI_T_TXN_LINE_DETAILS(

110: OPEN C2;
111: FETCH C2 INTO px_TXN_LINE_DETAIL_ID;
112: CLOSE C2;
113: End If;
114: INSERT INTO CSI_T_TXN_LINE_DETAILS(
115: TXN_LINE_DETAIL_ID,
116: TRANSACTION_LINE_ID,
117: SUB_TYPE_ID,
118: INSTANCE_EXISTS_FLAG,

Line 347: Update CSI_T_TXN_LINE_DETAILS

343: p_OVERRIDING_CSI_TXN_ID NUMBER)
344:
345: IS
346: BEGIN
347: Update CSI_T_TXN_LINE_DETAILS
348: SET
349: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
350: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),

Line 434: DELETE FROM CSI_T_TXN_LINE_DETAILS

430: PROCEDURE Delete_Row(
431: p_TXN_LINE_DETAIL_ID NUMBER)
432: IS
433: BEGIN
434: DELETE FROM CSI_T_TXN_LINE_DETAILS
435: WHERE TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID;
436: If (SQL%NOTFOUND) then
437: RAISE NO_DATA_FOUND;
438: End If;

Line 521: FROM CSI_T_TXN_LINE_DETAILS

517:
518: IS
519: CURSOR C IS
520: SELECT *
521: FROM CSI_T_TXN_LINE_DETAILS
522: WHERE TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID
523: FOR UPDATE of TXN_LINE_DETAIL_ID NOWAIT;
524: Recinfo C%ROWTYPE;
525: BEGIN

Line 766: End CSI_T_TXN_LINE_DETAILS_PKG;

762: APP_EXCEPTION.RAISE_EXCEPTION;
763: End If;
764: END Lock_Row;
765:
766: End CSI_T_TXN_LINE_DETAILS_PKG;