APPS.IEX_REPOSSESSIONS_PKG dependencies on IEX_REPOSSESSIONS

Line 1: PACKAGE BODY IEX_REPOSSESSIONS_PKG as

1: PACKAGE BODY IEX_REPOSSESSIONS_PKG as
2: /* $Header: iextrpsb.pls 120.1 2007/10/30 20:27:09 ehuh ship $ */
3: -- Start of Comments
4: -- Package name : IEX_REPOSSESSIONS_PKG
5: -- Purpose :

Line 4: -- Package name : IEX_REPOSSESSIONS_PKG

1: PACKAGE BODY IEX_REPOSSESSIONS_PKG as
2: /* $Header: iextrpsb.pls 120.1 2007/10/30 20:27:09 ehuh ship $ */
3: -- Start of Comments
4: -- Package name : IEX_REPOSSESSIONS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_REPOSSESSIONS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_REPOSSESSIONS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextrpsb.pls';
13:
14: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15:

Line 65: CURSOR C2 IS SELECT IEX_REPOSSESSIONS_S.nextval FROM sys.dual;

61: ,p_CONTRACT_NUMBER VARCHAR2
62: )
63:
64: IS
65: CURSOR C2 IS SELECT IEX_REPOSSESSIONS_S.nextval FROM sys.dual;
66: BEGIN
67: If (px_REPOSSESSION_ID IS NULL) OR (px_REPOSSESSION_ID = FND_API.G_MISS_NUM) then
68: OPEN C2;
69: FETCH C2 INTO px_REPOSSESSION_ID;

Line 72: INSERT INTO IEX_REPOSSESSIONS(

68: OPEN C2;
69: FETCH C2 INTO px_REPOSSESSION_ID;
70: CLOSE C2;
71: End If;
72: INSERT INTO IEX_REPOSSESSIONS(
73: REPOSSESSION_ID
74: ,DELINQUENCY_ID
75: ,PARTY_ID
76: ,CUST_ACCOUNT_ID

Line 219: Update IEX_REPOSSESSIONS

215: )
216:
217: IS
218: BEGIN
219: Update IEX_REPOSSESSIONS
220: SET
221: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID)
222: ,PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID)
223: ,CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)

Line 276: DELETE FROM IEX_REPOSSESSIONS

272: PROCEDURE Delete_Row(
273: p_REPOSSESSION_ID NUMBER)
274: IS
275: BEGIN
276: DELETE FROM IEX_REPOSSESSIONS
277: WHERE REPOSSESSION_ID = p_REPOSSESSION_ID;
278: If (SQL%NOTFOUND) then
279: RAISE NO_DATA_FOUND;
280: End If;

Line 334: FROM IEX_REPOSSESSIONS

330:
331: IS
332: CURSOR C IS
333: SELECT *
334: FROM IEX_REPOSSESSIONS
335: WHERE REPOSSESSION_ID = p_REPOSSESSION_ID
336: FOR UPDATE of REPOSSESSION_ID NOWAIT;
337: Recinfo C%ROWTYPE;
338: BEGIN

Line 489: End IEX_REPOSSESSIONS_PKG;

485: APP_EXCEPTION.RAISE_EXCEPTION;
486: End If;
487: END Lock_Row;
488:
489: End IEX_REPOSSESSIONS_PKG;