APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 1077: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1073: l_var NUMBER;
1074:
1075: l_source_id NUMBER;
1076: l_Resource_name VARCHAR2(300);
1077: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1078:
1079: CURSOR c_MissedProfiles(c_worker_id number) IS
1080: SELECT WIN.TRANS_OBJECT_id
1081: FROM JTF_TAE_1600_CUST_WINNERS WIN,

Line 1177: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1173: l_old_customer_profile_rec.created_by_module := 'IEX';
1174: l_old_customer_profile_rec.site_use_id := NULL;
1175: l_old_customer_profile_rec.cust_account_id := NULL;
1176:
1177: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1178: p_customer_profile_rec => l_old_customer_profile_rec,
1179: x_cust_account_profile_id => l_customer_profile_id,
1180: x_return_status => l_return_status,
1181: x_msg_count => l_msg_count,

Line 1219: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1215: IEX_TERR_WINNERS_PUB.Print_Debug('Creating profile for Customer ID = '|| l_missCustomer(i) );
1216: l_old_customer_profile_rec.party_id := l_missCustomer(i);
1217: l_old_customer_profile_rec.created_by_module := 'IEX';
1218:
1219: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1220: p_customer_profile_rec => l_old_customer_profile_rec,
1221: x_cust_account_profile_id => l_customer_profile_id,
1222: x_return_status => l_return_status,
1223: x_msg_count => l_msg_count,

Line 1297: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1293: l_var NUMBER;
1294:
1295: l_source_id NUMBER;
1296: l_Resource_name VARCHAR2(300);
1297: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1298:
1299: CURSOR c_MissedProfiles(c_worker_id number) IS
1300: SELECT win.trans_object_id, hzp.SITE_USE_ID,
1301: acct_site.cust_account_id

Line 1393: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1389: l_old_customer_profile_rec.cust_account_id := l_missAccount(i);
1390: l_old_customer_profile_rec.site_use_id := l_missSiteUse(i);
1391: l_old_customer_profile_rec.created_by_module := 'IEX';
1392:
1393: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1394: p_customer_profile_rec => l_old_customer_profile_rec,
1395: x_cust_account_profile_id => l_customer_profile_id,
1396: x_return_status => l_return_status,
1397: x_msg_count => l_msg_count,

Line 1428: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1424: l_old_customer_profile_rec.site_use_id := l_missSiteUse(i);
1425: l_old_customer_profile_rec.created_by_module := 'IEX';
1426: l_old_customer_profile_rec.cust_account_id := l_missAccount(i);
1427:
1428: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1429: p_customer_profile_rec => l_old_customer_profile_rec,
1430: x_cust_account_profile_id => l_customer_profile_id,
1431: x_return_status => l_return_status,
1432: x_msg_count => l_msg_count,