APPS.CSI_I_ORG_ASSIGNMENTS_PKG dependencies on CSI_I_ORG_ASSIGNMENTS

Line 1: PACKAGE BODY CSI_I_ORG_ASSIGNMENTS_PKG as

1: PACKAGE BODY CSI_I_ORG_ASSIGNMENTS_PKG as
2: /* $Header: csitioab.pls 115.12 2003/09/04 00:19:57 sguthiva ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_ORG_ASSIGNMENTS_PKG';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_ORG_ASSIGNMENTS_PKG';

1: PACKAGE BODY CSI_I_ORG_ASSIGNMENTS_PKG as
2: /* $Header: csitioab.pls 115.12 2003/09/04 00:19:57 sguthiva ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_ORG_ASSIGNMENTS_PKG';
5:
6: PROCEDURE Insert_Row(
7: px_INSTANCE_OU_ID IN OUT NOCOPY NUMBER,
8: p_INSTANCE_ID NUMBER,

Line 37: CURSOR C2 IS SELECT CSI_I_ORG_ASSIGNMENTS_S.nextval FROM sys.dual;

33: p_LAST_UPDATE_LOGIN NUMBER,
34: p_OBJECT_VERSION_NUMBER NUMBER)
35:
36: IS
37: CURSOR C2 IS SELECT CSI_I_ORG_ASSIGNMENTS_S.nextval FROM sys.dual;
38: BEGIN
39: If (px_INSTANCE_OU_ID IS NULL) OR (px_INSTANCE_OU_ID = FND_API.G_MISS_NUM) then
40: OPEN C2;
41: FETCH C2 INTO px_INSTANCE_OU_ID;

Line 44: INSERT INTO CSI_I_ORG_ASSIGNMENTS(

40: OPEN C2;
41: FETCH C2 INTO px_INSTANCE_OU_ID;
42: CLOSE C2;
43: End If;
44: INSERT INTO CSI_I_ORG_ASSIGNMENTS(
45: INSTANCE_OU_ID,
46: INSTANCE_ID,
47: OPERATING_UNIT_ID,
48: RELATIONSHIP_TYPE_CODE,

Line 136: Update CSI_I_ORG_ASSIGNMENTS

132: p_OBJECT_VERSION_NUMBER NUMBER)
133:
134: IS
135: BEGIN
136: Update CSI_I_ORG_ASSIGNMENTS
137: SET
138: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
139: OPERATING_UNIT_ID = decode( p_OPERATING_UNIT_ID, FND_API.G_MISS_NUM, OPERATING_UNIT_ID, p_OPERATING_UNIT_ID),
140: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),

Line 176: DELETE FROM CSI_I_ORG_ASSIGNMENTS

172: PROCEDURE Delete_Row(
173: p_INSTANCE_OU_ID NUMBER)
174: IS
175: BEGIN
176: DELETE FROM CSI_I_ORG_ASSIGNMENTS
177: WHERE INSTANCE_OU_ID = p_INSTANCE_OU_ID;
178: If (SQL%NOTFOUND) then
179: RAISE NO_DATA_FOUND;
180: End If;

Line 216: FROM CSI_I_ORG_ASSIGNMENTS

212:
213: IS
214: CURSOR C IS
215: SELECT *
216: FROM CSI_I_ORG_ASSIGNMENTS
217: WHERE INSTANCE_OU_ID = p_INSTANCE_OU_ID
218: FOR UPDATE of INSTANCE_OU_ID NOWAIT;
219: Recinfo C%ROWTYPE;
220: BEGIN

Line 320: End CSI_I_ORG_ASSIGNMENTS_PKG;

316: APP_EXCEPTION.RAISE_EXCEPTION;
317: End If;
318: END Lock_Row;
319:
320: End CSI_I_ORG_ASSIGNMENTS_PKG;