[Home] [Help]
1104: cursor c_bill_to_ship_to (v_instance_id number, v_type varchar2) is
1105: SELECT
1106: c.party_id party_id,
1107: nvl(a.party_site_id , 0) party_site_id
1108: from hz_party_sites a, hz_party_site_uses b ,csi_i_parties c
1109: where a.party_id(+) = c.party_id
1110: and c.RELATIONSHIP_TYPE_CODE = v_type
1111: and c.instance_id = v_instance_id
1112: and b.party_site_id(+) = a.party_site_id
1120:
1121:
1122: cursor c_install_site(v_party_id number, v_location_id number ) is
1123: select party_site_id
1124: from hz_party_sites
1125: where party_id = v_party_id
1126: and location_id = v_location_id;
1127:
1128: BEGIN
1169: l_system_id := r_from_ib_instance.SYSTEM_ID;
1170:
1171: /*
1172: Chenged for FS Asstets Flow
1173: IF (r_from_ib_instance.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES') THEN
1174: l_install_site_id := r_from_ib_instance.INSTALL_LOCATION_ID;
1175: ELSIF (r_from_ib_instance.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS') THEN
1176: open c_install_site(l_party_id, r_from_ib_instance.INSTALL_LOCATION_ID);
1177: fetch c_install_site into l_install_site_id;
1182: ELSE
1183: l_install_site_id := null;
1184: END IF;*/
1185:
1186: IF (r_from_ib_instance.LOCATION_TYPE_CODE = 'HZ_PARTY_SITES') THEN
1187: l_install_site_id := r_from_ib_instance.LOCATION_ID;
1188: l_service_request_rec.incident_location_type := 'HZ_PARTY_SITE';
1189: l_service_request_rec.incident_location_id := r_from_ib_instance.LOCATION_ID;
1190: ELSIF (r_from_ib_instance.LOCATION_TYPE_CODE = 'HZ_LOCATIONS') THEN
1486: BEGIN
1487: l_count := 0;
1488: SELECT count(*)
1489: INTO l_count
1490: FROM Hz_Party_Sites s
1491: WHERE s.party_site_id = p_install_site_id
1492: AND s.status = 'A'
1493: -- Belongs to SR Customer
1494: AND ( s.party_id = p_customer_id