342: p_t_line_det IN OUT nocopy QPR_DEAL_PVT.PN_AW_TBL_TYPE)
343: is
344:
345: line_id Number;
346: s_product qpr_dimensions.DIM_CODE%TYPE;
347: s_time qpr_dimensions.DIM_CODE%TYPE;
348: s_psg qpr_dimensions.DIM_CODE%TYPE;
349:
350: s_offinv_type varchar2(100);
343: is
344:
345: line_id Number;
346: s_product qpr_dimensions.DIM_CODE%TYPE;
347: s_time qpr_dimensions.DIM_CODE%TYPE;
348: s_psg qpr_dimensions.DIM_CODE%TYPE;
349:
350: s_offinv_type varchar2(100);
351: s_term_type varchar2(100);
344:
345: line_id Number;
346: s_product qpr_dimensions.DIM_CODE%TYPE;
347: s_time qpr_dimensions.DIM_CODE%TYPE;
348: s_psg qpr_dimensions.DIM_CODE%TYPE;
349:
350: s_offinv_type varchar2(100);
351: s_term_type varchar2(100);
352:
374: l_aw_curr varchar2(20);
375: l_curr_conv number;
376:
377: cursor c_dims is
378: select dim_code,dim_ppa_code from qpr_dimensions
379: where price_plan_id = p_price_plan_id
380: and dim_ppa_code in ('PRD', 'TIM', 'PSG');
381:
382: begin