APPS.CSI_I_ORG_ASSIGNMENTS_H_PKG dependencies on CSI_I_ORG_ASSIGNMENTS_H

Line 1: PACKAGE BODY CSI_I_ORG_ASSIGNMENTS_H_PKG as

1: PACKAGE BODY CSI_I_ORG_ASSIGNMENTS_H_PKG as
2: /* $Header: csitorgb.pls 115.17 2003/09/04 00:21:31 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_ORG_ASSIGNMENTS_H_PKG';

Line 5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_ORG_ASSIGNMENTS_H_PKG';

1: PACKAGE BODY CSI_I_ORG_ASSIGNMENTS_H_PKG as
2: /* $Header: csitorgb.pls 115.17 2003/09/04 00:21:31 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_ORG_ASSIGNMENTS_H_PKG';
6:
7: PROCEDURE Insert_Row(
8: px_INSTANCE_OU_HISTORY_ID IN OUT NOCOPY NUMBER,
9: p_INSTANCE_OU_ID NUMBER,

Line 59: CURSOR C2 IS SELECT CSI_I_ORG_ASSIGNMENTS_H_S.nextval FROM sys.dual;

55: p_LAST_UPDATE_DATE DATE,
56: p_LAST_UPDATE_LOGIN NUMBER,
57: p_OBJECT_VERSION_NUMBER NUMBER)
58: IS
59: CURSOR C2 IS SELECT CSI_I_ORG_ASSIGNMENTS_H_S.nextval FROM sys.dual;
60: BEGIN
61: If (px_INSTANCE_OU_HISTORY_ID IS NULL) OR (px_INSTANCE_OU_HISTORY_ID = FND_API.G_MISS_NUM) then
62: OPEN C2;
63: FETCH C2 INTO px_INSTANCE_OU_HISTORY_ID;

Line 66: INSERT INTO CSI_I_ORG_ASSIGNMENTS_H(

62: OPEN C2;
63: FETCH C2 INTO px_INSTANCE_OU_HISTORY_ID;
64: CLOSE C2;
65: End If;
66: INSERT INTO CSI_I_ORG_ASSIGNMENTS_H(
67: INSTANCE_OU_HISTORY_ID,
68: INSTANCE_OU_ID,
69: TRANSACTION_ID,
70: OLD_OPERATING_UNIT_ID,

Line 224: Update CSI_I_ORG_ASSIGNMENTS_H

220: p_OBJECT_VERSION_NUMBER NUMBER)
221:
222: IS
223: BEGIN
224: Update CSI_I_ORG_ASSIGNMENTS_H
225: SET
226: INSTANCE_OU_ID = decode( p_INSTANCE_OU_ID, FND_API.G_MISS_NUM, INSTANCE_OU_ID, p_INSTANCE_OU_ID),
227: TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
228: OLD_OPERATING_UNIT_ID = decode( p_OLD_OPERATING_UNIT_ID, FND_API.G_MISS_NUM, OLD_OPERATING_UNIT_ID, p_OLD_OPERATING_UNIT_ID),

Line 287: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H

283: PROCEDURE Delete_Row(
284: p_INSTANCE_OU_HISTORY_ID NUMBER)
285: IS
286: BEGIN
287: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H
288: WHERE INSTANCE_OU_HISTORY_ID = p_INSTANCE_OU_HISTORY_ID;
289: If (SQL%NOTFOUND) then
290: RAISE NO_DATA_FOUND;
291: End If;

Line 349: FROM CSI_I_ORG_ASSIGNMENTS_H

345:
346: IS
347: CURSOR C IS
348: SELECT *
349: FROM CSI_I_ORG_ASSIGNMENTS_H
350: WHERE INSTANCE_OU_HISTORY_ID = p_INSTANCE_OU_HISTORY_ID
351: FOR UPDATE of INSTANCE_OU_HISTORY_ID NOWAIT;
352: Recinfo C%ROWTYPE;
353: BEGIN

Line 537: End CSI_I_ORG_ASSIGNMENTS_H_PKG;

533: APP_EXCEPTION.RAISE_EXCEPTION;
534: End If;
535: END Lock_Row;
536:
537: End CSI_I_ORG_ASSIGNMENTS_H_PKG;