APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 1135: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1131: l_var NUMBER;
1132:
1133: l_source_id NUMBER;
1134: l_Resource_name VARCHAR2(300);
1135: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1136:
1137: CURSOR c_MissedProfiles(c_worker_id number) IS
1138: SELECT WIN.TRANS_OBJECT_id
1139: FROM JTF_TAE_1600_CUST_WINNERS WIN,

Line 1238: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1234: l_old_customer_profile_rec.created_by_module := 'IEX';
1235: l_old_customer_profile_rec.site_use_id := NULL;
1236: l_old_customer_profile_rec.cust_account_id := NULL;
1237:
1238: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1239: p_customer_profile_rec => l_old_customer_profile_rec,
1240: x_cust_account_profile_id => l_customer_profile_id,
1241: x_return_status => l_return_status,
1242: x_msg_count => l_msg_count,

Line 1281: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1277: IEX_TERR_WINNERS_PUB.Print_Debug('Creating profile for Customer ID = '|| l_missCustomer(i) );
1278: l_old_customer_profile_rec.party_id := l_missCustomer(i);
1279: l_old_customer_profile_rec.created_by_module := 'IEX';
1280:
1281: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1282: p_customer_profile_rec => l_old_customer_profile_rec,
1283: x_cust_account_profile_id => l_customer_profile_id,
1284: x_return_status => l_return_status,
1285: x_msg_count => l_msg_count,

Line 1359: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1355: l_var NUMBER;
1356:
1357: l_source_id NUMBER;
1358: l_Resource_name VARCHAR2(300);
1359: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1360:
1361: CURSOR c_MissedProfiles(c_worker_id number) IS
1362: SELECT win.trans_object_id, hzp.SITE_USE_ID,
1363: acct_site.cust_account_id

Line 1458: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1454: l_old_customer_profile_rec.cust_account_id := l_missAccount(i);
1455: l_old_customer_profile_rec.site_use_id := l_missSiteUse(i);
1456: l_old_customer_profile_rec.created_by_module := 'IEX';
1457:
1458: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1459: p_customer_profile_rec => l_old_customer_profile_rec,
1460: x_cust_account_profile_id => l_customer_profile_id,
1461: x_return_status => l_return_status,
1462: x_msg_count => l_msg_count,

Line 1493: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1489: l_old_customer_profile_rec.site_use_id := l_missSiteUse(i);
1490: l_old_customer_profile_rec.created_by_module := 'IEX';
1491: l_old_customer_profile_rec.cust_account_id := l_missAccount(i);
1492:
1493: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1494: p_customer_profile_rec => l_old_customer_profile_rec,
1495: x_cust_account_profile_id => l_customer_profile_id,
1496: x_return_status => l_return_status,
1497: x_msg_count => l_msg_count,