APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on HZ_CUSTOMER_PROFILES

Line 270: UPDATE HZ_CUSTOMER_PROFILES ACC

266: EXIT;
267: ELSE
268: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
269: FORALL i in l_customer_id.first..l_customer_id.last
270: UPDATE HZ_CUSTOMER_PROFILES ACC
271: SET object_version_number = nvl(object_version_number,0) + 1,
272: ACC.LAST_UPDATE_DATE = SYSDATE,
273: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
274: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 294: UPDATE HZ_CUSTOMER_PROFILES ACC

290: IEX_TERR_WINNERS_PUB.Print_Debug('Deadlock encountered during party bulk update.. Performing row update..');
291: ROLLBACK;
292: FOR i in l_first .. l_last LOOP
293: BEGIN
294: UPDATE HZ_CUSTOMER_PROFILES ACC
295: SET object_version_number = nvl(object_version_number,0) + 1,
296: ACC.LAST_UPDATE_DATE = SYSDATE,
297: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
298: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 464: UPDATE HZ_CUSTOMER_PROFILES ACC

460: EXIT;
461: ELSE
462: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
463: FORALL i in l_customer_id.first..l_customer_id.last
464: UPDATE HZ_CUSTOMER_PROFILES ACC
465: SET object_version_number = nvl(object_version_number,0) + 1,
466: ACC.LAST_UPDATE_DATE = SYSDATE,
467: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
468: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 488: UPDATE HZ_CUSTOMER_PROFILES ACC

484: IEX_TERR_WINNERS_PUB.Print_Debug('Deadlock encountered during bulk update.. Performing row update..');
485: ROLLBACK;
486: FOR i in l_first .. l_last LOOP
487: BEGIN
488: UPDATE HZ_CUSTOMER_PROFILES ACC
489: SET object_version_number = nvl(object_version_number,0) + 1,
490: ACC.LAST_UPDATE_DATE = SYSDATE,
491: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
492: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 723: UPDATE HZ_CUSTOMER_PROFILES ACC

719: EXIT;
720: ELSE
721: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
722: FORALL i in l_customer_id.first..l_customer_id.last
723: UPDATE HZ_CUSTOMER_PROFILES ACC
724: SET object_version_number = nvl(object_version_number,0) + 1,
725: ACC.LAST_UPDATE_DATE = SYSDATE,
726: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
727: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 747: UPDATE HZ_CUSTOMER_PROFILES ACC

743: IEX_TERR_WINNERS_PUB.Print_Debug('Deadlock encountered during bulk update.. Performing row update..');
744: ROLLBACK;
745: FOR i in l_first .. l_last LOOP
746: BEGIN
747: UPDATE HZ_CUSTOMER_PROFILES ACC
748: SET object_version_number = nvl(object_version_number,0) + 1,
749: ACC.LAST_UPDATE_DATE = SYSDATE,
750: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
751: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 1096: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp

1092: 'RS_GROUP', 'RS_GROUP', 'RS_EMPLOYEE') = WIN.RESOURCE_TYPE
1093: AND jtrr.role_resource_id = WIN.RESOURCE_ID
1094: AND jtr.ROLE_ID = jtrr.role_id and jtr.role_type_code = 'COLLECTIONS'
1095: AND NOT EXISTS
1096: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp
1097: WHERE hcp.CUST_ACCOUNT_ID = -1 AND
1098: hcp.PARTY_ID = WIN.TRANS_OBJECT_ID AND
1099: hcp.site_use_id is null )
1100: GROUP BY WIN.TRANS_OBJECT_id;

Line 1165: FROM HZ_CUSTOMER_PROFILES hcp

1161: --Bug4574749. Fix By LKKUMAR on 12-Oct-2005. Start.
1162: BEGIN
1163: SELECT CUST_ACCOUNT_PROFILE_ID
1164: INTO l_profile_id
1165: FROM HZ_CUSTOMER_PROFILES hcp
1166: WHERE hcp.CUST_ACCOUNT_ID = -1
1167: AND hcp.PARTY_ID = l_missCustomer(i)
1168: AND hcp.site_use_id is null;
1169: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1209: FROM HZ_CUSTOMER_PROFILES hcp

1205: --Bug4574749. Fix By LKKUMAR on 12-Oct-2005. Start.
1206: BEGIN
1207: SELECT CUST_ACCOUNT_PROFILE_ID
1208: INTO l_profile_id
1209: FROM HZ_CUSTOMER_PROFILES hcp
1210: WHERE hcp.CUST_ACCOUNT_ID = -1
1211: AND hcp.PARTY_ID = l_missCustomer(i)
1212: AND hcp.site_use_id is null;
1213: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1322: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp

1318: AND hzp.cust_acct_site_id = acct_site.cust_acct_site_id
1319: AND win.org_id = hzp.org_id
1320: and hzp.SITE_USE_CODE = 'BILL_TO'
1321: AND NOT EXISTS
1322: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp
1323: WHERE hcp.PARTY_ID = WIN.TRANS_OBJECT_ID AND
1324: hcp.site_use_id = HZP.site_use_id )
1325: GROUP BY WIN.TRANS_OBJECT_ID, acct_site.cust_account_id, hzp.SITE_USE_ID;
1326:

Line 1328: -- Bulk Read the Non-existents in HZ_CUSTOMER_PROFILES Customer Sites

1324: hcp.site_use_id = HZP.site_use_id )
1325: GROUP BY WIN.TRANS_OBJECT_ID, acct_site.cust_account_id, hzp.SITE_USE_ID;
1326:
1327: Begin
1328: -- Bulk Read the Non-existents in HZ_CUSTOMER_PROFILES Customer Sites
1329: l_loop_count := 0;
1330: l_max_fetches := p_terr_globals.cursor_limit;
1331: LOOP
1332: if (l_limit_flag) then