APPS.QPR_DML_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

str2 := str2 || 'SQL SELECT dim_code FROM qpr_dimensions WHERE price_plan_id = to_number(:pricePlan) and  dim_ppa_code = ''TIM'' into :timDim;';

Line: 46

str2 := str2 || 'SQL SELECT dim_code FROM qpr_dimensions WHERE price_plan_id  = to_number(:pricePlan) and dim_ppa_code = ''PRD'' into :prdDim;';

Line: 47

str2 := str2 || 'SQL SELECT dim_code FROM qpr_dimensions WHERE price_plan_id  = to_number(:pricePlan) and dim_ppa_code = ''CUS'' into :cusDim;';

Line: 48

str2 := str2 || 'SQL SELECT dim_code FROM qpr_dimensions WHERE price_plan_id  = to_number(:pricePlan) and dim_ppa_code = ''PSG'' into :psgDim;';

Line: 49

str2 := str2 || 'SQL SELECT dim_code FROM qpr_dimensions WHERE price_plan_id = to_number(:pricePlan) and dim_ppa_code = ''ORD'' into :ordDim;';

Line: 50

str2 := str2 || 'SQL SELECT  cube_code FROM  qpr_cubes WHERE price_plan_id  = to_number(:pricePlan) and  cube_ppa_code = ''PRICE_SALES'' into :salesDataCube;';

Line: 92

str1 := str1 || 'SQL select dim_code from qpr_dimensions where price_plan_id = to_number(:priceplan) and dim_ppa_code = ''OAD'' into :oadDim;';

Line: 96

str1 := str1 || 'SQL select cube_code from qpr_cubes where price_plan_id = to_number(:priceplan) and cube_ppa_code = ''OFF_INV_ADJ'' into :oadPerMeas;';

Line: 108

dbms_aw.execute('update;commit;');

Line: 109

FND_FILE.PUT_LINE(FND_FILE.LOG,'UPDATE and COMMIT');