DBA Data[Home] [Help]

APPS.FTE_REGION_ZONE_LOADER dependencies on WSH_REGIONS_SEARCH_PKG

Line 62: -- Purpose: call wsh_regions_search_pkg and get region information

58: --_______________________________________________________________________________________--
59: --
60: -- FUNCTION GET_REGION
61: --
62: -- Purpose: call wsh_regions_search_pkg and get region information
63: --
64: -- IN parameters:
65: -- 1. p_region_info: region information record
66: --

Line 72: FUNCTION GET_REGION_ID(p_region_info IN wsh_regions_search_pkg.region_rec) RETURN NUMBER;

68: -- 1. x_status: status, -1 if no error
69: -- 2. x_error_msg: error message if error
70: --_______________________________________________________________________________________--
71:
72: FUNCTION GET_REGION_ID(p_region_info IN wsh_regions_search_pkg.region_rec) RETURN NUMBER;
73:
74: --_______________________________________________________________________________________--
75: --
76: -- FUNCTION GET_REGION_ID

Line 78: -- Purpose: call wsh_regions_search_pkg and get region information

74: --_______________________________________________________________________________________--
75: --
76: -- FUNCTION GET_REGION_ID
77: --
78: -- Purpose: call wsh_regions_search_pkg and get region information
79: --
80: -- IN parameters:
81: -- 1. p_region_info: region information record
82: -- 2. p_recursively_flag: recursive search flag

Line 89: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC,

85: -- 1. x_status: status, -1 if no error
86: -- 2. x_error_msg: error message if error
87: --_______________________________________________________________________________________--
88:
89: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC,
90: p_recursively_flag IN VARCHAR2) RETURN NUMBER;
91:
92: --_______________________________________________________________________________________--
93: --