DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_K_LINES_B

Line 109: l_s_cle_id okc_k_lines_b.id%type := null;

105: and sty_name = p_item_name;
106:
107: l_chr_id okc_k_headers_b.id%type := null;
108: l_s_chr_id okc_k_headers_b.id%type := null;
109: l_s_cle_id okc_k_lines_b.id%type := null;
110: l_supp_id okx_vendors_v.id1%type := null;
111: x_okl_cle_id okc_k_lines_b.id%type := null;
112: l_rel_vers_id number := null;
113: l_strmtyp_id okl_strm_tmpt_full_uv.sty_id%type := null;

Line 111: x_okl_cle_id okc_k_lines_b.id%type := null;

107: l_chr_id okc_k_headers_b.id%type := null;
108: l_s_chr_id okc_k_headers_b.id%type := null;
109: l_s_cle_id okc_k_lines_b.id%type := null;
110: l_supp_id okx_vendors_v.id1%type := null;
111: x_okl_cle_id okc_k_lines_b.id%type := null;
112: l_rel_vers_id number := null;
113: l_strmtyp_id okl_strm_tmpt_full_uv.sty_id%type := null;
114: l_sts_code OKC_K_HEADERS_B.sts_code%type:= null;
115: l_ste_code OKC_STATUSES_B.STE_CODE%type:= null;

Line 391: l_s_cle_id okc_k_lines_b.id%type := null;

387: where name = p_supplier_name;
388:
389: l_chr_id okc_k_headers_b.id%type := null;
390: l_s_chr_id okc_k_headers_b.id%type := null;
391: l_s_cle_id okc_k_lines_b.id%type := null;
392: l_supp_id okx_vendors_v.id1%type := null;
393: x_okl_cle_id okc_k_lines_b.id%type := null;
394: l_rel_vers_id number := null;
395:

Line 393: x_okl_cle_id okc_k_lines_b.id%type := null;

389: l_chr_id okc_k_headers_b.id%type := null;
390: l_s_chr_id okc_k_headers_b.id%type := null;
391: l_s_cle_id okc_k_lines_b.id%type := null;
392: l_supp_id okx_vendors_v.id1%type := null;
393: x_okl_cle_id okc_k_lines_b.id%type := null;
394: l_rel_vers_id number := null;
395:
396: lp_clev_rec OKL_SERVICE_INTEGRATION_PUB.clev_rec_type;
397: lp_klev_rec OKL_SERVICE_INTEGRATION_PUB.klev_rec_type;

Line 973: FROM okc_k_lines_b cle

969:
970: -- Bug# 6438785
971: CURSOR c_orig_cle_csr(p_cle_id IN NUMBER) IS
972: SELECT cle.start_date
973: FROM okc_k_lines_b cle
974: WHERE cle.id = p_cle_id;
975:
976: l_orig_cle_rec c_orig_cle_csr%ROWTYPE;
977:

Line 984: FROM okc_k_lines_b cle

980: p_chr_id IN NUMBER) IS
981: SELECT cle.id,
982: cle.start_date,
983: cle.end_date
984: FROM okc_k_lines_b cle
985: WHERE cle.cle_id = p_cle_id
986: AND cle.dnz_chr_id = p_chr_id;
987:
988: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 1781: p_line_id OKC_K_LINES_B.ID%TYPE) IS

1777: FROM okc_k_headers_b head
1778: WHERE head.id = p_chr_id ;
1779:
1780: CURSOR strm_cap_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1781: p_line_id OKC_K_LINES_B.ID%TYPE) IS
1782: SELECT stream.capitalize_yn
1783: FROM okl_k_lines_full_v line,
1784: okc_k_items_v item,
1785: okl_strmtyp_source_v stream

Line 1799: l_start_date OKC_K_lineS_B.START_DATE%TYPE;

1795: AND status = 'A'
1796: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
1797: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
1798:
1799: l_start_date OKC_K_lineS_B.START_DATE%TYPE;
1800: l_end_date OKC_K_lineS_B.END_DATE%TYPE;
1801: l_amount NUMBER;
1802: l_capital_amount NUMBER;
1803: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;

Line 1800: l_end_date OKC_K_lineS_B.END_DATE%TYPE;

1796: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
1797: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
1798:
1799: l_start_date OKC_K_lineS_B.START_DATE%TYPE;
1800: l_end_date OKC_K_lineS_B.END_DATE%TYPE;
1801: l_amount NUMBER;
1802: l_capital_amount NUMBER;
1803: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
1804: l_fee_type OKL_K_LINES.FEE_TYPE%TYPE := null;

Line 2194: FROM okc_k_lines_b line,

2190: l_api_version NUMBER := 1.0;
2191:
2192: CURSOR line_style_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
2193: SELECT style.lty_code
2194: FROM okc_k_lines_b line,
2195: okc_line_styles_b style
2196: WHERE line.lse_id = style.id
2197: AND line.id = p_line_id;
2198: