DBA Data[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 567: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

563: l_error_location NUMBER;
564: l_line_ctr NUMBER := 1;
565: l_adj_amount NUMBER := 0;
566:
567: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
568: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
569: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
570: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
571: l_order_line_tbl order_line_tbl_type;

Line 568: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

564: l_line_ctr NUMBER := 1;
565: l_adj_amount NUMBER := 0;
566:
567: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
568: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
569: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
570: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
571: l_order_line_tbl order_line_tbl_type;
572:

Line 1056: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1052:
1053:
1054:
1055: l_offer_info c_offer_info%ROWTYPE;
1056: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1057: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1058: l_cust_number NUMBER;
1059: l_order_line_tbl order_line_tbl_type;
1060: l_req_line_attrs_tbl qp_runtime_source.accum_req_line_attrs_tbl;

Line 1057: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1053:
1054:
1055: l_offer_info c_offer_info%ROWTYPE;
1056: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1057: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1058: l_cust_number NUMBER;
1059: l_order_line_tbl order_line_tbl_type;
1060: l_req_line_attrs_tbl qp_runtime_source.accum_req_line_attrs_tbl;
1061: l_index NUMBER := 1;

Line 2075: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2071: x_msg_count OUT NOCOPY NUMBER,
2072: x_msg_data OUT NOCOPY VARCHAR2
2073: ) IS
2074: l_act_budget_id NUMBER;
2075: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2076: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2077: l_return_status VARCHAR2 (1);
2078: l_util_amount NUMBER;
2079: l_api_name VARCHAR2 (50) := 'perform_adjustment';

Line 2076: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

2072: x_msg_data OUT NOCOPY VARCHAR2
2073: ) IS
2074: l_act_budget_id NUMBER;
2075: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2076: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2077: l_return_status VARCHAR2 (1);
2078: l_util_amount NUMBER;
2079: l_api_name VARCHAR2 (50) := 'perform_adjustment';
2080: l_full_name CONSTANT VARCHAR2 (90) := g_pkg_name

Line 2901: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

2897: ----------------------------------------------------------------------
2898: PROCEDURE process_accrual (
2899: p_earned_amt IN NUMBER,
2900: p_qp_list_header_id IN NUMBER,
2901: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2902: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type:= NULL,
2903: x_return_status OUT NOCOPY VARCHAR2,
2904: x_msg_count OUT NOCOPY NUMBER,
2905: x_msg_data OUT NOCOPY VARCHAR2);

Line 2902: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type:= NULL,

2898: PROCEDURE process_accrual (
2899: p_earned_amt IN NUMBER,
2900: p_qp_list_header_id IN NUMBER,
2901: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2902: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type:= NULL,
2903: x_return_status OUT NOCOPY VARCHAR2,
2904: x_msg_count OUT NOCOPY NUMBER,
2905: x_msg_data OUT NOCOPY VARCHAR2);
2906:

Line 3077: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

3073: ----------------------------------------------------------------------
3074: PROCEDURE process_accrual (
3075: p_earned_amt IN NUMBER,
3076: p_qp_list_header_id IN NUMBER,
3077: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
3078: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type := NULL,
3079: x_return_status OUT NOCOPY VARCHAR2,
3080: x_msg_count OUT NOCOPY NUMBER,
3081: x_msg_data OUT NOCOPY VARCHAR2

Line 3078: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type := NULL,

3074: PROCEDURE process_accrual (
3075: p_earned_amt IN NUMBER,
3076: p_qp_list_header_id IN NUMBER,
3077: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
3078: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type := NULL,
3079: x_return_status OUT NOCOPY VARCHAR2,
3080: x_msg_count OUT NOCOPY NUMBER,
3081: x_msg_data OUT NOCOPY VARCHAR2
3082: ) IS

Line 3086: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;

3082: ) IS
3083: l_fund_amt_tbl ozf_accrual_engine.ozf_fund_amt_tbl_type;
3084: l_api_name VARCHAR2(30):= 'process_accrual';
3085: l_full_name VARCHAR2(60):= g_pkg_name ||'.'||l_api_name||' : ' ;
3086: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
3087: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
3088: l_earned_amount NUMBER;
3089: l_old_earned_amount NUMBER;
3090: l_header_id NUMBER; -- order or invoice id

Line 3087: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;

3083: l_fund_amt_tbl ozf_accrual_engine.ozf_fund_amt_tbl_type;
3084: l_api_name VARCHAR2(30):= 'process_accrual';
3085: l_full_name VARCHAR2(60):= g_pkg_name ||'.'||l_api_name||' : ' ;
3086: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
3087: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
3088: l_earned_amount NUMBER;
3089: l_old_earned_amount NUMBER;
3090: l_header_id NUMBER; -- order or invoice id
3091: l_line_id NUMBER; -- order or invoice id

Line 3912: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

3908: l_old_operator VARCHAR2(30);
3909: y1 NUMBER; -- Initial Adjsutment
3910: l_current_max_tier NUMBER;
3911: l_current_min_tier NUMBER;
3912: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
3913: l_adj_amount NUMBER;
3914: l_volume_type VARCHAR2(30);
3915: l_current_tier_value NUMBER;
3916: l_total NUMBER;

Line 4884: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

4880: l_invoice_to_org_id NUMBER;
4881: l_ship_to_org_id NUMBER;
4882: l_cust_number NUMBER;
4883: l_act_budget_id NUMBER;
4884: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4885: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
4886: l_offer_info c_offer_info%ROWTYPE;
4887: l_order_line_info c_order_line_info%ROWTYPE;
4888: l_amountTbl amountTbl ;

Line 4885: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

4881: l_ship_to_org_id NUMBER;
4882: l_cust_number NUMBER;
4883: l_act_budget_id NUMBER;
4884: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4885: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
4886: l_offer_info c_offer_info%ROWTYPE;
4887: l_order_line_info c_order_line_info%ROWTYPE;
4888: l_amountTbl amountTbl ;
4889: l_objectTypeTbl objectTypeTbl ;