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_LOP_PVT dependencies on OKL_API

Line 8: G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;

4: --------------------
5: -- PACKAGE CONSTANTS
6: --------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_LOP_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9: G_API_VERSION CONSTANT NUMBER := 1;
10: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 100: id okl_lease_opportunities_b.id%TYPE := OKL_API.G_MISS_NUM

96: );
97:
98: -- view record structure
99: TYPE lopv_rec_type IS RECORD (
100: id okl_lease_opportunities_b.id%TYPE := OKL_API.G_MISS_NUM
101: ,object_version_number okl_lease_opportunities_b.object_version_number%TYPE
102: ,attribute_category okl_lease_opportunities_b.attribute_category%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR

Line 102: ,attribute_category okl_lease_opportunities_b.attribute_category%TYPE := OKL_API.G_MISS_CHAR

98: -- view record structure
99: TYPE lopv_rec_type IS RECORD (
100: id okl_lease_opportunities_b.id%TYPE := OKL_API.G_MISS_NUM
101: ,object_version_number okl_lease_opportunities_b.object_version_number%TYPE
102: ,attribute_category okl_lease_opportunities_b.attribute_category%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR

Line 103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR

99: TYPE lopv_rec_type IS RECORD (
100: id okl_lease_opportunities_b.id%TYPE := OKL_API.G_MISS_NUM
101: ,object_version_number okl_lease_opportunities_b.object_version_number%TYPE
102: ,attribute_category okl_lease_opportunities_b.attribute_category%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR

Line 104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR

100: id okl_lease_opportunities_b.id%TYPE := OKL_API.G_MISS_NUM
101: ,object_version_number okl_lease_opportunities_b.object_version_number%TYPE
102: ,attribute_category okl_lease_opportunities_b.attribute_category%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR

Line 105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR

101: ,object_version_number okl_lease_opportunities_b.object_version_number%TYPE
102: ,attribute_category okl_lease_opportunities_b.attribute_category%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR

Line 106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR

102: ,attribute_category okl_lease_opportunities_b.attribute_category%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR

Line 107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR

103: ,attribute1 okl_lease_opportunities_b.attribute1%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR

Line 108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR

104: ,attribute2 okl_lease_opportunities_b.attribute2%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR

Line 109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR

105: ,attribute3 okl_lease_opportunities_b.attribute3%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR

Line 110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR

106: ,attribute4 okl_lease_opportunities_b.attribute4%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR

Line 111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR

107: ,attribute5 okl_lease_opportunities_b.attribute5%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR

Line 112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR

108: ,attribute6 okl_lease_opportunities_b.attribute6%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR

Line 113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR

109: ,attribute7 okl_lease_opportunities_b.attribute7%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR

Line 114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR

110: ,attribute8 okl_lease_opportunities_b.attribute8%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR

Line 115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR

111: ,attribute9 okl_lease_opportunities_b.attribute9%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR

Line 116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR

112: ,attribute10 okl_lease_opportunities_b.attribute10%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE

Line 117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR

113: ,attribute11 okl_lease_opportunities_b.attribute11%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE

Line 118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR

114: ,attribute12 okl_lease_opportunities_b.attribute12%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM

Line 119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR

115: ,attribute13 okl_lease_opportunities_b.attribute13%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM

Line 120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE

116: ,attribute14 okl_lease_opportunities_b.attribute14%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM

Line 121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE

117: ,attribute15 okl_lease_opportunities_b.attribute15%TYPE := OKL_API.G_MISS_CHAR
118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM

Line 122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM

118: ,reference_number okl_lease_opportunities_b.reference_number%TYPE := OKL_API.G_MISS_CHAR
119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM

Line 123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM

119: ,status okl_lease_opportunities_b.status%TYPE := OKL_API.G_MISS_CHAR
120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR

Line 124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM

120: ,valid_from okl_lease_opportunities_b.valid_from%TYPE := OKL_API.G_MISS_DATE
121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR

Line 125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM

121: ,expected_start_date okl_lease_opportunities_b.expected_start_date%TYPE := OKL_API.G_MISS_DATE
122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM

Line 126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM

122: ,org_id okl_lease_opportunities_b.org_id%TYPE := OKL_API.G_MISS_NUM
123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE

Line 127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR

123: ,inv_org_id okl_lease_opportunities_b.inv_org_id%TYPE := OKL_API.G_MISS_NUM
124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM

Line 128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR

124: ,prospect_id okl_lease_opportunities_b.prospect_id%TYPE := OKL_API.G_MISS_NUM
125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM

Line 129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM

125: ,prospect_address_id okl_lease_opportunities_b.prospect_address_id%TYPE := OKL_API.G_MISS_NUM
126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM

Line 130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE

126: ,cust_acct_id okl_lease_opportunities_b.cust_acct_id%TYPE := OKL_API.G_MISS_NUM
127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM

Line 131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM

127: ,currency_code okl_lease_opportunities_b.currency_code%TYPE := OKL_API.G_MISS_CHAR
128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM

Line 132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM

128: ,currency_conversion_type okl_lease_opportunities_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE

Line 133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM

129: ,currency_conversion_rate okl_lease_opportunities_b.currency_conversion_rate%TYPE := OKL_API.G_MISS_NUM
130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE

Line 134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM

130: ,currency_conversion_date okl_lease_opportunities_b.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR

Line 135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM

131: ,program_agreement_id okl_lease_opportunities_b.program_agreement_id%TYPE := OKL_API.G_MISS_NUM
132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR

Line 136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE

132: ,master_lease_id okl_lease_opportunities_b.master_lease_id%TYPE := OKL_API.G_MISS_NUM
133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR

Line 137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE

133: ,sales_rep_id okl_lease_opportunities_b.sales_rep_id%TYPE := OKL_API.G_MISS_NUM
134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM

Line 138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR

134: ,sales_territory_id okl_lease_opportunities_b.sales_territory_id%TYPE := OKL_API.G_MISS_NUM
135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR

Line 139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR

135: ,supplier_id okl_lease_opportunities_b.supplier_id%TYPE := OKL_API.G_MISS_NUM
136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR

Line 140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR

136: ,delivery_date okl_lease_opportunities_b.delivery_date%TYPE := OKL_API.G_MISS_DATE
137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR

Line 141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM

137: ,funding_date okl_lease_opportunities_b.funding_date%TYPE := OKL_API.G_MISS_DATE
138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR
145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM

Line 142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR

138: ,property_tax_applicable okl_lease_opportunities_b.property_tax_applicable%TYPE := OKL_API.G_MISS_CHAR
139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR
145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM
146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM

Line 143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR

139: ,property_tax_billing_type okl_lease_opportunities_b.property_tax_billing_type%TYPE := OKL_API.G_MISS_CHAR
140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR
145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM
146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM
147: ,originating_vendor_id okl_lease_opportunities_b.originating_vendor_id%TYPE := OKL_API.G_MISS_NUM

Line 144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR

140: ,upfront_tax_treatment okl_lease_opportunities_b.upfront_tax_treatment%TYPE := OKL_API.G_MISS_CHAR
141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR
145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM
146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM
147: ,originating_vendor_id okl_lease_opportunities_b.originating_vendor_id%TYPE := OKL_API.G_MISS_NUM
148: --Fixed Bug# 5647107 ssdeshpa start

Line 145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM

141: ,install_site_id okl_lease_opportunities_b.install_site_id%TYPE := OKL_API.G_MISS_NUM
142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR
145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM
146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM
147: ,originating_vendor_id okl_lease_opportunities_b.originating_vendor_id%TYPE := OKL_API.G_MISS_NUM
148: --Fixed Bug# 5647107 ssdeshpa start
149: ,legal_entity_id okl_lease_opportunities_b.legal_entity_id%TYPE := OKL_API.G_MISS_NUM

Line 146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM

142: ,usage_category okl_lease_opportunities_b.usage_category%TYPE := OKL_API.G_MISS_CHAR
143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR
145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM
146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM
147: ,originating_vendor_id okl_lease_opportunities_b.originating_vendor_id%TYPE := OKL_API.G_MISS_NUM
148: --Fixed Bug# 5647107 ssdeshpa start
149: ,legal_entity_id okl_lease_opportunities_b.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
150: --Fixed Bug#5647107 ssdeshpa start

Line 147: ,originating_vendor_id okl_lease_opportunities_b.originating_vendor_id%TYPE := OKL_API.G_MISS_NUM

143: ,usage_industry_class okl_lease_opportunities_b.usage_industry_class%TYPE := OKL_API.G_MISS_CHAR
144: ,usage_industry_code okl_lease_opportunities_b.usage_industry_code%TYPE := OKL_API.G_MISS_CHAR
145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM
146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM
147: ,originating_vendor_id okl_lease_opportunities_b.originating_vendor_id%TYPE := OKL_API.G_MISS_NUM
148: --Fixed Bug# 5647107 ssdeshpa start
149: ,legal_entity_id okl_lease_opportunities_b.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
150: --Fixed Bug#5647107 ssdeshpa start
151: -- Bug 5908845. eBTax Enhancement Project

Line 149: ,legal_entity_id okl_lease_opportunities_b.legal_entity_id%TYPE := OKL_API.G_MISS_NUM

145: ,usage_amount okl_lease_opportunities_b.usage_amount%TYPE := OKL_API.G_MISS_NUM
146: ,usage_location_id okl_lease_opportunities_b.usage_location_id%TYPE := OKL_API.G_MISS_NUM
147: ,originating_vendor_id okl_lease_opportunities_b.originating_vendor_id%TYPE := OKL_API.G_MISS_NUM
148: --Fixed Bug# 5647107 ssdeshpa start
149: ,legal_entity_id okl_lease_opportunities_b.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
150: --Fixed Bug#5647107 ssdeshpa start
151: -- Bug 5908845. eBTax Enhancement Project
152: ,line_intended_use okl_lease_opportunities_b.line_intended_use%TYPE := OKL_API.G_MISS_CHAR
153: -- End Bug 5908845. eBTax Enhancement Project

Line 152: ,line_intended_use okl_lease_opportunities_b.line_intended_use%TYPE := OKL_API.G_MISS_CHAR

148: --Fixed Bug# 5647107 ssdeshpa start
149: ,legal_entity_id okl_lease_opportunities_b.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
150: --Fixed Bug#5647107 ssdeshpa start
151: -- Bug 5908845. eBTax Enhancement Project
152: ,line_intended_use okl_lease_opportunities_b.line_intended_use%TYPE := OKL_API.G_MISS_CHAR
153: -- End Bug 5908845. eBTax Enhancement Project
154: ,short_description okl_lease_opportunities_tl.short_description%TYPE := OKL_API.G_MISS_CHAR
155: ,description okl_lease_opportunities_tl.description%TYPE := OKL_API.G_MISS_CHAR
156: ,comments okl_lease_opportunities_tl.comments%TYPE := OKL_API.G_MISS_CHAR

Line 154: ,short_description okl_lease_opportunities_tl.short_description%TYPE := OKL_API.G_MISS_CHAR

150: --Fixed Bug#5647107 ssdeshpa start
151: -- Bug 5908845. eBTax Enhancement Project
152: ,line_intended_use okl_lease_opportunities_b.line_intended_use%TYPE := OKL_API.G_MISS_CHAR
153: -- End Bug 5908845. eBTax Enhancement Project
154: ,short_description okl_lease_opportunities_tl.short_description%TYPE := OKL_API.G_MISS_CHAR
155: ,description okl_lease_opportunities_tl.description%TYPE := OKL_API.G_MISS_CHAR
156: ,comments okl_lease_opportunities_tl.comments%TYPE := OKL_API.G_MISS_CHAR
157: );
158:

Line 155: ,description okl_lease_opportunities_tl.description%TYPE := OKL_API.G_MISS_CHAR

151: -- Bug 5908845. eBTax Enhancement Project
152: ,line_intended_use okl_lease_opportunities_b.line_intended_use%TYPE := OKL_API.G_MISS_CHAR
153: -- End Bug 5908845. eBTax Enhancement Project
154: ,short_description okl_lease_opportunities_tl.short_description%TYPE := OKL_API.G_MISS_CHAR
155: ,description okl_lease_opportunities_tl.description%TYPE := OKL_API.G_MISS_CHAR
156: ,comments okl_lease_opportunities_tl.comments%TYPE := OKL_API.G_MISS_CHAR
157: );
158:
159: TYPE lopv_tbl_type IS TABLE OF lopv_rec_type INDEX BY BINARY_INTEGER;

Line 156: ,comments okl_lease_opportunities_tl.comments%TYPE := OKL_API.G_MISS_CHAR

152: ,line_intended_use okl_lease_opportunities_b.line_intended_use%TYPE := OKL_API.G_MISS_CHAR
153: -- End Bug 5908845. eBTax Enhancement Project
154: ,short_description okl_lease_opportunities_tl.short_description%TYPE := OKL_API.G_MISS_CHAR
155: ,description okl_lease_opportunities_tl.description%TYPE := OKL_API.G_MISS_CHAR
156: ,comments okl_lease_opportunities_tl.comments%TYPE := OKL_API.G_MISS_CHAR
157: );
158:
159: TYPE lopv_tbl_type IS TABLE OF lopv_rec_type INDEX BY BINARY_INTEGER;
160: