[Home] [Help]
1: PACKAGE BODY ozf_adjustment_ext_pvt AS
2: /*$Header: ozfvadeb.pls 120.69.12020000.14 2013/02/19 07:52:48 nepanda ship $*/
3:
4: -----------------------------------------------------------
5: -- PACKAGE
2: /*$Header: ozfvadeb.pls 120.69.12020000.14 2013/02/19 07:52:48 nepanda ship $*/
3:
4: -----------------------------------------------------------
5: -- PACKAGE
6: -- OZF_Adjustment_EXT_PVT
7: --
8: -- PROCEDURES
9: -- adjust_backdated_offer
10: -- process_offer_product
74: -- 12/30/2012 amitamku Bug 15935374 - FAE COMPLETES WITH ERROR FOR VOLUME OFFER WITH MULTIPLE DISCOUNT TABLES
75: -- 01/16/2013 ninarasi Bug 16029659 - OFFER IN TRADE PLANNING CREATING IMPROPER ADJUSTMENTS
76: ---------------------------------------------------------------------------------------------------
77:
78: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Adjustment_Ext_PVT';
79: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
80: g_order_gl_phase CONSTANT VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
81: g_debug_flag VARCHAR2 (1) := 'N';
82: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
2814: l_tbl_index NUMBER := 1;
2815: l_return_status_code varchar2(240);
2816: l_price_return_msg varchar2(240);
2817: l_volume_offer VARCHAR2(1) := 'N';
2818: l_line_tbl OZF_Adjustment_ext_PVT.LINE_REC_TBL_TYPE;
2819: k NUMBER;
2820: l_order_count NUMBER;
2821: l_price_line_flag VARCHAR2(1) := 'N';
2822: l_request_id NUMBER;
4096: -- 2. We will not do third party accruals on tracing data
4097: --
4098: ---------------------------------------------------------------------
4099: PROCEDURE Process_VO_Result(
4100: p_line_rec IN OZF_Adjustment_ext_PVT.LINE_REC_TYPE,
4101: p_ldets_rec IN qp_ldets_v%rowtype,
4102: p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
4103: p_vol_off_type IN VARCHAR2,
4104: x_return_status OUT NOCOPY VARCHAR2
4785: -- 2. We will not do third party accruals on tracing data
4786: --
4787: ---------------------------------------------------------------------
4788: PROCEDURE Process_SSD_Result(
4789: p_line_rec IN OZF_Adjustment_ext_PVT.LINE_REC_TYPE,
4790: p_ldets_rec IN qp_ldets_v%rowtype,
4791: p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
4792: x_return_status OUT NOCOPY VARCHAR2
4793: )
5306: -- 2. We will not do third party accruals on tracing data
5307: --
5308: ---------------------------------------------------------------------
5309: PROCEDURE Process_Result(
5310: p_line_rec IN OZF_Adjustment_ext_PVT.LINE_REC_TYPE,
5311: p_ldets_rec IN qp_ldets_v%rowtype,
5312: p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
5313: x_return_status OUT NOCOPY VARCHAR2
5314: )
5701: -- on the discount information.
5702: --
5703: -- PARAMETERS
5704: -- p_header_id IN NUMBER,
5705: -- p_line_tbl IN OZF_Adjustment_ext_PVT.LINE_REC_TBL_TYPE,
5706: -- x_return_status OUT NOCOPY VARCHAR2
5707: --
5708: -- NOTES
5709: -- 1. Non-monetray accruals have not been considered. Should look INTO ldets.benefit_qty
5711:
5712: ---------------------------------------------------------------------
5713: PROCEDURE Process_Pricing_Result(
5714: p_header_id IN NUMBER,
5715: p_line_tbl IN OZF_Adjustment_ext_PVT.LINE_REC_TBL_TYPE,
5716: p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
5717: x_return_status OUT NOCOPY VARCHAR2
5718: )
5719: IS
5733:
5734: TYPE line_ldets_tbl_type IS TABLE OF line_ldets_tbl_csr%rowtype
5735: INDEX BY binary_integer;
5736:
5737: l_ldets_tbl ozf_adjustment_ext_pvt.LDETS_TBL_TYPE;
5738: l_ldets_rec qp_ldets_v%rowtype;
5739: l_line_rec ozf_adjustment_ext_pvt.LINE_REC_TBL_TYPE;
5740: l_line_id NUMBER := NULL;
5741: l_offer_info c_offer_info%ROWTYPE;
5735: INDEX BY binary_integer;
5736:
5737: l_ldets_tbl ozf_adjustment_ext_pvt.LDETS_TBL_TYPE;
5738: l_ldets_rec qp_ldets_v%rowtype;
5739: l_line_rec ozf_adjustment_ext_pvt.LINE_REC_TBL_TYPE;
5740: l_line_id NUMBER := NULL;
5741: l_offer_info c_offer_info%ROWTYPE;
5742: l_api_name CONSTANT VARCHAR2(30) := 'Process_Pricing_Result';
5743: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
9736:
9737:
9738:
9739:
9740: END ozf_adjustment_ext_pvt;
9741: