APPS.CSI_IP_ACCOUNTS_H_PKG dependencies on CSI_IP_ACCOUNTS_H

Line 1: PACKAGE BODY CSI_IP_ACCOUNTS_H_PKG as

1: PACKAGE BODY CSI_IP_ACCOUNTS_H_PKG as
2: /* $Header: csitahsb.pls 115.14 2003/09/04 00:17:20 sguthiva ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_IP_ACCOUNTS_H_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitahsb.pls';

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

1: PACKAGE BODY CSI_IP_ACCOUNTS_H_PKG as
2: /* $Header: csitahsb.pls 115.14 2003/09/04 00:17:20 sguthiva ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_IP_ACCOUNTS_H_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitahsb.pls';
6:
7: PROCEDURE Insert_Row(
8: px_IP_ACCOUNT_HISTORY_ID IN OUT NOCOPY NUMBER,

Line 66: CURSOR C2 IS SELECT CSI_IP_ACCOUNTS_H_S.nextval FROM sys.dual;

62: p_OLD_INSTANCE_PARTY_ID NUMBER,
63: p_NEW_INSTANCE_PARTY_ID NUMBER)
64:
65: IS
66: CURSOR C2 IS SELECT CSI_IP_ACCOUNTS_H_S.nextval FROM sys.dual;
67: BEGIN
68: If (px_IP_ACCOUNT_HISTORY_ID IS NULL) OR (px_IP_ACCOUNT_HISTORY_ID = FND_API.G_MISS_NUM) then
69: OPEN C2;
70: FETCH C2 INTO px_IP_ACCOUNT_HISTORY_ID;

Line 73: INSERT INTO CSI_IP_ACCOUNTS_H(

69: OPEN C2;
70: FETCH C2 INTO px_IP_ACCOUNT_HISTORY_ID;
71: CLOSE C2;
72: End If;
73: INSERT INTO CSI_IP_ACCOUNTS_H(
74: IP_ACCOUNT_HISTORY_ID,
75: IP_ACCOUNT_ID,
76: TRANSACTION_ID,
77: OLD_PARTY_ACCOUNT_ID,

Line 250: Update CSI_IP_ACCOUNTS_H

246: p_NEW_INSTANCE_PARTY_ID NUMBER)
247:
248: IS
249: BEGIN
250: Update CSI_IP_ACCOUNTS_H
251: SET
252: IP_ACCOUNT_ID = decode( p_IP_ACCOUNT_ID, FND_API.G_MISS_NUM, IP_ACCOUNT_ID, p_IP_ACCOUNT_ID),
253: TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
254: OLD_PARTY_ACCOUNT_ID = decode( p_OLD_PARTY_ACCOUNT_ID, FND_API.G_MISS_NUM, OLD_PARTY_ACCOUNT_ID, p_OLD_PARTY_ACCOUNT_ID),

Line 318: DELETE FROM CSI_IP_ACCOUNTS_H

314: PROCEDURE Delete_Row(
315: p_IP_ACCOUNT_HISTORY_ID NUMBER)
316: IS
317: BEGIN
318: DELETE FROM CSI_IP_ACCOUNTS_H
319: WHERE IP_ACCOUNT_HISTORY_ID = p_IP_ACCOUNT_HISTORY_ID;
320: If (SQL%NOTFOUND) then
321: RAISE NO_DATA_FOUND;
322: End If;

Line 387: FROM CSI_IP_ACCOUNTS_H

383:
384: IS
385: CURSOR C IS
386: SELECT *
387: FROM CSI_IP_ACCOUNTS_H
388: WHERE IP_ACCOUNT_HISTORY_ID = p_IP_ACCOUNT_HISTORY_ID
389: FOR UPDATE of IP_ACCOUNT_HISTORY_ID NOWAIT;
390: Recinfo C%ROWTYPE;
391: BEGIN

Line 577: End CSI_IP_ACCOUNTS_H_PKG;

573: APP_EXCEPTION.RAISE_EXCEPTION;
574: End If;
575: END Lock_Row;
576:
577: End CSI_IP_ACCOUNTS_H_PKG;
578: