[Home] [Help]
1927: WHERE location_id = p_incident_location_id;
1928: Elsif p_incident_location_type = 'HZ_PARTY_SITE' Then
1929:
1930: SELECT b.country INTO x_incident_country
1931: FROM hz_party_sites a,
1932: hz_locations b
1933: WHERE party_site_id = p_incident_location_id
1934: AND a.location_id = b.location_id;
1935:
2470: -- Initialize the return status.
2471: x_return_status := FND_API.G_RET_STS_SUCCESS;
2472:
2473: -- Changes made by shijain dec 4th 2002, added the check if the profile
2474: -- value of cs_sr_restrict_ib is yes then check for hz_party_sites and
2475: -- hz_locations else don't need to check anything
2476:
2477: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2478: SELECT a.inventory_item_id
2484: --AND a.owner_party_id = p_customer_id
2485: AND cip.party_id = p_customer_id
2486: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
2487: AND TRUNC(NVL(a.active_end_date, SYSDATE))
2488: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
2489: AND a.owner_party_source_table = 'HZ_PARTIES'
2490: AND a.instance_id = cip.instance_id
2491: AND cip.party_source_table = 'HZ_PARTIES'
2492: AND a.inventory_item_id = b.inventory_item_id
2585: IF ( p_customer_product_id IS NOT NULL ) AND
2586: ( p_customer_product_id <> FND_API.G_MISS_NUM ) THEN
2587:
2588: -- Changes made by shijain dec 4th 2002, added the check if the profile
2589: -- value of cs_sr_restrict_ib is yes then check for hz_party_sites and
2590: -- hz_locations else don't need to check anything
2591:
2592: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2593:
2605: -- Added contract_item_type_code condition
2606: -- For ER 3701924
2607: -- AND contract_item_type_code IS NULL
2608: -- Added for Bug# 2167129,2175917
2609: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
2610: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
2611: AND TRUNC(NVL(a.active_end_date, SYSDATE))
2612: AND b.inventory_item_id = a.inventory_item_id
2613: AND b.organization_id = p_inventory_org_id
3241: AND cip.party_id = p_customer_id
3242: AND a.instance_id = cip.instance_id
3243: AND cip.party_source_table = 'HZ_PARTIES'
3244: AND b.serv_req_enabled_code = 'E'
3245: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
3246: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
3247: AND TRUNC(NVL(a.active_end_date, SYSDATE))
3248: AND b.inventory_item_id = a.inventory_item_id
3249: AND b.organization_id = p_inventory_org_id
3285: AND b.inventory_item_id = a.inventory_item_id
3286: AND cip.party_id = p_customer_id
3287: AND a.instance_id = cip.instance_id
3288: AND a.external_reference = p_external_reference
3289: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
3290: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
3291: AND TRUNC(NVL(a.active_end_date, SYSDATE))
3292: AND rownum < 2;
3293:
3508: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
3509:
3510: CURSOR Bill_To_Site IS
3511: SELECT su.party_site_use_id
3512: FROM Hz_Party_Sites s,
3513: Hz_Party_Site_Uses su
3514: WHERE s.party_site_id = su.party_site_id
3515: AND s.party_site_id = p_bill_to_site_id
3516: AND s.party_id = p_bill_to_party_id
3572: -- Fix to bug # 2529361.included keyword distinct in select clause.
3573: -- # 2615775 - removed reference to hz_party_site_uses..
3574:
3575: SELECT DISTINCT s.party_id INTO l_install_customer_id
3576: FROM Hz_Party_Sites s
3577: WHERE s.party_site_id = p_install_site_id
3578: AND s.status = 'A'
3579: -- Belongs to SR Customer
3580: AND ( s.party_id = p_customer_id
6158: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
6159:
6160: CURSOR Site_Site_Use IS
6161: SELECT s.status
6162: FROM Hz_Party_Sites s,
6163: Hz_Party_Site_Uses su
6164: WHERE s.party_site_id = su.party_site_id
6165: AND s.party_site_id = p_site_id
6166: AND s.party_id = p_party_id
6222: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
6223:
6224: CURSOR Bill_To_Site_Use IS
6225: SELECT s.party_site_id
6226: FROM Hz_Party_Sites s,
6227: Hz_Party_Site_Uses su
6228: WHERE s.party_site_id = su.party_site_id
6229: AND su.party_site_use_id = p_site_use_id
6230: AND s.party_id = p_party_id
6385:
6386: SELECT 'x' INTO l_dummy
6387: FROM csi_item_instances a
6388: WHERE a.instance_id = p_customer_product_id
6389: AND a.install_location_type_code = 'HZ_PARTY_SITES'
6390: AND a.install_location_id = p_install_site_id;
6391:
6392: EXCEPTION
6393: WHEN NO_DATA_FOUND THEN
9582: RAISE FND_API.G_EXC_ERROR;
9583: END IF;
9584: --
9585: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9586: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9587: THEN
9588: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9589: FND_MESSAGE.set_token('LOC',l_loc_type);
9590: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));