APPS.FTE_REGION_ZONE_LOADER dependencies on WSH_ZONE_REGIONS

Line 398: -- Purpose: To insert into wsh_zone_regions for party

394: --_______________________________________________________________________________________--
395: --
396: -- FUNCTION INSERT_PARTY_REGION
397: --
398: -- Purpose: To insert into wsh_zone_regions for party
399: --
400: -- IN parameters:
401: -- 1. p_region_id
402: -- 2. p_parent_region_id

Line 432: wsh_zone_regions

428: CURSOR GET_PARTY_REGION_ID IS
429: SELECT
430: zone_region_id
431: FROM
432: wsh_zone_regions
433: WHERE
434: region_id = p_region_id AND
435: parent_region_id = p_parent_region_id AND
436: party_id = p_supplier_id AND

Line 441: SELECT WSH_ZONE_REGIONS_S.NEXTVAL FROM DUAL;

437: (p_postal_code_from IS NULL OR postal_code_from = p_postal_code_from) AND
438: (p_postal_code_to IS NULL OR postal_code_to = p_postal_code_to) ;
439:
440: CURSOR GET_NEXT_PARTY_REGION_ID IS
441: SELECT WSH_ZONE_REGIONS_S.NEXTVAL FROM DUAL;
442:
443: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.INSERT_PARTY_REGION';
444:
445: BEGIN

Line 476: INSERT INTO WSH_ZONE_REGIONS(

472: l_postal_code_to := p_postal_code_to;
473: END IF;
474: END IF;
475:
476: INSERT INTO WSH_ZONE_REGIONS(
477: ZONE_REGION_ID,
478: REGION_ID,
479: PARENT_REGION_ID,
480: PARTY_ID,