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_XSI_PVT dependencies on OKL_EXT_SELL_INVS_V

Line 86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,

82: INDEX BY BINARY_INTEGER;
83: TYPE xsiv_rec_type IS RECORD (
84: id NUMBER := Okl_Api.G_MISS_NUM,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,

Line 88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,

84: id NUMBER := Okl_Api.G_MISS_NUM,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,

Line 92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,

88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,

Line 93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,

89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,

Line 94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,

90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,

Line 95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,

91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,

Line 100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,

96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,

Line 101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,

97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,

Line 102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,

98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,

Line 103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,

99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,

Line 104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,

100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,

Line 107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,

103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */

Line 113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,

109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,

Line 114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,

110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,

Line 115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,

111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,

Line 116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,

112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,

Line 117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,

113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,

Line 118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,

114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,

Line 119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,

115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,

Line 120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,

116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,

Line 121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,

117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,

Line 122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,

118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,

Line 123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,

119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,

Line 124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,

120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,

Line 125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,

121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,

Line 126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,

122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,

Line 127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,

123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,

Line 128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,

124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,

Line 132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,

128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,

Line 135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,

131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,

Line 137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,

133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,

Line 178: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_EXT_SELL_INVS_V';

174: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
175:
176:
177: --GLOBAL VARIABLES
178: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_EXT_SELL_INVS_V';
179: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
180:
181: ---------------------------------------------------------------------------
182: -- validation Procedures and Functions