APPS.OKS_OC_INT_KTO_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1340: l_ord_creation_date oe_order_headers_all.creation_date%TYPE;

1336: l_order_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1337: l_order_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1338:
1339: --
1340: l_ord_creation_date oe_order_headers_all.creation_date%TYPE;
1341: l_ord_num oe_order_headers_all.order_number%TYPE;
1342: l_ord_version_number oe_order_headers_all.version_number%TYPE;
1343: l_ord_expiration_date oe_order_headers_all.expiration_date%TYPE;
1344: l_kto_found varchar2(1);

Line 1341: l_ord_num oe_order_headers_all.order_number%TYPE;

1337: l_order_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1338:
1339: --
1340: l_ord_creation_date oe_order_headers_all.creation_date%TYPE;
1341: l_ord_num oe_order_headers_all.order_number%TYPE;
1342: l_ord_version_number oe_order_headers_all.version_number%TYPE;
1343: l_ord_expiration_date oe_order_headers_all.expiration_date%TYPE;
1344: l_kto_found varchar2(1);
1345: l_elements_found varchar2(1):='N';

Line 1342: l_ord_version_number oe_order_headers_all.version_number%TYPE;

1338:
1339: --
1340: l_ord_creation_date oe_order_headers_all.creation_date%TYPE;
1341: l_ord_num oe_order_headers_all.order_number%TYPE;
1342: l_ord_version_number oe_order_headers_all.version_number%TYPE;
1343: l_ord_expiration_date oe_order_headers_all.expiration_date%TYPE;
1344: l_kto_found varchar2(1);
1345: l_elements_found varchar2(1):='N';
1346:

Line 1343: l_ord_expiration_date oe_order_headers_all.expiration_date%TYPE;

1339: --
1340: l_ord_creation_date oe_order_headers_all.creation_date%TYPE;
1341: l_ord_num oe_order_headers_all.order_number%TYPE;
1342: l_ord_version_number oe_order_headers_all.version_number%TYPE;
1343: l_ord_expiration_date oe_order_headers_all.expiration_date%TYPE;
1344: l_kto_found varchar2(1);
1345: l_elements_found varchar2(1):='N';
1346:
1347: ---cursor for getting the subscription details

Line 1771: FROM oe_order_headers_all

1767: INTO l_ord_creation_date,
1768: l_ord_num,
1769: l_ord_version_number,
1770: l_ord_expiration_date
1771: FROM oe_order_headers_all
1772: WHERE header_id = lx_order_header_rec.order_header_id;
1773:
1774: OKC_API.set_message(p_app_name => g_app_name,
1775: p_msg_name => 'OKS_K2O_K2OCOMMENTS',