DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCR_HDR_PVT

Line 40: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;

36: item_type
37: From oks_subscr_header_v
38: Where id = p_template_id;
39:
40: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;
41: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;
42: l_ptrns_tbl_in OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
43: l_ptrns_tbl_out OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
44: l_elems_tbl_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;

Line 41: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;

37: From oks_subscr_header_v
38: Where id = p_template_id;
39:
40: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;
41: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;
42: l_ptrns_tbl_in OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
43: l_ptrns_tbl_out OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type;
44: l_elems_tbl_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
45: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;

Line 477: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;

473: l_elems_tbl_del_in OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
474: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
475: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
476: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
477: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;
478: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;
479: tmp_elem_tbl tel_tbl_type;
480: -- Pricing Parameters
481: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;

Line 478: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;

474: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
475: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
476: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
477: l_hdr_tbl_in OKS_SUBSCR_HDR_PVT.schv_tbl_type;
478: l_hdr_tbl_out OKS_SUBSCR_HDR_PVT.schv_tbl_type;
479: tmp_elem_tbl tel_tbl_type;
480: -- Pricing Parameters
481: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
482: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;