APPS.CSI_T_II_RELATIONSHIPS_PKG dependencies on CSI_T_II_RELATIONSHIPS

Line 1: PACKAGE BODY CSI_T_II_RELATIONSHIPS_PKG as

1: PACKAGE BODY CSI_T_II_RELATIONSHIPS_PKG as
2: /* $Header: csittiib.pls 115.9 2003/09/02 20:06:47 epajaril ship $ */
3: -- Package name : CSI_T_II_RELATIONSHIPS_PKG
4: -- Purpose : Table Handler for csi_t_ii_relationships
5: -- History : brmanesh created 12-MAY-2001

Line 3: -- Package name : CSI_T_II_RELATIONSHIPS_PKG

1: PACKAGE BODY CSI_T_II_RELATIONSHIPS_PKG as
2: /* $Header: csittiib.pls 115.9 2003/09/02 20:06:47 epajaril ship $ */
3: -- Package name : CSI_T_II_RELATIONSHIPS_PKG
4: -- Purpose : Table Handler for csi_t_ii_relationships
5: -- History : brmanesh created 12-MAY-2001
6: -- : epajaril added the transfer_components 26-AUG-2003
7: -- NOTE :

Line 4: -- Purpose : Table Handler for csi_t_ii_relationships

1: PACKAGE BODY CSI_T_II_RELATIONSHIPS_PKG as
2: /* $Header: csittiib.pls 115.9 2003/09/02 20:06:47 epajaril ship $ */
3: -- Package name : CSI_T_II_RELATIONSHIPS_PKG
4: -- Purpose : Table Handler for csi_t_ii_relationships
5: -- History : brmanesh created 12-MAY-2001
6: -- : epajaril added the transfer_components 26-AUG-2003
7: -- NOTE :
8:

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_II_RELATIONSHIPS_PKG';

5: -- History : brmanesh created 12-MAY-2001
6: -- : epajaril added the transfer_components 26-AUG-2003
7: -- NOTE :
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_II_RELATIONSHIPS_PKG';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csittiib.pls';
11:
12: ---Added (Start) for m-to-m enhancements
13: --New columns p_OBJECT_TYPE , p_SUBJECT_TYPE added

Line 63: CURSOR C2 IS SELECT CSI_T_II_RELATIONSHIPS_S.nextval FROM sys.dual;

59: p_CONTEXT VARCHAR2,
60: p_TRANSFER_COMPONENTS_FLAG VARCHAR2)
61:
62: IS
63: CURSOR C2 IS SELECT CSI_T_II_RELATIONSHIPS_S.nextval FROM sys.dual;
64: BEGIN
65: If (px_TXN_RELATIONSHIP_ID IS NULL) OR (px_TXN_RELATIONSHIP_ID = FND_API.G_MISS_NUM) then
66: OPEN C2;
67: FETCH C2 INTO px_TXN_RELATIONSHIP_ID;

Line 70: INSERT INTO CSI_T_II_RELATIONSHIPS(

66: OPEN C2;
67: FETCH C2 INTO px_TXN_RELATIONSHIP_ID;
68: CLOSE C2;
69: End If;
70: INSERT INTO CSI_T_II_RELATIONSHIPS(
71: TXN_RELATIONSHIP_ID,
72: TRANSACTION_LINE_ID,
73: OBJECT_TYPE ,
74: OBJECT_ID,

Line 207: Update CSI_T_II_RELATIONSHIPS

203: p_TRANSFER_COMPONENTS_FLAG VARCHAR2)
204:
205: IS
206: BEGIN
207: Update CSI_T_II_RELATIONSHIPS
208: SET
209: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),

Line 262: DELETE FROM CSI_T_II_RELATIONSHIPS

258: PROCEDURE Delete_Row(
259: p_TXN_RELATIONSHIP_ID NUMBER)
260: IS
261: BEGIN
262: DELETE FROM CSI_T_II_RELATIONSHIPS
263: WHERE TXN_RELATIONSHIP_ID = p_TXN_RELATIONSHIP_ID;
264: If (SQL%NOTFOUND) then
265: RAISE NO_DATA_FOUND;
266: End If;

Line 317: FROM CSI_T_II_RELATIONSHIPS

313:
314: IS
315: CURSOR C IS
316: SELECT *
317: FROM CSI_T_II_RELATIONSHIPS
318: WHERE TXN_RELATIONSHIP_ID = p_TXN_RELATIONSHIP_ID
319: FOR UPDATE of TXN_RELATIONSHIP_ID NOWAIT;
320: Recinfo C%ROWTYPE;
321: BEGIN

Line 463: End CSI_T_II_RELATIONSHIPS_PKG;

459: APP_EXCEPTION.RAISE_EXCEPTION;
460: End If;
461: END Lock_Row;
462:
463: End CSI_T_II_RELATIONSHIPS_PKG;