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_XLS_PVT dependencies on OKL_XTL_SELL_INVS_V

Line 75: sfwt_flag OKL_XTL_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,

71: INDEX BY BINARY_INTEGER;
72: TYPE xlsv_rec_type IS RECORD (
73: id NUMBER := Okl_Api.G_MISS_NUM,
74: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
75: sfwt_flag OKL_XTL_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
76: tld_id NUMBER := Okl_Api.G_MISS_NUM,
77: lsm_id NUMBER := Okl_Api.G_MISS_NUM,
78: til_id NUMBER := Okl_Api.G_MISS_NUM,
79: ill_id NUMBER := Okl_Api.G_MISS_NUM,

Line 81: line_type OKL_XTL_SELL_INVS_V.LINE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,

77: lsm_id NUMBER := Okl_Api.G_MISS_NUM,
78: til_id NUMBER := Okl_Api.G_MISS_NUM,
79: ill_id NUMBER := Okl_Api.G_MISS_NUM,
80: xsi_id_details NUMBER := Okl_Api.G_MISS_NUM,
81: line_type OKL_XTL_SELL_INVS_V.LINE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
82: description OKL_XTL_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
83: amount NUMBER := Okl_Api.G_MISS_NUM,
84: quantity NUMBER := Okl_Api.G_MISS_NUM,
85: xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,

Line 82: description OKL_XTL_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,

78: til_id NUMBER := Okl_Api.G_MISS_NUM,
79: ill_id NUMBER := Okl_Api.G_MISS_NUM,
80: xsi_id_details NUMBER := Okl_Api.G_MISS_NUM,
81: line_type OKL_XTL_SELL_INVS_V.LINE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
82: description OKL_XTL_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
83: amount NUMBER := Okl_Api.G_MISS_NUM,
84: quantity NUMBER := Okl_Api.G_MISS_NUM,
85: xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
86: xtrx_contract OKL_XTL_SELL_INVS_V.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,

Line 86: xtrx_contract OKL_XTL_SELL_INVS_V.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,

82: description OKL_XTL_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
83: amount NUMBER := Okl_Api.G_MISS_NUM,
84: quantity NUMBER := Okl_Api.G_MISS_NUM,
85: xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
86: xtrx_contract OKL_XTL_SELL_INVS_V.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,
87: xtrx_asset OKL_XTL_SELL_INVS_V.XTRX_ASSET%TYPE := Okl_Api.G_MISS_CHAR,
88: xtrx_stream_group OKL_XTL_SELL_INVS_V.XTRX_STREAM_GROUP%TYPE := Okl_Api.G_MISS_CHAR,
89: xtrx_stream_type OKL_XTL_SELL_INVS_V.XTRX_STREAM_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
90: xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,

Line 87: xtrx_asset OKL_XTL_SELL_INVS_V.XTRX_ASSET%TYPE := Okl_Api.G_MISS_CHAR,

83: amount NUMBER := Okl_Api.G_MISS_NUM,
84: quantity NUMBER := Okl_Api.G_MISS_NUM,
85: xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
86: xtrx_contract OKL_XTL_SELL_INVS_V.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,
87: xtrx_asset OKL_XTL_SELL_INVS_V.XTRX_ASSET%TYPE := Okl_Api.G_MISS_CHAR,
88: xtrx_stream_group OKL_XTL_SELL_INVS_V.XTRX_STREAM_GROUP%TYPE := Okl_Api.G_MISS_CHAR,
89: xtrx_stream_type OKL_XTL_SELL_INVS_V.XTRX_STREAM_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
90: xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,
91: isl_id NUMBER := Okl_Api.G_MISS_NUM,

Line 88: xtrx_stream_group OKL_XTL_SELL_INVS_V.XTRX_STREAM_GROUP%TYPE := Okl_Api.G_MISS_CHAR,

84: quantity NUMBER := Okl_Api.G_MISS_NUM,
85: xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
86: xtrx_contract OKL_XTL_SELL_INVS_V.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,
87: xtrx_asset OKL_XTL_SELL_INVS_V.XTRX_ASSET%TYPE := Okl_Api.G_MISS_CHAR,
88: xtrx_stream_group OKL_XTL_SELL_INVS_V.XTRX_STREAM_GROUP%TYPE := Okl_Api.G_MISS_CHAR,
89: xtrx_stream_type OKL_XTL_SELL_INVS_V.XTRX_STREAM_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
90: xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,
91: isl_id NUMBER := Okl_Api.G_MISS_NUM,
92: sel_id NUMBER := Okl_Api.G_MISS_NUM,

Line 89: xtrx_stream_type OKL_XTL_SELL_INVS_V.XTRX_STREAM_TYPE%TYPE := Okl_Api.G_MISS_CHAR,

85: xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
86: xtrx_contract OKL_XTL_SELL_INVS_V.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,
87: xtrx_asset OKL_XTL_SELL_INVS_V.XTRX_ASSET%TYPE := Okl_Api.G_MISS_CHAR,
88: xtrx_stream_group OKL_XTL_SELL_INVS_V.XTRX_STREAM_GROUP%TYPE := Okl_Api.G_MISS_CHAR,
89: xtrx_stream_type OKL_XTL_SELL_INVS_V.XTRX_STREAM_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
90: xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,
91: isl_id NUMBER := Okl_Api.G_MISS_NUM,
92: sel_id NUMBER := Okl_Api.G_MISS_NUM,
93: -- Start changes on remarketing by fmiao on 10/18/04 --

Line 96: attribute_category OKL_XTL_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,

92: sel_id NUMBER := Okl_Api.G_MISS_NUM,
93: -- Start changes on remarketing by fmiao on 10/18/04 --
94: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
95: -- End changes on remarketing by fmiao on 10/18/04 --
96: attribute_category OKL_XTL_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
97: attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,

Line 97: attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,

93: -- Start changes on remarketing by fmiao on 10/18/04 --
94: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
95: -- End changes on remarketing by fmiao on 10/18/04 --
96: attribute_category OKL_XTL_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
97: attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,

Line 98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,

94: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
95: -- End changes on remarketing by fmiao on 10/18/04 --
96: attribute_category OKL_XTL_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
97: attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,

Line 99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,

95: -- End changes on remarketing by fmiao on 10/18/04 --
96: attribute_category OKL_XTL_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
97: attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,

Line 100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,

96: attribute_category OKL_XTL_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
97: attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,

Line 101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,

97: attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,

Line 102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,

98: attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,

Line 103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,

99: attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,

Line 104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,

100: attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,

Line 105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,

101: attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,

Line 106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,

102: attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,

Line 107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,

103: attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,

Line 108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,

104: attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
112: request_id NUMBER := Okl_Api.G_MISS_NUM,

Line 109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,

105: attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
112: request_id NUMBER := Okl_Api.G_MISS_NUM,
113: program_application_id NUMBER := Okl_Api.G_MISS_NUM,

Line 110: attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,

106: attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
112: request_id NUMBER := Okl_Api.G_MISS_NUM,
113: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
114: program_id NUMBER := Okl_Api.G_MISS_NUM,

Line 111: attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,

107: attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
112: request_id NUMBER := Okl_Api.G_MISS_NUM,
113: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
114: program_id NUMBER := Okl_Api.G_MISS_NUM,
115: program_update_date OKL_XTL_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,

Line 115: program_update_date OKL_XTL_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,

111: attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
112: request_id NUMBER := Okl_Api.G_MISS_NUM,
113: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
114: program_id NUMBER := Okl_Api.G_MISS_NUM,
115: program_update_date OKL_XTL_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
116: org_id NUMBER := Okl_Api.G_MISS_NUM,
117: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_XTL_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,

Line 119: creation_date OKL_XTL_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,

115: program_update_date OKL_XTL_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
116: org_id NUMBER := Okl_Api.G_MISS_NUM,
117: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_XTL_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
121: last_update_date OKL_XTL_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
123: g_miss_xlsv_rec xlsv_rec_type;

Line 121: last_update_date OKL_XTL_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,

117: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_XTL_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
121: last_update_date OKL_XTL_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
123: g_miss_xlsv_rec xlsv_rec_type;
124: TYPE xlsv_tbl_type IS TABLE OF xlsv_rec_type
125: INDEX BY BINARY_INTEGER;

Line 155: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTL_SELL_INVS_V';

151: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
152:
153:
154: --GLOBAL VARIABLES
155: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTL_SELL_INVS_V';
156: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
157:
158: ---------------------------------------------------------------------------
159: -- validation Procedures and Functions