40: party_id1 OKC_K_PARTY_ROLES_V.object1_id1%type,
41: party_id2 OKC_K_PARTY_ROLES_V.object1_id2%type,
42: effective_from okc_k_lines_b.start_date%type,
43: effective_to okc_k_lines_b.end_date%type,
44: amount okl_k_lines.amount%type,
45: initial_direct_cost okl_k_lines.initial_direct_cost%type,
46: roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type,
47: qte_id okl_k_lines.qte_id%type,
48: FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
41: party_id2 OKC_K_PARTY_ROLES_V.object1_id2%type,
42: effective_from okc_k_lines_b.start_date%type,
43: effective_to okc_k_lines_b.end_date%type,
44: amount okl_k_lines.amount%type,
45: initial_direct_cost okl_k_lines.initial_direct_cost%type,
46: roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type,
47: qte_id okl_k_lines.qte_id%type,
48: FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
49: FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
43: effective_to okc_k_lines_b.end_date%type,
44: amount okl_k_lines.amount%type,
45: initial_direct_cost okl_k_lines.initial_direct_cost%type,
46: roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type,
47: qte_id okl_k_lines.qte_id%type,
48: FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
49: FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
50: --Bug# 4558486
51: attribute_category okl_k_lines.attribute_category%type,
44: amount okl_k_lines.amount%type,
45: initial_direct_cost okl_k_lines.initial_direct_cost%type,
46: roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type,
47: qte_id okl_k_lines.qte_id%type,
48: FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
49: FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
50: --Bug# 4558486
51: attribute_category okl_k_lines.attribute_category%type,
52: attribute1 okl_k_lines.attribute1%type,
45: initial_direct_cost okl_k_lines.initial_direct_cost%type,
46: roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type,
47: qte_id okl_k_lines.qte_id%type,
48: FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
49: FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
50: --Bug# 4558486
51: attribute_category okl_k_lines.attribute_category%type,
52: attribute1 okl_k_lines.attribute1%type,
53: attribute2 okl_k_lines.attribute2%type,
47: qte_id okl_k_lines.qte_id%type,
48: FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
49: FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
50: --Bug# 4558486
51: attribute_category okl_k_lines.attribute_category%type,
52: attribute1 okl_k_lines.attribute1%type,
53: attribute2 okl_k_lines.attribute2%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
48: FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
49: FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
50: --Bug# 4558486
51: attribute_category okl_k_lines.attribute_category%type,
52: attribute1 okl_k_lines.attribute1%type,
53: attribute2 okl_k_lines.attribute2%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
49: FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
50: --Bug# 4558486
51: attribute_category okl_k_lines.attribute_category%type,
52: attribute1 okl_k_lines.attribute1%type,
53: attribute2 okl_k_lines.attribute2%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
50: --Bug# 4558486
51: attribute_category okl_k_lines.attribute_category%type,
52: attribute1 okl_k_lines.attribute1%type,
53: attribute2 okl_k_lines.attribute2%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
51: attribute_category okl_k_lines.attribute_category%type,
52: attribute1 okl_k_lines.attribute1%type,
53: attribute2 okl_k_lines.attribute2%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
52: attribute1 okl_k_lines.attribute1%type,
53: attribute2 okl_k_lines.attribute2%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
53: attribute2 okl_k_lines.attribute2%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
54: attribute3 okl_k_lines.attribute3%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
55: attribute4 okl_k_lines.attribute4%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
56: attribute5 okl_k_lines.attribute5%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
64: attribute13 okl_k_lines.attribute13%type,
57: attribute6 okl_k_lines.attribute6%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
64: attribute13 okl_k_lines.attribute13%type,
65: attribute14 okl_k_lines.attribute14%type,
58: attribute7 okl_k_lines.attribute7%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
64: attribute13 okl_k_lines.attribute13%type,
65: attribute14 okl_k_lines.attribute14%type,
66: attribute15 okl_k_lines.attribute15%type,
59: attribute8 okl_k_lines.attribute8%type,
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
64: attribute13 okl_k_lines.attribute13%type,
65: attribute14 okl_k_lines.attribute14%type,
66: attribute15 okl_k_lines.attribute15%type,
67: validate_dff_yn VARCHAR2(3),
60: attribute9 okl_k_lines.attribute9%type,
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
64: attribute13 okl_k_lines.attribute13%type,
65: attribute14 okl_k_lines.attribute14%type,
66: attribute15 okl_k_lines.attribute15%type,
67: validate_dff_yn VARCHAR2(3),
68: --Added by JJUNEJA
61: attribute10 okl_k_lines.attribute10%type,
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
64: attribute13 okl_k_lines.attribute13%type,
65: attribute14 okl_k_lines.attribute14%type,
66: attribute15 okl_k_lines.attribute15%type,
67: validate_dff_yn VARCHAR2(3),
68: --Added by JJUNEJA
69: origination_income okl_k_lines.origination_income%TYPE
62: attribute11 okl_k_lines.attribute11%type,
63: attribute12 okl_k_lines.attribute12%type,
64: attribute13 okl_k_lines.attribute13%type,
65: attribute14 okl_k_lines.attribute14%type,
66: attribute15 okl_k_lines.attribute15%type,
67: validate_dff_yn VARCHAR2(3),
68: --Added by JJUNEJA
69: origination_income okl_k_lines.origination_income%TYPE
70: --ENd of addition by JJUNEJA
65: attribute14 okl_k_lines.attribute14%type,
66: attribute15 okl_k_lines.attribute15%type,
67: validate_dff_yn VARCHAR2(3),
68: --Added by JJUNEJA
69: origination_income okl_k_lines.origination_income%TYPE
70: --ENd of addition by JJUNEJA
71:
72: );
73: TYPE fee_types_tbl_type is table of fee_types_rec_type INDEX BY BINARY_INTEGER;
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
298: p_qte_id IN OKL_K_LINES.QTE_ID%TYPE,
299: p_for_qa_check IN BOOLEAN DEFAULT FALSE);
300:
301: -------------------------------------------------
302: -- Create By smereddy 30-Aug-2004