100: attribute12,
101: attribute13,
102: attribute14,
103: attribute15
104: FROM okl_k_lines okl
105: WHERE okl.id = p_kle_id;
106: --record for storing okl_k_lines dffs
107: TYPE dff_rec_type IS RECORD(
108: attribute_category okl_k_lines.attribute_category%TYPE,
102: attribute14,
103: attribute15
104: FROM okl_k_lines okl
105: WHERE okl.id = p_kle_id;
106: --record for storing okl_k_lines dffs
107: TYPE dff_rec_type IS RECORD(
108: attribute_category okl_k_lines.attribute_category%TYPE,
109: attribute1 okl_k_lines.attribute1%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
104: FROM okl_k_lines okl
105: WHERE okl.id = p_kle_id;
106: --record for storing okl_k_lines dffs
107: TYPE dff_rec_type IS RECORD(
108: attribute_category okl_k_lines.attribute_category%TYPE,
109: attribute1 okl_k_lines.attribute1%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
105: WHERE okl.id = p_kle_id;
106: --record for storing okl_k_lines dffs
107: TYPE dff_rec_type IS RECORD(
108: attribute_category okl_k_lines.attribute_category%TYPE,
109: attribute1 okl_k_lines.attribute1%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
106: --record for storing okl_k_lines dffs
107: TYPE dff_rec_type IS RECORD(
108: attribute_category okl_k_lines.attribute_category%TYPE,
109: attribute1 okl_k_lines.attribute1%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
107: TYPE dff_rec_type IS RECORD(
108: attribute_category okl_k_lines.attribute_category%TYPE,
109: attribute1 okl_k_lines.attribute1%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
108: attribute_category okl_k_lines.attribute_category%TYPE,
109: attribute1 okl_k_lines.attribute1%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
109: attribute1 okl_k_lines.attribute1%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
110: attribute2 okl_k_lines.attribute2%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
111: attribute3 okl_k_lines.attribute3%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
112: attribute4 okl_k_lines.attribute4%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
113: attribute5 okl_k_lines.attribute5%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
121: attribute13 okl_k_lines.attribute13%TYPE,
114: attribute6 okl_k_lines.attribute6%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
121: attribute13 okl_k_lines.attribute13%TYPE,
122: attribute14 okl_k_lines.attribute14%TYPE,
115: attribute7 okl_k_lines.attribute7%TYPE,
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
121: attribute13 okl_k_lines.attribute13%TYPE,
122: attribute14 okl_k_lines.attribute14%TYPE,
123: attribute15 okl_k_lines.attribute15%TYPE);
116: attribute8 okl_k_lines.attribute8%TYPE,
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
121: attribute13 okl_k_lines.attribute13%TYPE,
122: attribute14 okl_k_lines.attribute14%TYPE,
123: attribute15 okl_k_lines.attribute15%TYPE);
124: txl_contracts_dff_rec dff_rec_type;
117: attribute9 okl_k_lines.attribute9%TYPE,
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
121: attribute13 okl_k_lines.attribute13%TYPE,
122: attribute14 okl_k_lines.attribute14%TYPE,
123: attribute15 okl_k_lines.attribute15%TYPE);
124: txl_contracts_dff_rec dff_rec_type;
125: --product name and tax owner
118: attribute10 okl_k_lines.attribute10%TYPE,
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
121: attribute13 okl_k_lines.attribute13%TYPE,
122: attribute14 okl_k_lines.attribute14%TYPE,
123: attribute15 okl_k_lines.attribute15%TYPE);
124: txl_contracts_dff_rec dff_rec_type;
125: --product name and tax owner
126: CURSOR product_name_csr(p_pdt_id IN NUMBER) IS
119: attribute11 okl_k_lines.attribute11%TYPE,
120: attribute12 okl_k_lines.attribute12%TYPE,
121: attribute13 okl_k_lines.attribute13%TYPE,
122: attribute14 okl_k_lines.attribute14%TYPE,
123: attribute15 okl_k_lines.attribute15%TYPE);
124: txl_contracts_dff_rec dff_rec_type;
125: --product name and tax owner
126: CURSOR product_name_csr(p_pdt_id IN NUMBER) IS
127: SELECT NAME,
1854:
1855: -- get the residual value for the fin asset
1856: CURSOR l_linesfullv_csr(p_fin_asset_id IN NUMBER) IS
1857: SELECT name, NVL(residual_value,0) -- girao Bug 4106216 NVL the residual value
1858: FROM okl_k_lines_full_v
1859: WHERE id = p_fin_asset_id;
1860:
1861: --SECHAWLA 10-FEB-06 5016156 : begin
1862: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
3667:
3668: -- get the residual value for the fin asset
3669: CURSOR l_linesfullv_csr(p_fin_asset_id IN NUMBER) IS
3670: SELECT name, NVL(residual_value,0) --girao bug 4106216 NVL the residual value
3671: FROM okl_k_lines_full_v
3672: WHERE id = p_fin_asset_id;
3673:
3674: --SECHAWLA 10-FEB-06 5016156
3675: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS