169: -- The following record structure added as part of shipping parameter form
170: -- changes for 11.5.12
171: TYPE parameter_value_rec_Typ IS RECORD(
172: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
173: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
174: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
175: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
176: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
177: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
170: -- changes for 11.5.12
171: TYPE parameter_value_rec_Typ IS RECORD(
172: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
173: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
174: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
175: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
176: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
177: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
178: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
171: TYPE parameter_value_rec_Typ IS RECORD(
172: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
173: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
174: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
175: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
176: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
177: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
178: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
179:
172: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
173: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
174: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
175: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
176: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
177: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
178: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
179:
180: type row_id_tbl is table of varchar2(50) index by binary_integer;
173: CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
174: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
175: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
176: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
177: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
178: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
179:
180: type row_id_tbl is table of varchar2(50) index by binary_integer;
181:
174: PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
175: PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
176: PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
177: PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
178: PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
179:
180: type row_id_tbl is table of varchar2(50) index by binary_integer;
181:
182: /* Procedure to get the Template Names */