eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_ACCT_RELATE_PKG dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 38: INSERT INTO HZ_CUST_ACCT_RELATE_ALL (

34: ) IS
35:
36: BEGIN
37:
38: INSERT INTO HZ_CUST_ACCT_RELATE_ALL (
39: CUST_ACCOUNT_ID,
40: RELATED_CUST_ACCOUNT_ID,
41: LAST_UPDATE_DATE,
42: LAST_UPDATED_BY,

Line 159: UPDATE HZ_CUST_ACCT_RELATE_ALL SET -- Bug 3456489

155: ) IS
156:
157: BEGIN
158:
159: UPDATE HZ_CUST_ACCT_RELATE_ALL SET -- Bug 3456489
160: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
161: RELATED_CUST_ACCOUNT_ID = DECODE( X_RELATED_CUST_ACCOUNT_ID, NULL, RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
162: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 245: SELECT * FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

241: X_APPLICATION_ID IN NUMBER
242: ) IS
243:
244: CURSOR C IS
245: SELECT * FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
246: WHERE ROWID = x_Rowid
247: FOR UPDATE NOWAIT;
248: Recinfo C%ROWTYPE;
249:

Line 445: FROM HZ_CUST_ACCT_RELATE_ALL

441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413
445: FROM HZ_CUST_ACCT_RELATE_ALL
446: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID;
447:
448:
449: CURSOR c_sel_cust_acct_relate IS

Line 484: FROM HZ_CUST_ACCT_RELATE_ALL

480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413
484: FROM HZ_CUST_ACCT_RELATE_ALL
485: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID
486: AND RELATED_CUST_ACCOUNT_ID = X_RELATED_CUST_ACCOUNT_ID
487: AND ORG_ID = NVL(X_ORG_ID, ORG_ID) -- Bug 3456489
488: ORDER BY STATUS ASC,LAST_UPDATE_DATE DESC

Line 647: FROM HZ_CUST_ACCT_RELATE_ALL

643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),
646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)
647: FROM HZ_CUST_ACCT_RELATE_ALL
648: WHERE ROWID = X_ROWID;
649:
650: BEGIN
651: OPEN c_sel_cust_acct_relate;

Line 699: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE_ALL.customer_reciprocal_flag%TYPE;

695: PROCEDURE Delete_Row (
696: X_ROWID IN ROWID
697: ) IS
698:
699: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE_ALL.customer_reciprocal_flag%TYPE;
700: l_cust_account_id HZ_CUST_ACCT_RELATE_ALL.cust_account_id%TYPE;
701: l_related_cust_account_id HZ_CUST_ACCT_RELATE_ALL.related_cust_account_id%TYPE;
702: l_org_id HZ_CUST_ACCT_RELATE_ALL.org_id%TYPE;
703: l_status HZ_CUST_ACCT_RELATE_ALL.status%TYPE;

Line 700: l_cust_account_id HZ_CUST_ACCT_RELATE_ALL.cust_account_id%TYPE;

696: X_ROWID IN ROWID
697: ) IS
698:
699: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE_ALL.customer_reciprocal_flag%TYPE;
700: l_cust_account_id HZ_CUST_ACCT_RELATE_ALL.cust_account_id%TYPE;
701: l_related_cust_account_id HZ_CUST_ACCT_RELATE_ALL.related_cust_account_id%TYPE;
702: l_org_id HZ_CUST_ACCT_RELATE_ALL.org_id%TYPE;
703: l_status HZ_CUST_ACCT_RELATE_ALL.status%TYPE;
704:

Line 701: l_related_cust_account_id HZ_CUST_ACCT_RELATE_ALL.related_cust_account_id%TYPE;

697: ) IS
698:
699: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE_ALL.customer_reciprocal_flag%TYPE;
700: l_cust_account_id HZ_CUST_ACCT_RELATE_ALL.cust_account_id%TYPE;
701: l_related_cust_account_id HZ_CUST_ACCT_RELATE_ALL.related_cust_account_id%TYPE;
702: l_org_id HZ_CUST_ACCT_RELATE_ALL.org_id%TYPE;
703: l_status HZ_CUST_ACCT_RELATE_ALL.status%TYPE;
704:
705: BEGIN

Line 702: l_org_id HZ_CUST_ACCT_RELATE_ALL.org_id%TYPE;

698:
699: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE_ALL.customer_reciprocal_flag%TYPE;
700: l_cust_account_id HZ_CUST_ACCT_RELATE_ALL.cust_account_id%TYPE;
701: l_related_cust_account_id HZ_CUST_ACCT_RELATE_ALL.related_cust_account_id%TYPE;
702: l_org_id HZ_CUST_ACCT_RELATE_ALL.org_id%TYPE;
703: l_status HZ_CUST_ACCT_RELATE_ALL.status%TYPE;
704:
705: BEGIN
706:

Line 703: l_status HZ_CUST_ACCT_RELATE_ALL.status%TYPE;

699: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE_ALL.customer_reciprocal_flag%TYPE;
700: l_cust_account_id HZ_CUST_ACCT_RELATE_ALL.cust_account_id%TYPE;
701: l_related_cust_account_id HZ_CUST_ACCT_RELATE_ALL.related_cust_account_id%TYPE;
702: l_org_id HZ_CUST_ACCT_RELATE_ALL.org_id%TYPE;
703: l_status HZ_CUST_ACCT_RELATE_ALL.status%TYPE;
704:
705: BEGIN
706:
707: SELECT CUST_ACCOUNT_ID,

Line 717: FROM HZ_CUST_ACCT_RELATE_ALL

713: l_related_cust_account_id,
714: l_customer_reciprocal_flag,
715: l_org_id,
716: l_status
717: FROM HZ_CUST_ACCT_RELATE_ALL
718: WHERE ROWID = X_ROWID;
719: /* WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID
720: AND RELATED_CUST_ACCOUNT_ID = X_RELATED_CUST_ACCOUNT_ID;*/
721:

Line 728: UPDATE HZ_CUST_ACCT_RELATE_ALL

724: /* WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID
725: AND RELATED_CUST_ACCOUNT_ID = X_RELATED_CUST_ACCOUNT_ID;*/
726:
727: IF l_customer_reciprocal_flag = 'Y' AND l_status = 'A' THEN
728: UPDATE HZ_CUST_ACCT_RELATE_ALL
729: SET CUSTOMER_RECIPROCAL_FLAG = 'N'
730: WHERE CUST_ACCOUNT_ID = l_related_cust_account_id
731: AND RELATED_CUST_ACCOUNT_ID = l_cust_account_id
732: AND ORG_ID = l_org_id;