APPS.CSI_T_ORG_ASSIGNMENTS_PKG dependencies on CSI_T_ORG_ASSIGNMENTS

Line 1: PACKAGE BODY CSI_T_ORG_ASSIGNMENTS_PKG as

1: PACKAGE BODY CSI_T_ORG_ASSIGNMENTS_PKG as
2: /* $Header: csittoub.pls 115.2 2002/11/12 00:24:26 rmamidip noship $ */
3: -- Package name : CSI_T_ORG_ASSIGNMENTS_PKG
4: -- Purpose : Table Handler for csi_t_org_assignments
5: -- History : brmanesh created 12-MAY-2001

Line 3: -- Package name : CSI_T_ORG_ASSIGNMENTS_PKG

1: PACKAGE BODY CSI_T_ORG_ASSIGNMENTS_PKG as
2: /* $Header: csittoub.pls 115.2 2002/11/12 00:24:26 rmamidip noship $ */
3: -- Package name : CSI_T_ORG_ASSIGNMENTS_PKG
4: -- Purpose : Table Handler for csi_t_org_assignments
5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:

Line 4: -- Purpose : Table Handler for csi_t_org_assignments

1: PACKAGE BODY CSI_T_ORG_ASSIGNMENTS_PKG as
2: /* $Header: csittoub.pls 115.2 2002/11/12 00:24:26 rmamidip noship $ */
3: -- Package name : CSI_T_ORG_ASSIGNMENTS_PKG
4: -- Purpose : Table Handler for csi_t_org_assignments
5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_ORG_ASSIGNMENTS_PKG';

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

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

Line 44: CURSOR C2 IS SELECT CSI_T_ORG_ASSIGNMENTS_S.nextval FROM sys.dual;

40: p_OBJECT_VERSION_NUMBER NUMBER,
41: p_CONTEXT VARCHAR2)
42:
43: IS
44: CURSOR C2 IS SELECT CSI_T_ORG_ASSIGNMENTS_S.nextval FROM sys.dual;
45: BEGIN
46: If (px_TXN_OPERATING_UNIT_ID IS NULL) OR (px_TXN_OPERATING_UNIT_ID = FND_API.G_MISS_NUM) then
47: OPEN C2;
48: FETCH C2 INTO px_TXN_OPERATING_UNIT_ID;

Line 51: INSERT INTO CSI_T_ORG_ASSIGNMENTS(

47: OPEN C2;
48: FETCH C2 INTO px_TXN_OPERATING_UNIT_ID;
49: CLOSE C2;
50: End If;
51: INSERT INTO CSI_T_ORG_ASSIGNMENTS(
52: TXN_OPERATING_UNIT_ID,
53: TXN_LINE_DETAIL_ID,
54: OPERATING_UNIT_ID,
55: RELATIONSHIP_TYPE_CODE,

Line 149: Update CSI_T_ORG_ASSIGNMENTS

145: p_CONTEXT VARCHAR2)
146:
147: IS
148: BEGIN
149: Update CSI_T_ORG_ASSIGNMENTS
150: SET
151: TXN_LINE_DETAIL_ID = decode( p_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, TXN_LINE_DETAIL_ID, p_TXN_LINE_DETAIL_ID),
152: OPERATING_UNIT_ID = decode( p_OPERATING_UNIT_ID, FND_API.G_MISS_NUM, OPERATING_UNIT_ID, p_OPERATING_UNIT_ID),
153: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),

Line 191: DELETE FROM CSI_T_ORG_ASSIGNMENTS

187: PROCEDURE Delete_Row(
188: p_TXN_OPERATING_UNIT_ID NUMBER)
189: IS
190: BEGIN
191: DELETE FROM CSI_T_ORG_ASSIGNMENTS
192: WHERE TXN_OPERATING_UNIT_ID = p_TXN_OPERATING_UNIT_ID;
193: If (SQL%NOTFOUND) then
194: RAISE NO_DATA_FOUND;
195: End If;

Line 233: FROM CSI_T_ORG_ASSIGNMENTS

229:
230: IS
231: CURSOR C IS
232: SELECT *
233: FROM CSI_T_ORG_ASSIGNMENTS
234: WHERE TXN_OPERATING_UNIT_ID = p_TXN_OPERATING_UNIT_ID
235: FOR UPDATE of TXN_OPERATING_UNIT_ID NOWAIT;
236: Recinfo C%ROWTYPE;
237: BEGIN

Line 343: End CSI_T_ORG_ASSIGNMENTS_PKG;

339: APP_EXCEPTION.RAISE_EXCEPTION;
340: End If;
341: END Lock_Row;
342:
343: End CSI_T_ORG_ASSIGNMENTS_PKG;