DBA Data[Home] [Help]

APPS.OKS_QP_INT_PVT dependencies on OKS_QP_PKG

Line 1667: p_detail_rec IN oks_qp_pkg.input_details,

1663: RAISE;
1664: END qualifier_account_merge;
1665:
1666: PROCEDURE calculate_subscription_price (
1667: p_detail_rec IN oks_qp_pkg.input_details,
1668: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
1669: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
1670: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
1671: x_return_status OUT NOCOPY VARCHAR2,

Line 1668: x_price_details OUT NOCOPY oks_qp_pkg.price_details,

1664: END qualifier_account_merge;
1665:
1666: PROCEDURE calculate_subscription_price (
1667: p_detail_rec IN oks_qp_pkg.input_details,
1668: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
1669: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
1670: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
1671: x_return_status OUT NOCOPY VARCHAR2,
1672: x_msg_count OUT NOCOPY NUMBER,

Line 1670: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,

1666: PROCEDURE calculate_subscription_price (
1667: p_detail_rec IN oks_qp_pkg.input_details,
1668: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
1669: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
1670: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
1671: x_return_status OUT NOCOPY VARCHAR2,
1672: x_msg_count OUT NOCOPY NUMBER,
1673: x_msg_data OUT NOCOPY VARCHAR2
1674: )

Line 1733: l_input_detail_rec oks_qp_pkg.input_details

1729: FROM oks_subscr_elements
1730: WHERE dnz_cle_id = p_line_id;
1731:
1732: l_line_details_rec l_line_details_csr%ROWTYPE;
1733: l_input_detail_rec oks_qp_pkg.input_details
1734: := p_detail_rec;
1735: l_rail_rec oks_tax_util_pvt.ra_rec_type;
1736: l_k_det_rec k_details_rec;
1737: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;

Line 1936: oks_qp_pkg.calc_price

1932: );
1933: END IF;
1934:
1935: --errorout('Asking price = '||l_input_detail_rec.asking_unit_price);
1936: oks_qp_pkg.calc_price
1937: (p_detail_rec => l_input_detail_rec,
1938: x_price_details => x_price_details,
1939: x_modifier_details => x_modifier_details,
1940: x_price_break_details => x_price_break_details,

Line 2021: oks_qp_pkg.calc_price

2017: x_price_details.prod_priced_qty := NULL;
2018: x_price_details.prod_priced_uom := NULL;
2019: END IF;
2020: ELSE
2021: oks_qp_pkg.calc_price
2022: (p_detail_rec => l_input_detail_rec,
2023: x_price_details => x_price_details,
2024: x_modifier_details => x_modifier_details,
2025: x_price_break_details => x_price_break_details,

Line 2606: p_detail_rec IN oks_qp_pkg.input_details,

2602: );
2603: END calculate_subscription_price;
2604:
2605: PROCEDURE calculate_subline_price (
2606: p_detail_rec IN oks_qp_pkg.input_details,
2607: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
2608: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
2609: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
2610: x_return_status OUT NOCOPY VARCHAR2,

Line 2607: x_price_details OUT NOCOPY oks_qp_pkg.price_details,

2603: END calculate_subscription_price;
2604:
2605: PROCEDURE calculate_subline_price (
2606: p_detail_rec IN oks_qp_pkg.input_details,
2607: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
2608: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
2609: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
2610: x_return_status OUT NOCOPY VARCHAR2,
2611: x_msg_count OUT NOCOPY NUMBER,

Line 2609: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,

2605: PROCEDURE calculate_subline_price (
2606: p_detail_rec IN oks_qp_pkg.input_details,
2607: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
2608: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
2609: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
2610: x_return_status OUT NOCOPY VARCHAR2,
2611: x_msg_count OUT NOCOPY NUMBER,
2612: x_msg_data OUT NOCOPY VARCHAR2
2613: )

Line 2677: l_input_detail_rec oks_qp_pkg.input_details

2673: l_num_items NUMBER;
2674: l_duration_qty NUMBER;
2675: l_cpuom_code VARCHAR2 (200);
2676: l_line_details_rec l_line_details_csr%ROWTYPE;
2677: l_input_detail_rec oks_qp_pkg.input_details
2678: := p_detail_rec;
2679: l_rail_rec oks_tax_util_pvt.ra_rec_type;
2680: l_k_det_rec k_details_rec;
2681: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;

Line 2828: oks_qp_pkg.calc_price

2824:
2825: IF NVL (fnd_profile.VALUE ('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') =
2826: 'YES'
2827: THEN
2828: oks_qp_pkg.calc_price
2829: (p_detail_rec => l_input_detail_rec,
2830: x_price_details => x_price_details,
2831: x_modifier_details => x_modifier_details,
2832: x_price_break_details => x_price_break_details,

Line 2876: oks_qp_pkg.calc_price

2872: );
2873: END IF;
2874:
2875: --errorout('Asking price : ' || l_input_detail_rec.asking_unit_price);
2876: oks_qp_pkg.calc_price
2877: (p_detail_rec => l_input_detail_rec,
2878: x_price_details => x_price_details,
2879: x_modifier_details => x_modifier_details,
2880: x_price_break_details => x_price_break_details,

Line 3031: oks_qp_pkg.calc_price

3027: x_price_details.serv_qty := NULL;
3028: x_price_details.serv_priced_uom := NULL;
3029: END IF;
3030: ELSE
3031: oks_qp_pkg.calc_price
3032: (p_detail_rec => l_input_detail_rec,
3033: x_price_details => x_price_details,
3034: x_modifier_details => x_modifier_details,
3035: x_price_break_details => x_price_break_details,

Line 3324: p_detail_rec IN oks_qp_pkg.input_details,

3320: );
3321: END calculate_subline_price;
3322:
3323: PROCEDURE calculate_topline_price (
3324: p_detail_rec IN oks_qp_pkg.input_details,
3325: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
3326: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
3327: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
3328: x_return_status OUT NOCOPY VARCHAR2,

Line 3325: x_price_details OUT NOCOPY oks_qp_pkg.price_details,

3321: END calculate_subline_price;
3322:
3323: PROCEDURE calculate_topline_price (
3324: p_detail_rec IN oks_qp_pkg.input_details,
3325: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
3326: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
3327: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
3328: x_return_status OUT NOCOPY VARCHAR2,
3329: x_msg_count OUT NOCOPY NUMBER,

Line 3327: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,

3323: PROCEDURE calculate_topline_price (
3324: p_detail_rec IN oks_qp_pkg.input_details,
3325: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
3326: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
3327: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
3328: x_return_status OUT NOCOPY VARCHAR2,
3329: x_msg_count OUT NOCOPY NUMBER,
3330: x_msg_data OUT NOCOPY VARCHAR2
3331: )

Line 3351: l_input_detail_rec oks_qp_pkg.input_details;

3347: AND date_cancelled IS NULL --[llc]
3348: AND date_terminated IS NULL -- bug 5504157
3349: ORDER BY line_number;
3350:
3351: l_input_detail_rec oks_qp_pkg.input_details;
3352: l_rail_rec oks_tax_util_pvt.ra_rec_type;
3353: l_k_det_rec k_details_rec;
3354: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
3355: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;

Line 3442: oks_qp_pkg.calc_price

3438: RAISE g_exc_cant_price;
3439: END IF;
3440:
3441: /** **/
3442: oks_qp_pkg.calc_price
3443: (p_detail_rec => l_input_detail_rec,
3444: x_price_details => x_price_details,
3445: x_modifier_details => x_modifier_details,
3446: x_price_break_details => x_price_break_details,

Line 3887: p_detail_rec IN oks_qp_pkg.input_details,

3883: );
3884: END calculate_topline_price;
3885:
3886: PROCEDURE calculate_hdr_price (
3887: p_detail_rec IN oks_qp_pkg.input_details,
3888: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
3889: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
3890: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
3891: x_return_status OUT NOCOPY VARCHAR2,

Line 3888: x_price_details OUT NOCOPY oks_qp_pkg.price_details,

3884: END calculate_topline_price;
3885:
3886: PROCEDURE calculate_hdr_price (
3887: p_detail_rec IN oks_qp_pkg.input_details,
3888: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
3889: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
3890: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
3891: x_return_status OUT NOCOPY VARCHAR2,
3892: x_msg_count OUT NOCOPY NUMBER,

Line 3890: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,

3886: PROCEDURE calculate_hdr_price (
3887: p_detail_rec IN oks_qp_pkg.input_details,
3888: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
3889: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
3890: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
3891: x_return_status OUT NOCOPY VARCHAR2,
3892: x_msg_count OUT NOCOPY NUMBER,
3893: x_msg_data OUT NOCOPY VARCHAR2
3894: )

Line 3914: l_input_details oks_qp_pkg.input_details;

3910: AND date_cancelled IS NULL --[llc] bug 4653406
3911: AND date_terminated IS NULL -- bug 5504157
3912: ORDER BY line_number;
3913:
3914: l_input_details oks_qp_pkg.input_details;
3915: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
3916: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
3917: l_k_det_rec k_details_rec;
3918: BEGIN

Line 4128: p_detail_rec IN oks_qp_pkg.input_details,

4124:
4125: PROCEDURE compute_price (
4126: p_api_version IN NUMBER,
4127: p_init_msg_list IN VARCHAR2,
4128: p_detail_rec IN oks_qp_pkg.input_details,
4129: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
4130: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4131: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
4132: x_return_status OUT NOCOPY VARCHAR2,

Line 4129: x_price_details OUT NOCOPY oks_qp_pkg.price_details,

4125: PROCEDURE compute_price (
4126: p_api_version IN NUMBER,
4127: p_init_msg_list IN VARCHAR2,
4128: p_detail_rec IN oks_qp_pkg.input_details,
4129: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
4130: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4131: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
4132: x_return_status OUT NOCOPY VARCHAR2,
4133: x_msg_count OUT NOCOPY NUMBER,

Line 4131: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,

4127: p_init_msg_list IN VARCHAR2,
4128: p_detail_rec IN oks_qp_pkg.input_details,
4129: x_price_details OUT NOCOPY oks_qp_pkg.price_details,
4130: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
4131: x_price_break_details OUT NOCOPY oks_qp_pkg.g_price_break_tbl_type,
4132: x_return_status OUT NOCOPY VARCHAR2,
4133: x_msg_count OUT NOCOPY NUMBER,
4134: x_msg_data OUT NOCOPY VARCHAR2
4135: )

Line 4139: l_input_detail_rec oks_qp_pkg.input_details

4135: )
4136: IS
4137: l_api_name CONSTANT VARCHAR2 (30)
4138: := 'compute_price';
4139: l_input_detail_rec oks_qp_pkg.input_details
4140: := p_detail_rec;
4141: l_k_det_rec k_details_rec;
4142: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
4143: l_chrv_rec_out okc_contract_pub.chrv_rec_type;