DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_QP_PKG

Line 49: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;

45: l_elems_tbl_out OKS_SUBSCR_ELEMS_PVT.scev_tbl_type;
46: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
47: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
48: -- Pricing Parameters
49: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
50: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;
51: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
52: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
53: -- Pricing Parameters

Line 50: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;

46: l_pattern_tbl OKS_SUBSCRIPTION_SCH_PVT.pattern_tbl;
47: l_delivery_tbl OKS_SUBSCRIPTION_SCH_PVT.del_tbl;
48: -- Pricing Parameters
49: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
50: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;
51: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
52: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
53: -- Pricing Parameters
54: g_chr_id Number;

Line 52: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;

48: -- Pricing Parameters
49: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
50: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;
51: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
52: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
53: -- Pricing Parameters
54: g_chr_id Number;
55: l_start_date Date;
56: l_end_date Date;

Line 481: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;

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;
483: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
484: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
485: -- Pricing Parameters

Line 482: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;

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;
483: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
484: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
485: -- Pricing Parameters
486: g_chr_id Number;

Line 484: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_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;
483: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
484: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
485: -- Pricing Parameters
486: g_chr_id Number;
487: l_start_date Date;
488: l_end_date Date;

Line 1032: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;

1028: From okc_k_lines_b
1029: Where id = p_source_cle_id
1030: And lse_id = 46;
1031: -- Pricing Parameters
1032: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
1033: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;
1034: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1035: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1036: -- Pricing Parameters

Line 1033: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;

1029: Where id = p_source_cle_id
1030: And lse_id = 46;
1031: -- Pricing Parameters
1032: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
1033: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;
1034: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1035: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1036: -- Pricing Parameters
1037: g_chr_id Number;

Line 1035: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;

1031: -- Pricing Parameters
1032: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;
1033: x_price_details_out OKS_QP_PKG.PRICE_DETAILS;
1034: x_mo_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1035: x_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1036: -- Pricing Parameters
1037: g_chr_id Number;
1038: g_osh_id Number;
1039: l_instance_id Number;