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.CSP_PARTS_ORDER dependencies on HZ_CUST_ACCOUNT_SITE_V2PUB

Line 1342: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

1338: l_tmp_org_id number;
1339: l_party_site_id number;
1340: l_cust_site_id number;
1341: l_cust_acct_site_use_id NUMBER;
1342: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1343: v_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1344: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1345: x_cust_acct_site_id NUMBER;
1346: x_site_use_id NUMBER;

Line 1343: v_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;

1339: l_party_site_id number;
1340: l_cust_site_id number;
1341: l_cust_acct_site_use_id NUMBER;
1342: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1343: v_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1344: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1345: x_cust_acct_site_id NUMBER;
1346: x_site_use_id NUMBER;
1347: temp_bill_to_site_id number;

Line 1393: v_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

1389: );
1390:
1391: v_ship_bill_site number;
1392: v_bill_site_id number;
1393: v_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1394: v_pri_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1395: x_bill_acct_site_id number;
1396: x_pri_bill_acct_site_id number;
1397: l_bill_acct_site_use_id number;

Line 1394: v_pri_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

1390:
1391: v_ship_bill_site number;
1392: v_bill_site_id number;
1393: v_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1394: v_pri_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1395: x_bill_acct_site_id number;
1396: x_pri_bill_acct_site_id number;
1397: l_bill_acct_site_use_id number;
1398: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;

Line 1398: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;

1394: v_pri_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1395: x_bill_acct_site_id number;
1396: x_pri_bill_acct_site_id number;
1397: l_bill_acct_site_use_id number;
1398: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1399: v_pri_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1400: v_bill_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1401: v_pri_bill_cust_prf_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1402:

Line 1399: v_pri_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;

1395: x_bill_acct_site_id number;
1396: x_pri_bill_acct_site_id number;
1397: l_bill_acct_site_use_id number;
1398: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1399: v_pri_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1400: v_bill_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1401: v_pri_bill_cust_prf_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1402:
1403: cursor get_bill_site_id is

Line 2384: hz_cust_account_site_v2pub.get_cust_acct_site_rec (

2380:
2381: -- get cust_site record in current ou
2382: --dbms_application_info.set_client_info(l_tmp_org_id);
2383: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2384: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
2385: p_init_msg_list => FND_API.G_TRUE,
2386: p_cust_acct_site_id => l_cust_site_id,
2387: x_cust_acct_site_rec => v_cust_acct_site_rec,
2388: x_return_status => x_return_status,

Line 2422: hz_cust_account_site_v2pub.create_cust_acct_site (

2418:
2419: -- now create same site in source ou
2420: --dbms_application_info.set_client_info(l_source_operating_unit);
2421: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2422: hz_cust_account_site_v2pub.create_cust_acct_site (
2423: p_init_msg_list => FND_API.G_TRUE,
2424: p_cust_acct_site_rec => v_cust_acct_site_rec,
2425: x_cust_acct_site_id => x_cust_acct_site_id,
2426: x_return_status => x_return_status,

Line 2460: hz_cust_account_site_v2pub.get_cust_site_use_rec (

2456: EXIT WHEN get_cust_acct_site_uses%NOTFOUND;
2457:
2458: --dbms_application_info.set_client_info(l_tmp_org_id);
2459: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2460: hz_cust_account_site_v2pub.get_cust_site_use_rec (
2461: p_init_msg_list => FND_API.G_TRUE,
2462: p_site_use_id => l_cust_acct_site_use_id,
2463: x_cust_site_use_rec => v_cust_site_use_rec,
2464: x_customer_profile_rec => v_customer_profile_rec,

Line 2521: hz_cust_account_site_v2pub.get_cust_acct_site_rec (

2517: if l_existing_bill_to is null then
2518:
2519: -- do lots of stuff here
2520: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2521: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
2522: p_init_msg_list => FND_API.G_TRUE,
2523: p_cust_acct_site_id => v_bill_site_id,
2524: x_cust_acct_site_rec => v_bill_acct_site_rec,
2525: x_return_status => x_return_status,

Line 2556: hz_cust_account_site_v2pub.create_cust_acct_site (

2552: v_bill_acct_site_rec.org_id := l_source_operating_unit;
2553:
2554: -- now create same site in source ou
2555: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2556: hz_cust_account_site_v2pub.create_cust_acct_site (
2557: p_init_msg_list => FND_API.G_TRUE,
2558: p_cust_acct_site_rec => v_bill_acct_site_rec,
2559: x_cust_acct_site_id => x_bill_acct_site_id,
2560: x_return_status => x_return_status,

Line 2591: hz_cust_account_site_v2pub.get_cust_site_use_rec (

2587: */
2588: l_bill_acct_site_use_id := v_ship_bill_site;
2589:
2590: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2591: hz_cust_account_site_v2pub.get_cust_site_use_rec (
2592: p_init_msg_list => FND_API.G_TRUE,
2593: p_site_use_id => l_bill_acct_site_use_id,
2594: x_cust_site_use_rec => v_bill_site_use_rec,
2595: x_customer_profile_rec => v_bill_cust_profile_rec,

Line 2627: hz_cust_account_site_v2pub.create_cust_site_use (

2623: v_bill_site_use_rec.cust_acct_site_id := x_bill_acct_site_id;
2624: v_bill_site_use_rec.tax_code := NULL;
2625:
2626: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2627: hz_cust_account_site_v2pub.create_cust_site_use (
2628: p_init_msg_list => FND_API.G_TRUE,
2629: p_cust_site_use_rec => v_bill_site_use_rec,
2630: p_customer_profile_rec => v_bill_cust_profile_rec,
2631: p_create_profile => FND_API.G_FALSE,

Line 2679: hz_cust_account_site_v2pub.create_cust_site_use (

2675: end if;
2676:
2677: --dbms_application_info.set_client_info(l_source_operating_unit);
2678: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2679: hz_cust_account_site_v2pub.create_cust_site_use (
2680: p_init_msg_list => FND_API.G_TRUE,
2681: p_cust_site_use_rec => v_cust_site_use_rec,
2682: p_customer_profile_rec => v_customer_profile_rec,
2683: p_create_profile => FND_API.G_FALSE,

Line 2802: hz_cust_account_site_v2pub.get_cust_acct_site_rec (

2798: end if;
2799:
2800: -- do lots of stuff here
2801: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2802: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
2803: p_init_msg_list => FND_API.G_TRUE,
2804: p_cust_acct_site_id => v_primary_bill_site_id,
2805: x_cust_acct_site_rec => v_pri_bill_acct_site_rec,
2806: x_return_status => x_return_status,

Line 2837: hz_cust_account_site_v2pub.create_cust_acct_site (

2833: v_pri_bill_acct_site_rec.org_id := l_source_operating_unit;
2834:
2835: -- now create same site in source ou
2836: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2837: hz_cust_account_site_v2pub.create_cust_acct_site (
2838: p_init_msg_list => FND_API.G_TRUE,
2839: p_cust_acct_site_rec => v_pri_bill_acct_site_rec,
2840: x_cust_acct_site_id => x_pri_bill_acct_site_id,
2841: x_return_status => x_return_status,

Line 2866: hz_cust_account_site_v2pub.get_cust_site_use_rec (

2862: end if;
2863:
2864:
2865: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2866: hz_cust_account_site_v2pub.get_cust_site_use_rec (
2867: p_init_msg_list => FND_API.G_TRUE,
2868: p_site_use_id => v_primary_bill_site_use_id,
2869: x_cust_site_use_rec => v_pri_bill_site_use_rec,
2870: x_customer_profile_rec => v_pri_bill_cust_prf_rec,

Line 2902: hz_cust_account_site_v2pub.create_cust_site_use (

2898: v_pri_bill_site_use_rec.cust_acct_site_id := x_pri_bill_acct_site_id;
2899: v_pri_bill_site_use_rec.tax_code := NULL;
2900:
2901: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2902: hz_cust_account_site_v2pub.create_cust_site_use (
2903: p_init_msg_list => FND_API.G_TRUE,
2904: p_cust_site_use_rec => v_pri_bill_site_use_rec,
2905: p_customer_profile_rec => v_pri_bill_cust_prf_rec,
2906: p_create_profile => FND_API.G_FALSE,