APPS.OE_ORDER_PURGE_PVT dependencies on DBMS_SQL

Line 436: l_sql_cursor := DBMS_SQL.Open_Cursor;

432: );
433:
434:
435:
436: l_sql_cursor := DBMS_SQL.Open_Cursor;
437:
438: DBMS_SQL.PARSE(l_sql_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
439:
440: --Binding the variables

Line 438: DBMS_SQL.PARSE(l_sql_cursor, l_sql_stmt, DBMS_SQL.NATIVE);

434:
435:
436: l_sql_cursor := DBMS_SQL.Open_Cursor;
437:
438: DBMS_SQL.PARSE(l_sql_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
439:
440: --Binding the variables
441: IF p_order_number_low is NOT NULL THEN
442: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p1', p_order_number_low);

Line 442: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p1', p_order_number_low);

438: DBMS_SQL.PARSE(l_sql_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
439:
440: --Binding the variables
441: IF p_order_number_low is NOT NULL THEN
442: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p1', p_order_number_low);
443: END IF;
444: IF p_order_number_high is NOT NULL THEN
445: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_order_number_high);
446: END IF;

Line 445: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_order_number_high);

441: IF p_order_number_low is NOT NULL THEN
442: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p1', p_order_number_low);
443: END IF;
444: IF p_order_number_high is NOT NULL THEN
445: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_order_number_high);
446: END IF;
447: IF p_order_type_id is NOT NULL THEN
448: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);
449: END IF;

Line 448: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);

444: IF p_order_number_high is NOT NULL THEN
445: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_order_number_high);
446: END IF;
447: IF p_order_type_id is NOT NULL THEN
448: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);
449: END IF;
450: IF p_order_category is NOT NULL THEN
451: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_order_category);
452: END IF;

Line 451: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_order_category);

447: IF p_order_type_id is NOT NULL THEN
448: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);
449: END IF;
450: IF p_order_category is NOT NULL THEN
451: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_order_category);
452: END IF;
453: IF p_customer_id is NOT NULL THEN
454: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', p_customer_id);
455: END IF;

Line 454: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', p_customer_id);

450: IF p_order_category is NOT NULL THEN
451: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_order_category);
452: END IF;
453: IF p_customer_id is NOT NULL THEN
454: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', p_customer_id);
455: END IF;
456: IF l_ordered_date_low is NOT NULL THEN
457: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_ordered_date_low);
458: END IF;

Line 457: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_ordered_date_low);

453: IF p_customer_id is NOT NULL THEN
454: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', p_customer_id);
455: END IF;
456: IF l_ordered_date_low is NOT NULL THEN
457: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_ordered_date_low);
458: END IF;
459: IF l_ordered_date_high is NOT NULL THEN
460: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_ordered_date_high);
461: END IF;

Line 460: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_ordered_date_high);

456: IF l_ordered_date_low is NOT NULL THEN
457: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_ordered_date_low);
458: END IF;
459: IF l_ordered_date_high is NOT NULL THEN
460: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_ordered_date_high);
461: END IF;
462: IF l_creation_date_low is NOT NULL THEN
463: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_low);
464: END IF;

Line 463: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_low);

459: IF l_ordered_date_high is NOT NULL THEN
460: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_ordered_date_high);
461: END IF;
462: IF l_creation_date_low is NOT NULL THEN
463: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_low);
464: END IF;
465: IF l_creation_date_high is NOT NULL THEN
466: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_creation_date_high);
467: END IF;

Line 466: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_creation_date_high);

462: IF l_creation_date_low is NOT NULL THEN
463: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_low);
464: END IF;
465: IF l_creation_date_high is NOT NULL THEN
466: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_creation_date_high);
467: END IF;
468:
469: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);

Line 469: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);

465: IF l_creation_date_high is NOT NULL THEN
466: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_creation_date_high);
467: END IF;
468:
469: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);
471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);

Line 470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);

466: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_creation_date_high);
467: END IF;
468:
469: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);
471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);

Line 471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);

467: END IF;
468:
469: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);
471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);
475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);

Line 472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);

468:
469: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);
471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);
475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
476: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);

Line 473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);

469: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);
471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);
475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
476: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
477:

Line 474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);

470: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_order_number);
471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);
475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
476: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
477:
478: l_dummy := DBMS_SQL.execute(l_sql_cursor);

Line 475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);

471: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);
475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
476: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
477:
478: l_dummy := DBMS_SQL.execute(l_sql_cursor);
479:

Line 476: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);

472: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
473: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);
475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
476: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
477:
478: l_dummy := DBMS_SQL.execute(l_sql_cursor);
479:
480: LOOP

Line 478: l_dummy := DBMS_SQL.execute(l_sql_cursor);

474: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_quote_number);
475: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
476: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
477:
478: l_dummy := DBMS_SQL.execute(l_sql_cursor);
479:
480: LOOP
481:
482:

Line 484: IF DBMS_SQL.FETCH_ROWS(l_sql_cursor) = 0 THEN

480: LOOP
481:
482:
483:
484: IF DBMS_SQL.FETCH_ROWS(l_sql_cursor) = 0 THEN
485: EXIT;
486: END IF;
487:
488: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);

Line 488: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);

484: IF DBMS_SQL.FETCH_ROWS(l_sql_cursor) = 0 THEN
485: EXIT;
486: END IF;
487:
488: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
489: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_order_number);
490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);

Line 489: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_order_number);

485: EXIT;
486: END IF;
487:
488: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
489: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_order_number);
490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);

Line 490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);

486: END IF;
487:
488: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
489: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_order_number);
490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);
494: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);

Line 491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);

487:
488: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
489: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_order_number);
490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);
494: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
495: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);

Line 492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);

488: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
489: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_order_number);
490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);
494: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
495: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
496:

Line 493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);

489: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_order_number);
490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);
494: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
495: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
496:
497: IF l_debug_level > 0 THEN

Line 494: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);

490: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);
494: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
495: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
496:
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add('Order Number : '||to_char(l_order_number));

Line 495: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);

491: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
492: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
493: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_quote_number);
494: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
495: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
496:
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add('Order Number : '||to_char(l_order_number));
499: END IF;

Line 563: DBMS_SQL.CLOSE_CURSOR(l_sql_cursor);

559: END IF;
560:
561: END LOOP;
562:
563: DBMS_SQL.CLOSE_CURSOR(l_sql_cursor);
564: OE_DEBUG_PUB.Add('before update='|| l_purge_set_id);
565:
566: UPDATE OE_PURGE_SETS
567: SET purge_processed = 'Y'

Line 578: l_dummy := DBMS_SQL.LAST_ERROR_POSITION;

574:
575:
576: EXCEPTION
577: WHEN OTHERS THEN
578: l_dummy := DBMS_SQL.LAST_ERROR_POSITION;
579: fnd_file.put_line(FND_FILE.LOG,'At_Position '||l_dummy);
580: fnd_file.put_line(FND_FILE.LOG,'*** Error In Generate purge set ** '||substr(sqlerrm,1,300));
581:
582: End Select_Where_Cond_Purge;

Line 590: DBMS_SQL Package is being used for building the where condition for optimization.

586: Procedure : Select_Where_Cond_Purge_Quote
587: Description : Called from Quote Purge Selection concurrent program. Based on
588: the parameters it will construct the where condition. Call Insert_Purge_Set.
589: Calls Check_And_Get_Detail for every record satisfying the where condition.
590: DBMS_SQL Package is being used for building the where condition for optimization.
591: Change Record : Version 1
592: -------------------------------------------------------------------------------------------------------------*/
593:
594:

Line 952: l_sql_cursor := DBMS_SQL.Open_Cursor;

948: x_purge_set_id => l_purge_set_id
949: );
950:
951:
952: l_sql_cursor := DBMS_SQL.Open_Cursor;
953:
954: DBMS_SQL.PARSE(l_sql_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
955:
956:

Line 954: DBMS_SQL.PARSE(l_sql_cursor, l_sql_stmt, DBMS_SQL.NATIVE);

950:
951:
952: l_sql_cursor := DBMS_SQL.Open_Cursor;
953:
954: DBMS_SQL.PARSE(l_sql_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
955:
956:
957: --Binding the variables
958: IF p_quote_number_low is NOT NULL THEN

Line 959: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p1', p_quote_number_low);

955:
956:
957: --Binding the variables
958: IF p_quote_number_low is NOT NULL THEN
959: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p1', p_quote_number_low);
960: END IF;
961: IF p_quote_number_high is NOT NULL THEN
962: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_quote_number_high);
963: END IF;

Line 962: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_quote_number_high);

958: IF p_quote_number_low is NOT NULL THEN
959: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p1', p_quote_number_low);
960: END IF;
961: IF p_quote_number_high is NOT NULL THEN
962: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_quote_number_high);
963: END IF;
964: IF p_order_type_id is NOT NULL THEN
965: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);
966: END IF;

Line 965: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);

961: IF p_quote_number_high is NOT NULL THEN
962: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p2', p_quote_number_high);
963: END IF;
964: IF p_order_type_id is NOT NULL THEN
965: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);
966: END IF;
967: IF p_customer_id is NOT NULL THEN
968: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_customer_id);
969: END IF;

Line 968: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_customer_id);

964: IF p_order_type_id is NOT NULL THEN
965: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p3', p_order_type_id);
966: END IF;
967: IF p_customer_id is NOT NULL THEN
968: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_customer_id);
969: END IF;
970: IF p_quote_date_low is NOT NULL THEN
971: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', l_quote_date_low);
972: END IF;

Line 971: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', l_quote_date_low);

967: IF p_customer_id is NOT NULL THEN
968: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p4', p_customer_id);
969: END IF;
970: IF p_quote_date_low is NOT NULL THEN
971: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', l_quote_date_low);
972: END IF;
973: IF p_quote_date_high is NOT NULL THEN
974: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_quote_date_high);
975: END IF;

Line 974: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_quote_date_high);

970: IF p_quote_date_low is NOT NULL THEN
971: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p5', l_quote_date_low);
972: END IF;
973: IF p_quote_date_high is NOT NULL THEN
974: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_quote_date_high);
975: END IF;
976: IF p_creation_date_low is NOT NULL THEN
977: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_creation_date_low);
978: END IF;

Line 977: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_creation_date_low);

973: IF p_quote_date_high is NOT NULL THEN
974: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p6', l_quote_date_high);
975: END IF;
976: IF p_creation_date_low is NOT NULL THEN
977: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_creation_date_low);
978: END IF;
979: IF p_creation_date_high is NOT NULL THEN
980: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_high);
981: END IF;

Line 980: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_high);

976: IF p_creation_date_low is NOT NULL THEN
977: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p7', l_creation_date_low);
978: END IF;
979: IF p_creation_date_high is NOT NULL THEN
980: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_high);
981: END IF;
982: IF p_offer_exp_date_low is NOT NULL THEN
983: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_offer_exp_date_low);
984: END IF;

Line 983: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_offer_exp_date_low);

979: IF p_creation_date_high is NOT NULL THEN
980: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p8', l_creation_date_high);
981: END IF;
982: IF p_offer_exp_date_low is NOT NULL THEN
983: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_offer_exp_date_low);
984: END IF;
985: IF p_offer_exp_date_high is NOT NULL THEN
986: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p10', l_offer_exp_date_high);
987: END IF;

Line 986: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p10', l_offer_exp_date_high);

982: IF p_offer_exp_date_low is NOT NULL THEN
983: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p9', l_offer_exp_date_low);
984: END IF;
985: IF p_offer_exp_date_high is NOT NULL THEN
986: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p10', l_offer_exp_date_high);
987: END IF;
988:
989: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);

Line 989: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);

985: IF p_offer_exp_date_high is NOT NULL THEN
986: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p10', l_offer_exp_date_high);
987: END IF;
988:
989: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);
991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);

Line 990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);

986: DBMS_SQL.BIND_VARIABLE (l_sql_cursor, ':p10', l_offer_exp_date_high);
987: END IF;
988:
989: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);
991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);

Line 991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);

987: END IF;
988:
989: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);
991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);
995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);

Line 992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);

988:
989: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);
991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);
995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
996: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);

Line 993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);

989: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,1,l_header_id);
990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);
991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);
995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
996: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
997:

Line 994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);

990: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,2,l_quote_number);
991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);
995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
996: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
997:
998: l_dummy := DBMS_SQL.execute(l_sql_cursor);

Line 995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);

991: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,3,l_order_type_name,30);
992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);
995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
996: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
997:
998: l_dummy := DBMS_SQL.execute(l_sql_cursor);
999:

Line 996: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);

992: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,4,l_sold_to_org_id);
993: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,5,l_price_list_id);
994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);
995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
996: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
997:
998: l_dummy := DBMS_SQL.execute(l_sql_cursor);
999:
1000: LOOP

Line 998: l_dummy := DBMS_SQL.execute(l_sql_cursor);

994: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,6,l_expiration_date);
995: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,7,l_flow_status_code,30);
996: DBMS_SQL.DEFINE_COLUMN (l_sql_cursor,8,l_upgraded_flag,1);
997:
998: l_dummy := DBMS_SQL.execute(l_sql_cursor);
999:
1000: LOOP
1001:
1002: IF DBMS_SQL.FETCH_ROWS(l_sql_cursor) = 0 THEN

Line 1002: IF DBMS_SQL.FETCH_ROWS(l_sql_cursor) = 0 THEN

998: l_dummy := DBMS_SQL.execute(l_sql_cursor);
999:
1000: LOOP
1001:
1002: IF DBMS_SQL.FETCH_ROWS(l_sql_cursor) = 0 THEN
1003: EXIT;
1004: END IF;
1005:
1006: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);

Line 1006: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);

1002: IF DBMS_SQL.FETCH_ROWS(l_sql_cursor) = 0 THEN
1003: EXIT;
1004: END IF;
1005:
1006: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
1007: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_quote_number);
1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);

Line 1007: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_quote_number);

1003: EXIT;
1004: END IF;
1005:
1006: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
1007: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_quote_number);
1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);

Line 1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);

1004: END IF;
1005:
1006: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
1007: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_quote_number);
1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);
1012: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);

Line 1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);

1005:
1006: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
1007: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_quote_number);
1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);
1012: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
1013: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);

Line 1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);

1006: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,1,l_header_id);
1007: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_quote_number);
1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);
1012: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
1013: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
1014:

Line 1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);

1007: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,2,l_quote_number);
1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);
1012: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
1013: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
1014:
1015: IF l_debug_level > 0 THEN

Line 1012: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);

1008: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,3,l_order_type_name);
1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);
1012: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
1013: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
1014:
1015: IF l_debug_level > 0 THEN
1016: oe_debug_pub.add('Quote Number : '||to_char(l_quote_number));

Line 1013: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);

1009: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,4,l_sold_to_org_id);
1010: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,5,l_price_list_id);
1011: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,6,l_expiration_date);
1012: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,7,l_flow_status_code);
1013: DBMS_SQL.COLUMN_VALUE (l_sql_cursor,8,l_upgraded_flag);
1014:
1015: IF l_debug_level > 0 THEN
1016: oe_debug_pub.add('Quote Number : '||to_char(l_quote_number));
1017: END IF;

Line 1037: DBMS_SQL.CLOSE_CURSOR(l_sql_cursor);

1033: l_rec_count := 0;
1034: END IF;
1035: END LOOP;
1036:
1037: DBMS_SQL.CLOSE_CURSOR(l_sql_cursor);
1038:
1039: IF l_debug_level > 0 THEN
1040: OE_DEBUG_PUB.Add('before update='|| l_purge_set_id);
1041: END IF;

Line 1057: l_dummy := DBMS_SQL.LAST_ERROR_POSITION;

1053:
1054:
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: l_dummy := DBMS_SQL.LAST_ERROR_POSITION;
1058: fnd_file.put_line(FND_FILE.LOG,'At_Position '||l_dummy);
1059: fnd_file.put_line(FND_FILE.LOG,'*** Error In Generate purge set ** '||substr(sqlerrm,1,300));
1060: End Select_Where_Cond_Purge_Quote;
1061: