DBA Data[Home] [Help]

APPS.OKL_SUPP_INVOICE_DTLS_PVT dependencies on OKC_K_LINES_B

Line 33: p_asset_id IN okc_k_lines_b.id%TYPE,

29:
30: PROCEDURE raise_business_event(p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2,
32: p_chr_id IN okc_k_headers_b.id%TYPE,
33: p_asset_id IN okc_k_lines_b.id%TYPE,
34: p_vendor_id IN po_vendors.vendor_id%TYPE,
35: p_event_name IN VARCHAR2,
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,

Line 86: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS

82: /*
83: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id
84: * to pass the parameters to the business event. BEGIN
85: */
86: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS
87: SELECT dnz_chr_id, cle_id
88: FROM okc_k_lines_b
89: WHERE id = p_cle_id;
90:

Line 88: FROM okc_k_lines_b

84: * to pass the parameters to the business event. BEGIN
85: */
86: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS
87: SELECT dnz_chr_id, cle_id
88: FROM okc_k_lines_b
89: WHERE id = p_cle_id;
90:
91: --vthiruva Fix Bug#4047076 27-Dec-04
92: --Added cursor to fetch the vendor id to pass to business events

Line 94: p_cle_id okc_k_lines_b.id%TYPE) IS

90:
91: --vthiruva Fix Bug#4047076 27-Dec-04
92: --Added cursor to fetch the vendor id to pass to business events
93: CURSOR get_vendor_id(p_chr_id okc_k_headers_b.id%TYPE,
94: p_cle_id okc_k_lines_b.id%TYPE) IS
95: SELECT object1_id1 vendor_id
96: FROM okc_k_party_roles_b
97: WHERE dnz_chr_id = p_chr_id
98: AND cle_id = p_cle_id

Line 102: l_cle_id okc_k_lines_b.id%TYPE;

98: AND cle_id = p_cle_id
99: AND rle_code = 'OKL_VENDOR';
100:
101: l_chr_id okc_k_headers_b.id%TYPE;
102: l_cle_id okc_k_lines_b.id%TYPE;
103: l_vendor_id po_vendors.vendor_id%TYPE;
104: /*
105: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id
106: * to pass the parameters to the business event. END

Line 389: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS

385: /*
386: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id
387: * to pass the parameters to the business event. BEGIN
388: */
389: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS
390: SELECT a.dnz_chr_id, a.cle_id, b.cle_id
391: FROM okc_k_lines_b a,
392: okl_supp_invoice_dtls b
393: WHERE a.id = b.cle_id

Line 391: FROM okc_k_lines_b a,

387: * to pass the parameters to the business event. BEGIN
388: */
389: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS
390: SELECT a.dnz_chr_id, a.cle_id, b.cle_id
391: FROM okc_k_lines_b a,
392: okl_supp_invoice_dtls b
393: WHERE a.id = b.cle_id
394: AND b.id = p_cle_id;
395:

Line 399: p_cle_id okc_k_lines_b.id%TYPE) IS

395:
396: --vthiruva Fix Bug#4047076..27-Dec-04
397: --Added cursor to fetch the vendor id to pass to business events
398: CURSOR get_vendor_id(p_chr_id okc_k_headers_b.id%TYPE,
399: p_cle_id okc_k_lines_b.id%TYPE) IS
400: SELECT object1_id1 vendor_id
401: FROM okc_k_party_roles_b
402: WHERE dnz_chr_id = p_chr_id
403: AND cle_id = p_cle_id

Line 407: l_cle_id okc_k_lines_b.id%TYPE;

403: AND cle_id = p_cle_id
404: AND rle_code = 'OKL_VENDOR';
405:
406: l_chr_id okc_k_headers_b.id%TYPE;
407: l_cle_id okc_k_lines_b.id%TYPE;
408: l_supp_inv_ln_id okc_k_lines_b.id%TYPE;
409: l_vendor_id po_vendors.vendor_id%TYPE;
410: /*
411: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id

Line 408: l_supp_inv_ln_id okc_k_lines_b.id%TYPE;

404: AND rle_code = 'OKL_VENDOR';
405:
406: l_chr_id okc_k_headers_b.id%TYPE;
407: l_cle_id okc_k_lines_b.id%TYPE;
408: l_supp_inv_ln_id okc_k_lines_b.id%TYPE;
409: l_vendor_id po_vendors.vendor_id%TYPE;
410: /*
411: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id
412: * to pass the parameters to the business event. END