APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on HZ_CUSTOMER_PROFILES

Line 295: UPDATE HZ_CUSTOMER_PROFILES ACC

291: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);
293:
294: FORALL i in l_customer_id.first..l_customer_id.last
295: UPDATE HZ_CUSTOMER_PROFILES ACC
296: SET object_version_number = nvl(object_version_number,0) + 1,
297: ACC.LAST_UPDATE_DATE = SYSDATE,
298: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
299: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 323: UPDATE HZ_CUSTOMER_PROFILES ACC

319:
320: FOR i in l_first .. l_last LOOP
321: BEGIN
322: l_cnt := l_cnt + 1;
323: UPDATE HZ_CUSTOMER_PROFILES ACC
324: SET object_version_number = nvl(object_version_number,0) + 1,
325: ACC.LAST_UPDATE_DATE = SYSDATE,
326: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
327: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 504: UPDATE HZ_CUSTOMER_PROFILES ACC

500: ELSE
501: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
502: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);
503: FORALL i in l_customer_id.first..l_customer_id.last
504: UPDATE HZ_CUSTOMER_PROFILES ACC
505: SET object_version_number = nvl(object_version_number,0) + 1,
506: ACC.LAST_UPDATE_DATE = SYSDATE,
507: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
508: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 531: UPDATE HZ_CUSTOMER_PROFILES ACC

527: ROLLBACK;
528: FOR i in l_first .. l_last LOOP
529: BEGIN
530: l_cnt := l_cnt + 1;
531: UPDATE HZ_CUSTOMER_PROFILES ACC
532: SET object_version_number = nvl(object_version_number,0) + 1,
533: ACC.LAST_UPDATE_DATE = SYSDATE,
534: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
535: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 776: UPDATE HZ_CUSTOMER_PROFILES ACC

772: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);
774:
775: FORALL i in l_customer_id.first..l_customer_id.last
776: UPDATE HZ_CUSTOMER_PROFILES ACC
777: SET object_version_number = nvl(object_version_number,0) + 1,
778: ACC.LAST_UPDATE_DATE = SYSDATE,
779: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
780: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 803: UPDATE HZ_CUSTOMER_PROFILES ACC

799: ROLLBACK;
800: FOR i in l_first .. l_last LOOP
801: BEGIN
802: l_cnt := l_cnt + 1;
803: UPDATE HZ_CUSTOMER_PROFILES ACC
804: SET object_version_number = nvl(object_version_number,0) + 1,
805: ACC.LAST_UPDATE_DATE = SYSDATE,
806: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
807: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,

Line 1155: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp

1151: AND jtrr.role_resource_id = WIN.RESOURCE_ID
1152: AND jtr.ROLE_ID = jtrr.role_id and jtr.role_type_code = 'COLLECTIONS'
1153: AND acc.status = 'A' -- added for bug 10087650 PNAVEENK
1154: AND NOT EXISTS
1155: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp
1156: WHERE hcp.CUST_ACCOUNT_ID = -1 AND
1157: hcp.PARTY_ID = WIN.TRANS_OBJECT_ID AND
1158: hcp.site_use_id is null )
1159: GROUP BY WIN.TRANS_OBJECT_id;

Line 1226: FROM HZ_CUSTOMER_PROFILES hcp

1222: --Bug4574749. Fix By LKKUMAR on 12-Oct-2005. Start.
1223: BEGIN
1224: SELECT CUST_ACCOUNT_PROFILE_ID
1225: INTO l_profile_id
1226: FROM HZ_CUSTOMER_PROFILES hcp
1227: WHERE hcp.CUST_ACCOUNT_ID = -1
1228: AND hcp.PARTY_ID = l_missCustomer(i)
1229: AND hcp.site_use_id is null;
1230: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1271: FROM HZ_CUSTOMER_PROFILES hcp

1267: --Bug4574749. Fix By LKKUMAR on 12-Oct-2005. Start.
1268: BEGIN
1269: SELECT CUST_ACCOUNT_PROFILE_ID
1270: INTO l_profile_id
1271: FROM HZ_CUSTOMER_PROFILES hcp
1272: WHERE hcp.CUST_ACCOUNT_ID = -1
1273: AND hcp.PARTY_ID = l_missCustomer(i)
1274: AND hcp.site_use_id is null;
1275: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1385: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp

1381: AND win.org_id = hzp.org_id
1382: AND acc.status = 'A' -- added for bug 10087650 PNAVEENK
1383: and hzp.SITE_USE_CODE = 'BILL_TO'
1384: AND NOT EXISTS
1385: (SELECT 1 FROM HZ_CUSTOMER_PROFILES hcp
1386: WHERE hcp.PARTY_ID = WIN.TRANS_OBJECT_ID AND
1387: hcp.site_use_id = HZP.site_use_id )
1388: GROUP BY WIN.TRANS_OBJECT_ID, acct_site.cust_account_id, hzp.SITE_USE_ID;
1389:

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

1389:
1390: Begin
1391:
1392: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Creating Site Profiles ...... ***');
1393: -- Bulk Read the Non-existents in HZ_CUSTOMER_PROFILES Customer Sites
1394: l_loop_count := 0;
1395: l_max_fetches := p_terr_globals.cursor_limit;
1396: LOOP
1397: if (l_limit_flag) then