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.OE_CREDIT_CHECK_RPT dependencies on DBMS_SQL

Line 502: v_hold_cursorID := DBMS_SQL.OPEN_CURSOR;

498: OE_DEBUG_PUB.ADD('Release select : '||v_release_final_select,2);
499: --
500: -- Open the dynamic sql cursor
501: --
502: v_hold_cursorID := DBMS_SQL.OPEN_CURSOR;
503: v_release_cursorID := DBMS_SQL.OPEN_CURSOR;
504: --
505: -- Parse the query
506: --

Line 503: v_release_cursorID := DBMS_SQL.OPEN_CURSOR;

499: --
500: -- Open the dynamic sql cursor
501: --
502: v_hold_cursorID := DBMS_SQL.OPEN_CURSOR;
503: v_release_cursorID := DBMS_SQL.OPEN_CURSOR;
504: --
505: -- Parse the query
506: --
507: DBMS_SQL.PARSE(v_hold_cursorID, v_hold_final_select, DBMS_SQL.NATIVE);

Line 507: DBMS_SQL.PARSE(v_hold_cursorID, v_hold_final_select, DBMS_SQL.NATIVE);

503: v_release_cursorID := DBMS_SQL.OPEN_CURSOR;
504: --
505: -- Parse the query
506: --
507: DBMS_SQL.PARSE(v_hold_cursorID, v_hold_final_select, DBMS_SQL.NATIVE);
508: DBMS_SQL.PARSE(v_release_cursorID, v_release_final_select, DBMS_SQL.NATIVE);
509: OE_DEBUG_PUB.ADD('Parsed the cursor',2);
510: --
511: -- Define input variables. Only bind the variables if it is part of the

Line 508: DBMS_SQL.PARSE(v_release_cursorID, v_release_final_select, DBMS_SQL.NATIVE);

504: --
505: -- Parse the query
506: --
507: DBMS_SQL.PARSE(v_hold_cursorID, v_hold_final_select, DBMS_SQL.NATIVE);
508: DBMS_SQL.PARSE(v_release_cursorID, v_release_final_select, DBMS_SQL.NATIVE);
509: OE_DEBUG_PUB.ADD('Parsed the cursor',2);
510: --
511: -- Define input variables. Only bind the variables if it is part of the
512: -- select statement

Line 517: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':gl_currency_code',p_gl_currency_code);

513: --
514: OE_DEBUG_PUB.ADD('Start binding input variables',2);
515:
516: IF p_order_by = 'GREATEST_ORDER_VALUE' THEN
517: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':gl_currency_code',p_gl_currency_code);
518: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':gl_currency_code',p_gl_currency_code);
519: OE_DEBUG_PUB.ADD('Binded gl_currency_code',2);
520: END IF;
521:

Line 518: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':gl_currency_code',p_gl_currency_code);

514: OE_DEBUG_PUB.ADD('Start binding input variables',2);
515:
516: IF p_order_by = 'GREATEST_ORDER_VALUE' THEN
517: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':gl_currency_code',p_gl_currency_code);
518: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':gl_currency_code',p_gl_currency_code);
519: OE_DEBUG_PUB.ADD('Binded gl_currency_code',2);
520: END IF;
521:
522: IF INSTRB(v_cust_prof_class_clause,':cust_prof_class_from') <> 0 THEN

Line 523: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_prof_class_from',p_cust_prof_class_name_from);

519: OE_DEBUG_PUB.ADD('Binded gl_currency_code',2);
520: END IF;
521:
522: IF INSTRB(v_cust_prof_class_clause,':cust_prof_class_from') <> 0 THEN
523: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_prof_class_from',p_cust_prof_class_name_from);
524: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_prof_class_from',p_cust_prof_class_name_from);
525: OE_DEBUG_PUB.ADD('Binded cust_prof_class_from',2);
526: END IF;
527:

Line 524: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_prof_class_from',p_cust_prof_class_name_from);

520: END IF;
521:
522: IF INSTRB(v_cust_prof_class_clause,':cust_prof_class_from') <> 0 THEN
523: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_prof_class_from',p_cust_prof_class_name_from);
524: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_prof_class_from',p_cust_prof_class_name_from);
525: OE_DEBUG_PUB.ADD('Binded cust_prof_class_from',2);
526: END IF;
527:
528: IF INSTRB(v_cust_prof_class_clause,':cust_prof_class_to') <> 0 THEN

Line 529: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_prof_class_to',p_cust_prof_class_name_to);

525: OE_DEBUG_PUB.ADD('Binded cust_prof_class_from',2);
526: END IF;
527:
528: IF INSTRB(v_cust_prof_class_clause,':cust_prof_class_to') <> 0 THEN
529: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_prof_class_to',p_cust_prof_class_name_to);
530: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_prof_class_to' ,p_cust_prof_class_name_to);
531: OE_DEBUG_PUB.ADD('Binded cust_prof_class_to',2);
532: END IF;
533:

Line 530: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_prof_class_to' ,p_cust_prof_class_name_to);

526: END IF;
527:
528: IF INSTRB(v_cust_prof_class_clause,':cust_prof_class_to') <> 0 THEN
529: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_prof_class_to',p_cust_prof_class_name_to);
530: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_prof_class_to' ,p_cust_prof_class_name_to);
531: OE_DEBUG_PUB.ADD('Binded cust_prof_class_to',2);
532: END IF;
533:
534: IF INSTRB(v_party_name_clause, ':party_name_from') <> 0 THEN

Line 535: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':party_name_from',p_party_name_from);

531: OE_DEBUG_PUB.ADD('Binded cust_prof_class_to',2);
532: END IF;
533:
534: IF INSTRB(v_party_name_clause, ':party_name_from') <> 0 THEN
535: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':party_name_from',p_party_name_from);
536: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':party_name_from',p_party_name_from);
537: OE_DEBUG_PUB.ADD('Binded party_name_from',2);
538: END IF;
539:

Line 536: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':party_name_from',p_party_name_from);

532: END IF;
533:
534: IF INSTRB(v_party_name_clause, ':party_name_from') <> 0 THEN
535: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':party_name_from',p_party_name_from);
536: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':party_name_from',p_party_name_from);
537: OE_DEBUG_PUB.ADD('Binded party_name_from',2);
538: END IF;
539:
540: IF INSTRB(v_party_name_clause, ':party_name_to') <> 0 THEN

Line 541: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':party_name_to',p_party_name_to);

537: OE_DEBUG_PUB.ADD('Binded party_name_from',2);
538: END IF;
539:
540: IF INSTRB(v_party_name_clause, ':party_name_to') <> 0 THEN
541: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':party_name_to',p_party_name_to);
542: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':party_name_to' ,p_party_name_to);
543: OE_DEBUG_PUB.ADD('Binded party_name_to',2);
544: END IF;
545:

Line 542: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':party_name_to' ,p_party_name_to);

538: END IF;
539:
540: IF INSTRB(v_party_name_clause, ':party_name_to') <> 0 THEN
541: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':party_name_to',p_party_name_to);
542: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':party_name_to' ,p_party_name_to);
543: OE_DEBUG_PUB.ADD('Binded party_name_to',2);
544: END IF;
545:
546: IF INSTRB(v_cust_acct_number_clause, ':cust_acct_number_from') <> 0 THEN

Line 547: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_acct_number_from', p_cust_acct_number_from);

543: OE_DEBUG_PUB.ADD('Binded party_name_to',2);
544: END IF;
545:
546: IF INSTRB(v_cust_acct_number_clause, ':cust_acct_number_from') <> 0 THEN
547: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_acct_number_from', p_cust_acct_number_from);
548: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_acct_number_from', p_cust_acct_number_from);
549: OE_DEBUG_PUB.ADD('Binded cust_acct_number_from',2);
550: END IF;
551:

Line 548: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_acct_number_from', p_cust_acct_number_from);

544: END IF;
545:
546: IF INSTRB(v_cust_acct_number_clause, ':cust_acct_number_from') <> 0 THEN
547: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_acct_number_from', p_cust_acct_number_from);
548: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_acct_number_from', p_cust_acct_number_from);
549: OE_DEBUG_PUB.ADD('Binded cust_acct_number_from',2);
550: END IF;
551:
552: IF INSTRB(v_cust_acct_number_clause, ':cust_acct_number_to') <> 0 THEN

Line 553: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_acct_number_to', p_cust_acct_number_to);

549: OE_DEBUG_PUB.ADD('Binded cust_acct_number_from',2);
550: END IF;
551:
552: IF INSTRB(v_cust_acct_number_clause, ':cust_acct_number_to') <> 0 THEN
553: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_acct_number_to', p_cust_acct_number_to);
554: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_acct_number_to', p_cust_acct_number_to);
555: OE_DEBUG_PUB.ADD('Binded cust_acct_number_to',2);
556: END IF;
557:

Line 554: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_acct_number_to', p_cust_acct_number_to);

550: END IF;
551:
552: IF INSTRB(v_cust_acct_number_clause, ':cust_acct_number_to') <> 0 THEN
553: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':cust_acct_number_to', p_cust_acct_number_to);
554: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':cust_acct_number_to', p_cust_acct_number_to);
555: OE_DEBUG_PUB.ADD('Binded cust_acct_number_to',2);
556: END IF;
557:
558: IF INSTRB(v_order_date_clause, ':order_date_from') <> 0 THEN

Line 559: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':order_date_from', p_order_date_from);

555: OE_DEBUG_PUB.ADD('Binded cust_acct_number_to',2);
556: END IF;
557:
558: IF INSTRB(v_order_date_clause, ':order_date_from') <> 0 THEN
559: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':order_date_from', p_order_date_from);
560: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':order_date_from', p_order_date_from);
561: OE_DEBUG_PUB.ADD('Binded order_date_from',2);
562: END IF;
563:

Line 560: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':order_date_from', p_order_date_from);

556: END IF;
557:
558: IF INSTRB(v_order_date_clause, ':order_date_from') <> 0 THEN
559: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':order_date_from', p_order_date_from);
560: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':order_date_from', p_order_date_from);
561: OE_DEBUG_PUB.ADD('Binded order_date_from',2);
562: END IF;
563:
564: IF INSTRB(v_order_date_clause, ':order_date_to') <> 0 THEN

Line 565: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':order_date_to', p_order_date_to);

561: OE_DEBUG_PUB.ADD('Binded order_date_from',2);
562: END IF;
563:
564: IF INSTRB(v_order_date_clause, ':order_date_to') <> 0 THEN
565: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':order_date_to', p_order_date_to);
566: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':order_date_to', p_order_date_to);
567: OE_DEBUG_PUB.ADD('Binded order_date_to',2);
568: END IF;
569: OE_DEBUG_PUB.ADD('Finished binding input variables',2);

Line 566: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':order_date_to', p_order_date_to);

562: END IF;
563:
564: IF INSTRB(v_order_date_clause, ':order_date_to') <> 0 THEN
565: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':order_date_to', p_order_date_to);
566: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':order_date_to', p_order_date_to);
567: OE_DEBUG_PUB.ADD('Binded order_date_to',2);
568: END IF;
569: OE_DEBUG_PUB.ADD('Finished binding input variables',2);
570: --

Line 573: DBMS_SQL.DEFINE_COLUMN(v_hold_cursorID, 1, f_hold_header_id);

569: OE_DEBUG_PUB.ADD('Finished binding input variables',2);
570: --
571: --Define the output variables
572: --
573: DBMS_SQL.DEFINE_COLUMN(v_hold_cursorID, 1, f_hold_header_id);
574: DBMS_SQL.DEFINE_COLUMN(v_release_cursorID, 1, f_release_header_id);
575:
576: OE_DEBUG_PUB.ADD('Hold ID : '||v_hold_cursorID,2); --bug# 5187621
577: OE_DEBUG_PUB.ADD('Release ID : '||v_release_cursorID,2);

Line 574: DBMS_SQL.DEFINE_COLUMN(v_release_cursorID, 1, f_release_header_id);

570: --
571: --Define the output variables
572: --
573: DBMS_SQL.DEFINE_COLUMN(v_hold_cursorID, 1, f_hold_header_id);
574: DBMS_SQL.DEFINE_COLUMN(v_release_cursorID, 1, f_release_header_id);
575:
576: OE_DEBUG_PUB.ADD('Hold ID : '||v_hold_cursorID,2); --bug# 5187621
577: OE_DEBUG_PUB.ADD('Release ID : '||v_release_cursorID,2);
578: --

Line 591: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':profile_org_id', l_profile_org_id);

587: IF l_debug_level > 0 THEN
588: OE_DEBUG_PUB.Add('org_id : ' || l_profile_org_id);
589: END IF;
590:
591: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':profile_org_id', l_profile_org_id);
592: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':profile_org_id', l_profile_org_id);
593: OE_DEBUG_PUB.ADD('Binded profile_org_id',2);
594:
595: --------------------------------------------------------------------

Line 592: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':profile_org_id', l_profile_org_id);

588: OE_DEBUG_PUB.Add('org_id : ' || l_profile_org_id);
589: END IF;
590:
591: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':profile_org_id', l_profile_org_id);
592: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':profile_org_id', l_profile_org_id);
593: OE_DEBUG_PUB.ADD('Binded profile_org_id',2);
594:
595: --------------------------------------------------------------------
596: --

Line 599: v_dummy := DBMS_SQL.EXECUTE(v_release_cursorID);

595: --------------------------------------------------------------------
596: --
597: -- RELEASE: Execute the RELEASE select statement
598: --
599: v_dummy := DBMS_SQL.EXECUTE(v_release_cursorID);
600: --
601: -- RELEASE: Fetch the orders and credit check each one with calling action AUTO RELEASE
602: --
603: LOOP

Line 604: IF DBMS_SQL.FETCH_ROWS(v_release_cursorID) = 0 THEN

600: --
601: -- RELEASE: Fetch the orders and credit check each one with calling action AUTO RELEASE
602: --
603: LOOP
604: IF DBMS_SQL.FETCH_ROWS(v_release_cursorID) = 0 THEN
605: EXIT;
606: END IF;
607: l_count := l_count+1;
608: --

Line 611: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);

607: l_count := l_count+1;
608: --
609: -- Retreive the header ID into output variable
610: --
611: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);
612: OE_DEBUG_PUB.ADD('f_release_header_id = '|| f_release_header_id,4);
613: OE_Credit_Engine_GRP.Check_Credit
614: ( p_header_id => f_release_header_id
615: , p_calling_action => 'AUTO RELEASE'

Line 640: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);

636: Insert_In_Temp_Table(f_release_header_id, 'ERROR');
637: END IF;
638: END LOOP;
639:
640: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
641:
642: -------------------------------------------------------------------------
643: --
644: -- HOLD: Execute the HOLD select statement

Line 646: v_dummy := DBMS_SQL.EXECUTE(v_hold_cursorID);

642: -------------------------------------------------------------------------
643: --
644: -- HOLD: Execute the HOLD select statement
645: --
646: v_dummy := DBMS_SQL.EXECUTE(v_hold_cursorID);
647:
648: LOOP
649: IF DBMS_SQL.FETCH_ROWS(v_hold_cursorID) = 0 THEN
650: EXIT;

Line 649: IF DBMS_SQL.FETCH_ROWS(v_hold_cursorID) = 0 THEN

645: --
646: v_dummy := DBMS_SQL.EXECUTE(v_hold_cursorID);
647:
648: LOOP
649: IF DBMS_SQL.FETCH_ROWS(v_hold_cursorID) = 0 THEN
650: EXIT;
651: END IF;
652: l_count := l_count+1;
653: --

Line 656: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);

652: l_count := l_count+1;
653: --
654: -- Retreive the header ID into output variable
655: --
656: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);
657: OE_DEBUG_PUB.ADD('f_hold_header_id = '|| f_hold_header_id,4);
658: OE_Credit_Engine_GRP.Check_Credit
659: ( p_header_id => f_hold_header_id
660: , p_calling_action => 'AUTO HOLD'

Line 685: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);

681: Insert_In_Temp_Table(f_hold_header_id, 'ERROR');
682: END IF;
683: END LOOP;
684: --
685: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
686: OE_DEBUG_PUB.ADD('Orders Processed = '||l_count,2);
687: ELSE
688: OPEN l_secured_ou_cur;
689:

Line 705: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':profile_org_id', l_profile_org_id);

701: IF l_debug_level > 0 THEN
702: OE_DEBUG_PUB.Add('org_id : ' || l_profile_org_id);
703: END IF;
704:
705: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':profile_org_id', l_profile_org_id);
706: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':profile_org_id', l_profile_org_id);
707: OE_DEBUG_PUB.ADD('Binded profile_org_id',2);
708:
709: --------------------------------------------------------------------

Line 706: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':profile_org_id', l_profile_org_id);

702: OE_DEBUG_PUB.Add('org_id : ' || l_profile_org_id);
703: END IF;
704:
705: DBMS_SQL.BIND_VARIABLE(v_hold_cursorID,':profile_org_id', l_profile_org_id);
706: DBMS_SQL.BIND_VARIABLE(v_release_cursorID,':profile_org_id', l_profile_org_id);
707: OE_DEBUG_PUB.ADD('Binded profile_org_id',2);
708:
709: --------------------------------------------------------------------
710: --

Line 713: v_dummy := DBMS_SQL.EXECUTE(v_release_cursorID);

709: --------------------------------------------------------------------
710: --
711: -- RELEASE: Execute the RELEASE select statement
712: --
713: v_dummy := DBMS_SQL.EXECUTE(v_release_cursorID);
714: --
715: -- RELEASE: Fetch the orders and credit check each one with calling action AUTO RELEASE
716: --
717: LOOP

Line 718: IF DBMS_SQL.FETCH_ROWS(v_release_cursorID) = 0 THEN

714: --
715: -- RELEASE: Fetch the orders and credit check each one with calling action AUTO RELEASE
716: --
717: LOOP
718: IF DBMS_SQL.FETCH_ROWS(v_release_cursorID) = 0 THEN
719: EXIT;
720: END IF;
721: l_count := l_count+1;
722: --

Line 725: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);

721: l_count := l_count+1;
722: --
723: -- Retreive the header ID into output variable
724: --
725: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);
726: OE_DEBUG_PUB.ADD('f_release_header_id = '|| f_release_header_id,4);
727: OE_Credit_Engine_GRP.Check_Credit
728: ( p_header_id => f_release_header_id
729: , p_calling_action => 'AUTO RELEASE'

Line 758: v_dummy := DBMS_SQL.EXECUTE(v_hold_cursorID);

754: -------------------------------------------------------------------------
755: --
756: -- HOLD: Execute the HOLD select statement
757: --
758: v_dummy := DBMS_SQL.EXECUTE(v_hold_cursorID);
759:
760: LOOP
761: IF DBMS_SQL.FETCH_ROWS(v_hold_cursorID) = 0 THEN
762: EXIT;

Line 761: IF DBMS_SQL.FETCH_ROWS(v_hold_cursorID) = 0 THEN

757: --
758: v_dummy := DBMS_SQL.EXECUTE(v_hold_cursorID);
759:
760: LOOP
761: IF DBMS_SQL.FETCH_ROWS(v_hold_cursorID) = 0 THEN
762: EXIT;
763: END IF;
764: l_count := l_count+1;
765: --

Line 768: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);

764: l_count := l_count+1;
765: --
766: -- Retreive the header ID into output variable
767: --
768: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);
769: OE_DEBUG_PUB.ADD('f_hold_header_id = '|| f_hold_header_id,4);
770: OE_Credit_Engine_GRP.Check_Credit
771: ( p_header_id => f_hold_header_id
772: , p_calling_action => 'AUTO HOLD'

Line 798: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);

794: END IF;
795: END LOOP;
796: END LOOP;
797:
798: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
799: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
800:
801: OE_DEBUG_PUB.ADD('Orders Processed = '||l_count,2);
802:

Line 799: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);

795: END LOOP;
796: END LOOP;
797:
798: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
799: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
800:
801: OE_DEBUG_PUB.ADD('Orders Processed = '||l_count,2);
802:
803: CLOSE l_secured_ou_cur;

Line 876: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN

872: EXCEPTION
873: WHEN GL_CURRENCY_API.NO_RATE THEN
874: OE_DEBUG_PUB.ADD('OEXRCRCB: Credit_Check_Processor - Error',1);
875: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE',1);
876: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
877: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
878: END IF;
879: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
880: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);

Line 877: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);

873: WHEN GL_CURRENCY_API.NO_RATE THEN
874: OE_DEBUG_PUB.ADD('OEXRCRCB: Credit_Check_Processor - Error',1);
875: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE',1);
876: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
877: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
878: END IF;
879: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
880: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
881: END IF;

Line 879: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN

875: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE',1);
876: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
877: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
878: END IF;
879: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
880: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
881: END IF;
882: RAISE;
883: WHEN OTHERS THEN

Line 880: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);

876: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
877: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
878: END IF;
879: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
880: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
881: END IF;
882: RAISE;
883: WHEN OTHERS THEN
884: OE_DEBUG_PUB.ADD('OEXRCRCB: Credit_Check_Processor - Unexpected Error',1);

Line 889: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN

885: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
887: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Credit_Check_Processor');
888: END IF;
889: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
890: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
891: END IF;
892: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
893: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);

Line 890: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);

886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
887: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Credit_Check_Processor');
888: END IF;
889: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
890: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
891: END IF;
892: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
893: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
894: END IF;

Line 892: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN

888: END IF;
889: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
890: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
891: END IF;
892: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
893: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
894: END IF;
895: RAISE;
896: END Credit_Check_Processor;

Line 893: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);

889: IF DBMS_SQL.IS_OPEN(v_hold_cursorID) THEN
890: DBMS_SQL.CLOSE_CURSOR(v_hold_cursorID);
891: END IF;
892: IF DBMS_SQL.IS_OPEN(v_release_cursorID) THEN
893: DBMS_SQL.CLOSE_CURSOR(v_release_cursorID);
894: END IF;
895: RAISE;
896: END Credit_Check_Processor;
897: