APPS.CSI_I_PARTIES_H_PKG dependencies on CSI_I_PARTIES_H

Line 1: PACKAGE BODY CSI_I_PARTIES_H_PKG as

1: PACKAGE BODY CSI_I_PARTIES_H_PKG as
2: /* $Header: csitpthb.pls 115.13 2003/09/04 00:22:16 sguthiva ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_PARTIES_H_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitpthb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_PARTIES_H_PKG';

1: PACKAGE BODY CSI_I_PARTIES_H_PKG as
2: /* $Header: csitpthb.pls 115.13 2003/09/04 00:22:16 sguthiva ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_PARTIES_H_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitpthb.pls';
6:
7: PROCEDURE Insert_Row(
8: px_INSTANCE_PARTY_HISTORY_ID IN OUT NOCOPY NUMBER,

Line 69: CURSOR C2 IS SELECT CSI_I_PARTIES_H_S.nextval FROM sys.dual;

65: p_NEW_PRIMARY_FLAG VARCHAR2,
66: p_OLD_PREFERRED_FLAG VARCHAR2,
67: p_NEW_PREFERRED_FLAG VARCHAR2)
68: IS
69: CURSOR C2 IS SELECT CSI_I_PARTIES_H_S.nextval FROM sys.dual;
70: BEGIN
71: If (px_INSTANCE_PARTY_HISTORY_ID IS NULL) OR (px_INSTANCE_PARTY_HISTORY_ID = FND_API.G_MISS_NUM) then
72: OPEN C2;
73: FETCH C2 INTO px_INSTANCE_PARTY_HISTORY_ID;

Line 76: INSERT INTO CSI_I_PARTIES_H(

72: OPEN C2;
73: FETCH C2 INTO px_INSTANCE_PARTY_HISTORY_ID;
74: CLOSE C2;
75: End If;
76: INSERT INTO CSI_I_PARTIES_H(
77: INSTANCE_PARTY_HISTORY_ID,
78: INSTANCE_PARTY_ID,
79: TRANSACTION_ID,
80: OLD_PARTY_SOURCE_TABLE,

Line 264: Update CSI_I_PARTIES_H

260: p_NEW_PREFERRED_FLAG VARCHAR2)
261:
262: IS
263: BEGIN
264: Update CSI_I_PARTIES_H
265: SET
266: INSTANCE_PARTY_ID = decode( p_INSTANCE_PARTY_ID, FND_API.G_MISS_NUM, INSTANCE_PARTY_ID, p_INSTANCE_PARTY_ID),
267: TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
268: OLD_PARTY_SOURCE_TABLE = decode( p_OLD_PARTY_SOURCE_TABLE, FND_API.G_MISS_CHAR, OLD_PARTY_SOURCE_TABLE, p_OLD_PARTY_SOURCE_TABLE),

Line 336: DELETE FROM CSI_I_PARTIES_H

332: PROCEDURE Delete_Row(
333: p_INSTANCE_PARTY_HISTORY_ID NUMBER)
334: IS
335: BEGIN
336: DELETE FROM CSI_I_PARTIES_H
337: WHERE INSTANCE_PARTY_HISTORY_ID = p_INSTANCE_PARTY_HISTORY_ID;
338: If (SQL%NOTFOUND) then
339: RAISE NO_DATA_FOUND;
340: End If;

Line 408: FROM CSI_I_PARTIES_H

404:
405: IS
406: CURSOR C IS
407: SELECT *
408: FROM CSI_I_PARTIES_H
409: WHERE INSTANCE_PARTY_HISTORY_ID = p_INSTANCE_PARTY_HISTORY_ID
410: FOR UPDATE of INSTANCE_PARTY_HISTORY_ID NOWAIT;
411: Recinfo C%ROWTYPE;
412: BEGIN

Line 608: End CSI_I_PARTIES_H_PKG;

604: APP_EXCEPTION.RAISE_EXCEPTION;
605: End If;
606: END Lock_Row;
607:
608: End CSI_I_PARTIES_H_PKG;