APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on QP_LDETS_V

Line 4101: p_ldets_rec IN qp_ldets_v%rowtype,

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
4105: )

Line 4790: p_ldets_rec IN qp_ldets_v%rowtype,

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: )
4794: IS

Line 5311: p_ldets_rec IN qp_ldets_v%rowtype,

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: )
5315: IS

Line 5729: FROM qp_ldets_v

5725: WHERE qp_list_header_id = p_list_header_id;
5726:
5727: CURSOR line_ldets_tbl_csr(p_index IN NUMBER) IS
5728: SELECT *
5729: FROM qp_ldets_v
5730: WHERE line_index = p_index
5731: ORDER BY list_line_id asc;
5732: --ORDER BY pricing_group_sequence;
5733:

Line 5738: l_ldets_rec qp_ldets_v%rowtype;

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;
5742: l_api_name CONSTANT VARCHAR2(30) := 'Process_Pricing_Result';

Line 5825: ozf_utility_pvt.write_conc_log(l_api_name||' >> qp_ldets_v (+)');

5821: -- END IF;
5822:
5823:
5824: IF g_debug_flag = 'Y' THEN
5825: ozf_utility_pvt.write_conc_log(l_api_name||' >> qp_ldets_v (+)');
5826: ozf_utility_pvt.write_conc_log('l_ldets_tbl('||k||').list_header_id = '|| l_ldets_tbl(k).list_header_id);
5827: ozf_utility_pvt.write_conc_log('l_ldets_tbl('||k||').list_line_type_code = '|| l_ldets_tbl(k).list_line_type_code);
5828: ozf_utility_pvt.write_conc_log('l_ldets_tbl('||k||').applied_flag = '|| l_ldets_tbl(k).applied_flag);
5829: ozf_utility_pvt.write_conc_log('l_ldets_tbl('||k||').accrual_flag = '|| l_ldets_tbl(k).accrual_flag);

Line 5833: ozf_utility_pvt.write_conc_log(l_api_name||' >> qp_ldets_v (-)');

5829: ozf_utility_pvt.write_conc_log('l_ldets_tbl('||k||').accrual_flag = '|| l_ldets_tbl(k).accrual_flag);
5830: ozf_utility_pvt.write_conc_log('l_ldets_tbl('||k||').automatic_flag = '|| l_ldets_tbl(k).automatic_flag);
5831: ozf_utility_pvt.write_conc_log('p_line_tbl('||i||').line_id = '|| p_line_tbl(i).line_id);
5832: ozf_utility_pvt.write_conc_log('l_ldets_tbl('||k||').list_line_id = '|| l_ldets_tbl(k).list_line_id);
5833: ozf_utility_pvt.write_conc_log(l_api_name||' >> qp_ldets_v (-)');
5834: END IF;
5835:
5836: IF l_ldets_tbl(k).list_line_type_code IN ('CIE', 'DIS', 'IUE', 'OID', 'PLL', 'PMR', 'TSN','PBH') THEN
5837: -- create utilization based on an offer