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_YDSP_ALERT dependencies on DBMS_SQL

Line 168: cursor_id := DBMS_SQL.OPEN_CURSOR;

164:
165: p_groupby_product := p_select_product;
166:
167:
168: cursor_id := DBMS_SQL.OPEN_CURSOR;
169:
170: -- No literals to change to bind variables as per coding standard,
171: -- because none of the variables are entered by user.
172: p_select_statement :=

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

189: p_groupby_org || ', ' ||
190: p_groupby_geo || ', ' ||
191: p_groupby_product;
192:
193: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
194:
195: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
196: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );

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

191: p_groupby_product;
192:
193: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
194:
195: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
196: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
198: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
199: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );

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

192:
193: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
194:
195: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
196: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
198: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
199: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
200: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );

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

193: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
194:
195: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
196: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
198: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
199: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
200: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
201: ignore := DBMS_SQL.EXECUTE( cursor_id );

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

194:
195: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
196: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
198: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
199: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
200: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
201: ignore := DBMS_SQL.EXECUTE( cursor_id );
202:

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

195: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
196: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
198: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
199: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
200: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
201: ignore := DBMS_SQL.EXECUTE( cursor_id );
202:
203:

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

196: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_period_setname , 80 );
197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
198: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
199: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
200: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
201: ignore := DBMS_SQL.EXECUTE( cursor_id );
202:
203:
204: LOOP

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

197: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_org , 80 );
198: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_geography , 80 );
199: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_product , 80 );
200: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_actual );
201: ignore := DBMS_SQL.EXECUTE( cursor_id );
202:
203:
204: LOOP
205: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN

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

201: ignore := DBMS_SQL.EXECUTE( cursor_id );
202:
203:
204: LOOP
205: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
206: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
207: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
208: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
209: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );

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

202:
203:
204: LOOP
205: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
206: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
207: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
208: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
209: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
210: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );

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

203:
204: LOOP
205: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
206: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
207: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
208: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
209: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
210: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
211: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );

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

204: LOOP
205: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
206: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
207: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
208: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
209: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
210: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
211: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
212:

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

205: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
206: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
207: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
208: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
209: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
210: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
211: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
212:
213: WIP_BIS_YDSP_ALERT.PostActual(

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

206: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
207: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
208: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
209: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
210: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
211: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
212:
213: WIP_BIS_YDSP_ALERT.PostActual(
214: target_level_id,

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

207: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_period_setname );
208: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_org );
209: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
210: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
211: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
212:
213: WIP_BIS_YDSP_ALERT.PostActual(
214: target_level_id,
215: v_time,

Line 592: cursor_id := DBMS_SQL.OPEN_CURSOR;

588: p_where_trgt_prod := 'and trgt.dim2_level_value_id = to_char(TEMP.inventory_item_id) ';
589: end if;
590:
591:
592: cursor_id := DBMS_SQL.OPEN_CURSOR;
593:
594: -- Changing literals to bind variables as per coding standard.
595: p_select_statement :=
596: 'select ' ||

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

672: dbms_output.put_line (substr(p_select_statement,1300,100));
673: dbms_output.put_line (substr(p_select_statement,1400,100));
674: dbms_output.put_line (substr(p_select_statement,1500,100)); */
675:
676: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
677:
678: DBMS_SQL.BIND_VARIABLE ( cursor_id, ':target_level_id', target_level_id);
679:
680: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );

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

674: dbms_output.put_line (substr(p_select_statement,1500,100)); */
675:
676: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
677:
678: DBMS_SQL.BIND_VARIABLE ( cursor_id, ':target_level_id', target_level_id);
679:
680: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
681: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );

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

676: DBMS_SQL.PARSE( cursor_id, p_select_statement, DBMS_SQL.V7 );
677:
678: DBMS_SQL.BIND_VARIABLE ( cursor_id, ':target_level_id', target_level_id);
679:
680: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
681: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );

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

677:
678: DBMS_SQL.BIND_VARIABLE ( cursor_id, ':target_level_id', target_level_id);
679:
680: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
681: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );

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

678: DBMS_SQL.BIND_VARIABLE ( cursor_id, ':target_level_id', target_level_id);
679:
680: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
681: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );

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

679:
680: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
681: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );

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

680: DBMS_SQL.DEFINE_COLUMN( cursor_id, 1, v_time , 80 );
681: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );

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

681: DBMS_SQL.DEFINE_COLUMN( cursor_id, 2, v_org , 80 );
682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );

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

682: DBMS_SQL.DEFINE_COLUMN( cursor_id, 3, v_geography , 80 );
683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );

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

683: DBMS_SQL.DEFINE_COLUMN( cursor_id, 4, v_product , 80 );
684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );

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

684: DBMS_SQL.DEFINE_COLUMN( cursor_id, 5, v_prod_id );
685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );

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

685: DBMS_SQL.DEFINE_COLUMN( cursor_id, 6, v_sob_name , 80 );
686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );

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

686: DBMS_SQL.DEFINE_COLUMN( cursor_id, 7, v_le_name , 80 );
687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );

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

687: DBMS_SQL.DEFINE_COLUMN( cursor_id, 8, v_ou_name , 80 );
688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );

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

688: DBMS_SQL.DEFINE_COLUMN( cursor_id, 9, v_org_name , 240 );
689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );

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

689: DBMS_SQL.DEFINE_COLUMN( cursor_id, 10, v_area_name , 80 );
690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );

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

690: DBMS_SQL.DEFINE_COLUMN( cursor_id, 11, v_country_name , 80 );
691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );

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

691: DBMS_SQL.DEFINE_COLUMN( cursor_id, 12, v_prod_name , 80 );
692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );

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

692: DBMS_SQL.DEFINE_COLUMN( cursor_id, 13, v_item_name , 80 );
693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );

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

693: DBMS_SQL.DEFINE_COLUMN( cursor_id, 14, v_actual );
694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );

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

694: DBMS_SQL.DEFINE_COLUMN( cursor_id, 15, v_target );
695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );

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

695: DBMS_SQL.DEFINE_COLUMN( cursor_id, 16, v_plan_id );
696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );

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

696: DBMS_SQL.DEFINE_COLUMN( cursor_id, 17, v_plan_name , 80 );
697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );

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

697: DBMS_SQL.DEFINE_COLUMN( cursor_id, 18, v_wf , 80 );
698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );

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

698: DBMS_SQL.DEFINE_COLUMN( cursor_id, 19, v_range1_low );
699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );

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

699: DBMS_SQL.DEFINE_COLUMN( cursor_id, 20, v_range1_high );
700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );

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

700: DBMS_SQL.DEFINE_COLUMN( cursor_id, 21, v_range2_low );
701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );

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

701: DBMS_SQL.DEFINE_COLUMN( cursor_id, 22, v_range2_high );
702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );

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

702: DBMS_SQL.DEFINE_COLUMN( cursor_id, 23, v_range3_low );
703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
710: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );

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

703: DBMS_SQL.DEFINE_COLUMN( cursor_id, 24, v_range3_high );
704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
710: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
711: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );

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

704: DBMS_SQL.DEFINE_COLUMN( cursor_id, 25, v_resp1_id );
705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
710: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
711: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
712: ignore := DBMS_SQL.EXECUTE( cursor_id );

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

705: DBMS_SQL.DEFINE_COLUMN( cursor_id, 26, v_resp2_id );
706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
710: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
711: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
712: ignore := DBMS_SQL.EXECUTE( cursor_id );
713:

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

706: DBMS_SQL.DEFINE_COLUMN( cursor_id, 27, v_resp3_id );
707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
710: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
711: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
712: ignore := DBMS_SQL.EXECUTE( cursor_id );
713:
714: LOOP

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

707: DBMS_SQL.DEFINE_COLUMN( cursor_id, 28, v_resp1_name , 100 );
708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
710: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
711: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
712: ignore := DBMS_SQL.EXECUTE( cursor_id );
713:
714: LOOP
715: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN

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

708: DBMS_SQL.DEFINE_COLUMN( cursor_id, 29, v_resp2_name , 100 );
709: DBMS_SQL.DEFINE_COLUMN( cursor_id, 30, v_resp3_name , 100 );
710: DBMS_SQL.DEFINE_COLUMN( cursor_id, 31, v_start_date );
711: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
712: ignore := DBMS_SQL.EXECUTE( cursor_id );
713:
714: LOOP
715: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
716: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );

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

711: DBMS_SQL.DEFINE_COLUMN( cursor_id, 32, v_end_date );
712: ignore := DBMS_SQL.EXECUTE( cursor_id );
713:
714: LOOP
715: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
716: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
717: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );

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

712: ignore := DBMS_SQL.EXECUTE( cursor_id );
713:
714: LOOP
715: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
716: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
717: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );

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

713:
714: LOOP
715: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
716: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
717: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );

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

714: LOOP
715: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
716: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
717: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );

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

715: IF DBMS_SQL.FETCH_ROWS( cursor_id ) > 0 THEN
716: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
717: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );

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

716: DBMS_SQL.COLUMN_VALUE( cursor_id, 1, v_time );
717: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );

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

717: DBMS_SQL.COLUMN_VALUE( cursor_id, 2, v_org );
718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );

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

718: DBMS_SQL.COLUMN_VALUE( cursor_id, 3, v_geography );
719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );

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

719: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_product );
720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );

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

720: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_prod_id );
721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );

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

721: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_sob_name );
722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );

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

722: DBMS_SQL.COLUMN_VALUE( cursor_id, 7, v_le_name );
723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );

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

723: DBMS_SQL.COLUMN_VALUE( cursor_id, 8, v_ou_name );
724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );

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

724: DBMS_SQL.COLUMN_VALUE( cursor_id, 9, v_org_name );
725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );

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

725: DBMS_SQL.COLUMN_VALUE( cursor_id, 10, v_area_name );
726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );

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

726: DBMS_SQL.COLUMN_VALUE( cursor_id, 11, v_country_name );
727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );

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

727: DBMS_SQL.COLUMN_VALUE( cursor_id, 12, v_prod_name );
728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );

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

728: DBMS_SQL.COLUMN_VALUE( cursor_id, 13, v_item_name );
729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );

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

729: DBMS_SQL.COLUMN_VALUE( cursor_id, 14, v_actual );
730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );

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

730: DBMS_SQL.COLUMN_VALUE( cursor_id, 15, v_target );
731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );

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

731: DBMS_SQL.COLUMN_VALUE( cursor_id, 16, v_plan_id );
732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );

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

732: DBMS_SQL.COLUMN_VALUE( cursor_id, 17, v_plan_name );
733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );

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

733: DBMS_SQL.COLUMN_VALUE( cursor_id, 18, v_wf );
734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );

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

734: DBMS_SQL.COLUMN_VALUE( cursor_id, 19, v_range1_low );
735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );

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

735: DBMS_SQL.COLUMN_VALUE( cursor_id, 20, v_range1_high );
736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );

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

736: DBMS_SQL.COLUMN_VALUE( cursor_id, 21, v_range2_low );
737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );

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

737: DBMS_SQL.COLUMN_VALUE( cursor_id, 22, v_range2_high );
738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
745: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );

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

738: DBMS_SQL.COLUMN_VALUE( cursor_id, 23, v_range3_low );
739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
745: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
746: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );

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

739: DBMS_SQL.COLUMN_VALUE( cursor_id, 24, v_range3_high );
740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
745: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
746: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
747: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );

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

740: DBMS_SQL.COLUMN_VALUE( cursor_id, 25, v_resp1_id );
741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
745: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
746: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
747: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
748:

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

741: DBMS_SQL.COLUMN_VALUE( cursor_id, 26, v_resp2_id );
742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
745: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
746: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
747: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
748:
749:

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

742: DBMS_SQL.COLUMN_VALUE( cursor_id, 27, v_resp3_id );
743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
745: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
746: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
747: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
748:
749:
750:

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

743: DBMS_SQL.COLUMN_VALUE( cursor_id, 28, v_resp1_name );
744: DBMS_SQL.COLUMN_VALUE( cursor_id, 29, v_resp2_name );
745: DBMS_SQL.COLUMN_VALUE( cursor_id, 30, v_resp3_name );
746: DBMS_SQL.COLUMN_VALUE( cursor_id, 31, v_start_date );
747: DBMS_SQL.COLUMN_VALUE( cursor_id, 32, v_end_date );
748:
749:
750:
751: /* do the range checking */