eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_BIS_UTZ_ALERT dependencies on DBMS_SQL

Line 154: cursor_id := DBMS_SQL.OPEN_CURSOR;

150: end if;
151: p_groupby_product := p_select_product;
152:
153:
154: cursor_id := DBMS_SQL.OPEN_CURSOR;
155:
156: -- No literals to change to bind variables as per coding standard.
157: p_select_statement :=
158: 'select ' ||

Line 174: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );

170: p_groupby_org || ', ' ||
171: p_groupby_geo || ', ' ||
172: p_groupby_product;
173:
174: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
175:
176: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );

Line 176: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );

172: p_groupby_product;
173:
174: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
175:
176: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );

Line 177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );

173:
174: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
175:
176: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
181: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );

Line 178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );

174: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
175:
176: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
181: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
182: ignore := DBMS_SQL.EXECUTE( cursor_id );

Line 179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );

175:
176: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
181: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
182: ignore := DBMS_SQL.EXECUTE( cursor_id );
183:

Line 180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );

176: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
181: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
182: ignore := DBMS_SQL.EXECUTE( cursor_id );
183:
184:

Line 181: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );

177: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
181: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
182: ignore := DBMS_SQL.EXECUTE( cursor_id );
183:
184:
185: LOOP

Line 182: ignore := DBMS_SQL.EXECUTE( cursor_id );

178: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
179: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
180: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
181: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
182: ignore := DBMS_SQL.EXECUTE( cursor_id );
183:
184:
185: LOOP
186: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN

Line 186: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN

182: ignore := DBMS_SQL.EXECUTE( cursor_id );
183:
184:
185: LOOP
186: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
187: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );

Line 187: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );

183:
184:
185: LOOP
186: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
187: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );

Line 188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );

184:
185: LOOP
186: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
187: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
192: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );

Line 189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );

185: LOOP
186: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
187: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
192: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
193:

Line 190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );

186: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
187: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
192: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
193:
194: WIP_BIS_UTZ_ALERT.PostActual(

Line 191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );

187: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
192: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
193:
194: WIP_BIS_UTZ_ALERT.PostActual(
195: target_level_id,

Line 192: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );

188: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
189: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
192: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
193:
194: WIP_BIS_UTZ_ALERT.PostActual(
195: target_level_id,
196: v_time,

Line 209: DBMS_SQL.CLOSE_CURSOR(cursor_id);

205: END IF;
206:
207: END LOOP;
208:
209: DBMS_SQL.CLOSE_CURSOR(cursor_id);
210:
211: END PostLevelActuals;
212:
213:

Line 693: cursor_id := DBMS_SQL.OPEN_CURSOR;

689: p_where_trgt_prod := 'and trgt.dim2_level_value_id = to_char(TEMP.inventory_item_id) ';
690: end if;
691:
692:
693: cursor_id := DBMS_SQL.OPEN_CURSOR;
694:
695: -- Changing literals to bind variables as per coding standard.
696: p_select_statement :=
697: 'select ' ||

Line 760: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );

756: p_groupby_product || ', ' ||
757: 'trgt.target, bbp.plan_id, bbp.name, ' ||
758: 'btl.workflow_process_short_name ';
759:
760: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
761:
762: DBMS_SQL.BIND_VARIABLE (cursor_id, ':target_level_id', target_level_id);
763:
764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );

Line 762: DBMS_SQL.BIND_VARIABLE (cursor_id, ':target_level_id', target_level_id);

758: 'btl.workflow_process_short_name ';
759:
760: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
761:
762: DBMS_SQL.BIND_VARIABLE (cursor_id, ':target_level_id', target_level_id);
763:
764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );

Line 764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );

760: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
761:
762: DBMS_SQL.BIND_VARIABLE (cursor_id, ':target_level_id', target_level_id);
763:
764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );

Line 765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );

761:
762: DBMS_SQL.BIND_VARIABLE (cursor_id, ':target_level_id', target_level_id);
763:
764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );

Line 766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );

762: DBMS_SQL.BIND_VARIABLE (cursor_id, ':target_level_id', target_level_id);
763:
764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );

Line 767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );

763:
764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );

Line 768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );

764: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );

Line 769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );

765: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );

Line 770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );

766: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );

Line 771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );

767: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );

Line 772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );

768: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );

Line 773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );

769: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );

Line 774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );

770: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );

Line 775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );

771: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );

Line 776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );

772: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );

Line 777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );

773: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );

Line 778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );

774: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );

Line 779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );

775: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );

Line 780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );

776: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );

Line 781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );

777: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );

Line 782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );

778: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );

Line 783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );

779: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );

Line 784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );

780: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );

Line 785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );

781: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );

Line 786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );

782: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );

Line 787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );

783: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );

Line 788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );

784: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );

Line 789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );

785: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );

Line 790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );

786: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );

Line 791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );

787: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );

Line 792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );

788: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */

Line 793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );

789: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */
797: dbms_sql.define_column( cursor_id, 34, v_country_id , 80 ); /* James */

Line 794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );

790: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */
797: dbms_sql.define_column( cursor_id, 34, v_country_id , 80 ); /* James */
798: ignore := DBMS_SQL.EXECUTE( cursor_id );

Line 795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );

791: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */
797: dbms_sql.define_column( cursor_id, 34, v_country_id , 80 ); /* James */
798: ignore := DBMS_SQL.EXECUTE( cursor_id );
799:

Line 796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */

792: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */
797: dbms_sql.define_column( cursor_id, 34, v_country_id , 80 ); /* James */
798: ignore := DBMS_SQL.EXECUTE( cursor_id );
799:
800:

Line 797: dbms_sql.define_column( cursor_id, 34, v_country_id , 80 ); /* James */

793: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */
797: dbms_sql.define_column( cursor_id, 34, v_country_id , 80 ); /* James */
798: ignore := DBMS_SQL.EXECUTE( cursor_id );
799:
800:
801: LOOP

Line 798: ignore := DBMS_SQL.EXECUTE( cursor_id );

794: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
795: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
796: dbms_sql.define_column( cursor_id, 33, v_region_name , 80 ); /* James */
797: dbms_sql.define_column( cursor_id, 34, v_country_id , 80 ); /* James */
798: ignore := DBMS_SQL.EXECUTE( cursor_id );
799:
800:
801: LOOP
802: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN

Line 802: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN

798: ignore := DBMS_SQL.EXECUTE( cursor_id );
799:
800:
801: LOOP
802: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
803: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );

Line 803: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );

799:
800:
801: LOOP
802: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
803: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );

Line 804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );

800:
801: LOOP
802: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
803: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );

Line 805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );

801: LOOP
802: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
803: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );

Line 806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );

802: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
803: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );

Line 807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );

803: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );

Line 808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );

804: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );

Line 809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );

805: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );

Line 810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );

806: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );

Line 811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );

807: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );

Line 812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );

808: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );

Line 813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );

809: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );

Line 814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );

810: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );

Line 815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );

811: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );

Line 816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );

812: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );

Line 817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );

813: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );

Line 818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );

814: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );

Line 819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );

815: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );

Line 820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );

816: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );

Line 821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );

817: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );

Line 822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );

818: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );

Line 823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );

819: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );

Line 824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );

820: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );

Line 825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );

821: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );

Line 826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );

822: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );

Line 827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );

823: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );

Line 828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );

824: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );

Line 829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );

825: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );

Line 830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );

826: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );

Line 831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );

827: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
835: dbms_sql.column_value( cursor_id, 33, v_region_name ); /* James */

Line 832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );

828: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
835: dbms_sql.column_value( cursor_id, 33, v_region_name ); /* James */
836: dbms_sql.column_value( cursor_id, 34, v_country_id ); /* James */

Line 833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );

829: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
835: dbms_sql.column_value( cursor_id, 33, v_region_name ); /* James */
836: dbms_sql.column_value( cursor_id, 34, v_country_id ); /* James */
837:

Line 834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );

830: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
835: dbms_sql.column_value( cursor_id, 33, v_region_name ); /* James */
836: dbms_sql.column_value( cursor_id, 34, v_country_id ); /* James */
837:
838: /* James 7/12/99 debugging */

Line 835: dbms_sql.column_value( cursor_id, 33, v_region_name ); /* James */

831: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
835: dbms_sql.column_value( cursor_id, 33, v_region_name ); /* James */
836: dbms_sql.column_value( cursor_id, 34, v_country_id ); /* James */
837:
838: /* James 7/12/99 debugging */
839: /*INSERT INTO my_alert_test

Line 836: dbms_sql.column_value( cursor_id, 34, v_country_id ); /* James */

832: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
833: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
834: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
835: dbms_sql.column_value( cursor_id, 33, v_region_name ); /* James */
836: dbms_sql.column_value( cursor_id, 34, v_country_id ); /* James */
837:
838: /* James 7/12/99 debugging */
839: /*INSERT INTO my_alert_test
840: VALUES(v_actual, v_target, v_range1_low, v_range1_high, v_range2_low,

Line 894: DBMS_SQL.CLOSE_CURSOR(cursor_id);

890: END IF;
891:
892: END LOOP;
893:
894: DBMS_SQL.CLOSE_CURSOR(cursor_id);
895:
896: END CompareLevelTarget;
897:
898: /*