eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_API

Line 16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;

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;

Line 17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;

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';

Line 18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;

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:

Line 20: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_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:
23: G_INIT_VERSION CONSTANT NUMBER := 1.0;
24: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;

Line 77: id NUMBER := okl_api.G_MISS_NUM,

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,

Line 78: name OKL_PRODUCTS_V.NAME%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,

Line 79: from_date OKL_PRODUCTS.FROM_DATE%TYPE := okl_api.G_MISS_DATE,

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,

Line 80: to_date OKL_PRODUCTS.TO_DATE%TYPE := okl_api.G_MISS_DATE,

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,

Line 81: version OKL_PRODUCTS_V.VERSION%TYPE := okl_api.G_MISS_CHAR,

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,

Line 82: object_version_number 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,
86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,

Line 83: aes_id NUMBER := okl_api.G_MISS_NUM,

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,

Line 84: ptl_id NUMBER := okl_api.G_MISS_NUM,

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,

Line 85: legacy_product_yn OKL_PRODUCTS.LEGACY_PRODUCT_YN%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,

Line 86: attribute_category OKL_PRODUCTS.ATTRIBUTE_CATEGORY%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,

Line 87: attribute1 OKL_PRODUCTS.ATTRIBUTE1%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,

Line 88: attribute2 OKL_PRODUCTS.ATTRIBUTE2%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,

Line 89: attribute3 OKL_PRODUCTS.ATTRIBUTE3%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,

Line 90: attribute4 OKL_PRODUCTS.ATTRIBUTE4%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,

Line 91: attribute5 OKL_PRODUCTS.ATTRIBUTE5%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,

Line 92: attribute6 OKL_PRODUCTS.ATTRIBUTE6%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,

Line 93: attribute7 OKL_PRODUCTS.ATTRIBUTE7%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,

Line 94: attribute8 OKL_PRODUCTS.ATTRIBUTE8%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,

Line 95: attribute9 OKL_PRODUCTS.ATTRIBUTE9%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,

Line 96: attribute10 OKL_PRODUCTS.ATTRIBUTE10%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,

Line 97: attribute11 OKL_PRODUCTS.ATTRIBUTE11%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,

Line 98: attribute12 OKL_PRODUCTS.ATTRIBUTE12%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,

Line 99: attribute13 OKL_PRODUCTS.ATTRIBUTE13%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,

Line 100: attribute14 OKL_PRODUCTS.ATTRIBUTE14%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,

Line 101: attribute15 OKL_PRODUCTS.ATTRIBUTE15%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,

Line 102: Product_subclass OKL_PDT_QUALITYS_V.NAME%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,

Line 103: Deal_Type 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,

Line 104: Tax_Owner OKL_PQY_VALUES_V.VALUE%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,
108: reporting_product OKL_PRODUCTS_V.NAME%TYPE := okl_api.G_MISS_CHAR

Line 105: Revenue_Recognition_Method OKL_PQY_VALUES_V.VALUE%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: );

Line 106: Interest_Calculation_Basis OKL_PQY_VALUES_V.VALUE%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: );
110:

Line 107: reporting_pdt_id NUMBER := okl_api.G_MISS_NUM,

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;

Line 108: reporting_product OKL_PRODUCTS_V.NAME%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;
112:

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

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,

Line 190: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

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,

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,