12: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE';
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
15: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
19:
20: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
15: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
19:
20: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
21: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPRODUCTS_PVT';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
15: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
19:
20: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
21: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPRODUCTS_PVT';
22:
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
19:
20: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
21: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPRODUCTS_PVT';
22:
23: G_INIT_VERSION CONSTANT NUMBER := 1.0;
24: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
73:
74: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
75:
76: TYPE pdt_parameters_rec_type IS RECORD (
77: id NUMBER := okl_api.G_MISS_NUM,
78: name OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
74: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
75:
76: TYPE pdt_parameters_rec_type IS RECORD (
77: id NUMBER := okl_api.G_MISS_NUM,
78: name OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
75:
76: TYPE pdt_parameters_rec_type IS RECORD (
77: id NUMBER := okl_api.G_MISS_NUM,
78: name OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
76: TYPE pdt_parameters_rec_type IS RECORD (
77: id NUMBER := okl_api.G_MISS_NUM,
78: name OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
77: id NUMBER := okl_api.G_MISS_NUM,
78: name OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
78: name OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
82: object_version_number NUMBER := okl_api.G_MISS_NUM,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
83: aes_id NUMBER := okl_api.G_MISS_NUM,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
84: ptl_id NUMBER := okl_api.G_MISS_NUM,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
107: reporting_pdt_id NUMBER := okl_api.G_MISS_NUM,
100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
107: reporting_pdt_id NUMBER := okl_api.G_MISS_NUM,
108: reporting_product OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR
101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
107: reporting_pdt_id NUMBER := okl_api.G_MISS_NUM,
108: reporting_product OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR
109: );
102: Product_subclass OKL_PDT_QUALITYS_V.NAME%TYPE := okl_api.G_MISS_CHAR,
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
107: reporting_pdt_id NUMBER := okl_api.G_MISS_NUM,
108: reporting_product OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR
109: );
110:
103: Deal_Type OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
107: reporting_pdt_id NUMBER := okl_api.G_MISS_NUM,
108: reporting_product OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR
109: );
110:
111: g_miss_pdt_parameters_rec pdt_parameters_rec_type;
104: Tax_Owner OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%TYPE := okl_api.G_MISS_CHAR,
107: reporting_pdt_id NUMBER := okl_api.G_MISS_NUM,
108: reporting_product OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR
109: );
110:
111: g_miss_pdt_parameters_rec pdt_parameters_rec_type;
112:
132: x_pdtv_rec OUT NOCOPY pdtv_rec_type);
133:
134: PROCEDURE insert_products(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_pdtv_rec IN pdtv_rec_type,
141: x_pdtv_rec OUT NOCOPY pdtv_rec_type);
142:
143: PROCEDURE update_products(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_pdtv_rec IN pdtv_rec_type,
152:
153: --- Submit for Approval
154: PROCEDURE product_approval_process
155: ( p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_pdtv_rec IN pdtv_rec_type);
176:
177: --- procedure to update product status
178: PROCEDURE update_product_status(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_pdt_status IN VARCHAR2,
186:
187: --procedure to validate_product
188: PROCEDURE validate_product(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_pdtv_rec IN pdtv_rec_type,
199:
200:
201: PROCEDURE Getpdt_parameters(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_no_data_found OUT NOCOPY BOOLEAN,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,