DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_DISPOSE_PVT dependencies on OKL_K_LINES

Line 104: FROM okl_k_lines okl

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,

Line 106: --record for storing okl_k_lines dffs

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,

Line 108: attribute_category okl_k_lines.attribute_category%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,

Line 109: attribute1 okl_k_lines.attribute1%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,

Line 110: attribute2 okl_k_lines.attribute2%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,

Line 111: attribute3 okl_k_lines.attribute3%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,

Line 112: attribute4 okl_k_lines.attribute4%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,

Line 113: attribute5 okl_k_lines.attribute5%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,

Line 114: attribute6 okl_k_lines.attribute6%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,

Line 115: attribute7 okl_k_lines.attribute7%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,

Line 116: attribute8 okl_k_lines.attribute8%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,

Line 117: attribute9 okl_k_lines.attribute9%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,

Line 118: attribute10 okl_k_lines.attribute10%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,

Line 119: attribute11 okl_k_lines.attribute11%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);

Line 120: attribute12 okl_k_lines.attribute12%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;

Line 121: attribute13 okl_k_lines.attribute13%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

Line 122: attribute14 okl_k_lines.attribute14%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
126: CURSOR product_name_csr(p_pdt_id IN NUMBER) IS

Line 123: attribute15 okl_k_lines.attribute15%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
127: SELECT NAME,

Line 1858: FROM okl_k_lines_full_v

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: --Bug# 9838432: Added parameter cp_kle_id

Line 3679: FROM okl_k_lines_full_v

3675:
3676: -- get the residual value for the fin asset
3677: CURSOR l_linesfullv_csr(p_fin_asset_id IN NUMBER) IS
3678: SELECT name, NVL(residual_value,0) --girao bug 4106216 NVL the residual value
3679: FROM okl_k_lines_full_v
3680: WHERE id = p_fin_asset_id;
3681:
3682: --SECHAWLA 10-FEB-06 5016156
3683: --Bug# 9838432: Added parameter cp_kle_id