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

Line 601: cur_item := dbms_sql.open_cursor;

597: x_select := x_select || ' ORDER BY msi.inventory_item_id, msi.organization_id ';
598: END IF;
599: */
600:
601: cur_item := dbms_sql.open_cursor;
602: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
603:
604: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
605: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);

Line 602: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);

598: END IF;
599: */
600:
601: cur_item := dbms_sql.open_cursor;
602: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
603:
604: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
605: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
606: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);

Line 604: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);

600:
601: cur_item := dbms_sql.open_cursor;
602: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
603:
604: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
605: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
606: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
607: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
608:

Line 605: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);

601: cur_item := dbms_sql.open_cursor;
602: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
603:
604: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
605: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
606: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
607: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
608:
609: IF G_plan_org <> -999 THEN

Line 606: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);

602: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
603:
604: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
605: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
606: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
607: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
608:
609: IF G_plan_org <> -999 THEN
610: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);

Line 607: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);

603:
604: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
605: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
606: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
607: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
608:
609: IF G_plan_org <> -999 THEN
610: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
611: END IF;

Line 610: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);

606: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
607: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
608:
609: IF G_plan_org <> -999 THEN
610: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
611: END IF;
612:
613: IF G_category_low IS NOT NULL THEN
614: dbms_sql.bind_variable(cur_item, ':category_low', G_category_low);

Line 614: dbms_sql.bind_variable(cur_item, ':category_low', G_category_low);

610: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
611: END IF;
612:
613: IF G_category_low IS NOT NULL THEN
614: dbms_sql.bind_variable(cur_item, ':category_low', G_category_low);
615: END IF;
616: IF G_category_high IS NOT NULL THEN
617: dbms_sql.bind_variable(cur_item, ':category_high', G_category_high);
618: END IF;

Line 617: dbms_sql.bind_variable(cur_item, ':category_high', G_category_high);

613: IF G_category_low IS NOT NULL THEN
614: dbms_sql.bind_variable(cur_item, ':category_low', G_category_low);
615: END IF;
616: IF G_category_high IS NOT NULL THEN
617: dbms_sql.bind_variable(cur_item, ':category_high', G_category_high);
618: END IF;
619:
620: IF G_ex_typ IS NOT NULL THEN
621: dbms_sql.bind_variable(cur_item, ':exception_type', G_ex_typ);

Line 621: dbms_sql.bind_variable(cur_item, ':exception_type', G_ex_typ);

617: dbms_sql.bind_variable(cur_item, ':category_high', G_category_high);
618: END IF;
619:
620: IF G_ex_typ IS NOT NULL THEN
621: dbms_sql.bind_variable(cur_item, ':exception_type', G_ex_typ);
622: END IF;
623:
624: IF G_plnr_low IS NOT NULL THEN
625: dbms_sql.bind_variable(cur_item, ':planner_low', G_plnr_low);

Line 625: dbms_sql.bind_variable(cur_item, ':planner_low', G_plnr_low);

621: dbms_sql.bind_variable(cur_item, ':exception_type', G_ex_typ);
622: END IF;
623:
624: IF G_plnr_low IS NOT NULL THEN
625: dbms_sql.bind_variable(cur_item, ':planner_low', G_plnr_low);
626: END IF;
627: IF G_plnr_high IS NOT NULL THEN
628: dbms_sql.bind_variable(cur_item, ':planner_high', G_plnr_high);
629: END IF;

Line 628: dbms_sql.bind_variable(cur_item, ':planner_high', G_plnr_high);

624: IF G_plnr_low IS NOT NULL THEN
625: dbms_sql.bind_variable(cur_item, ':planner_low', G_plnr_low);
626: END IF;
627: IF G_plnr_high IS NOT NULL THEN
628: dbms_sql.bind_variable(cur_item, ':planner_high', G_plnr_high);
629: END IF;
630:
631: IF G_byr_low IS NOT NULL THEN
632: dbms_sql.bind_variable(cur_item, ':buyer_low', G_byr_low);

Line 632: dbms_sql.bind_variable(cur_item, ':buyer_low', G_byr_low);

628: dbms_sql.bind_variable(cur_item, ':planner_high', G_plnr_high);
629: END IF;
630:
631: IF G_byr_low IS NOT NULL THEN
632: dbms_sql.bind_variable(cur_item, ':buyer_low', G_byr_low);
633: END IF;
634: IF G_byr_high IS NOT NULL THEN
635: dbms_sql.bind_variable(cur_item, ':buyer_high', G_byr_high);
636: END IF;

Line 635: dbms_sql.bind_variable(cur_item, ':buyer_high', G_byr_high);

631: IF G_byr_low IS NOT NULL THEN
632: dbms_sql.bind_variable(cur_item, ':buyer_low', G_byr_low);
633: END IF;
634: IF G_byr_high IS NOT NULL THEN
635: dbms_sql.bind_variable(cur_item, ':buyer_high', G_byr_high);
636: END IF;
637:
638: IF G_abc_class_low IS NOT NULL THEN
639: dbms_sql.bind_variable(cur_item, ':abc_class_low', G_abc_class_low);

Line 639: dbms_sql.bind_variable(cur_item, ':abc_class_low', G_abc_class_low);

635: dbms_sql.bind_variable(cur_item, ':buyer_high', G_byr_high);
636: END IF;
637:
638: IF G_abc_class_low IS NOT NULL THEN
639: dbms_sql.bind_variable(cur_item, ':abc_class_low', G_abc_class_low);
640: END IF;
641: IF G_abc_class_high IS NOT NULL THEN
642: dbms_sql.bind_variable(cur_item, ':abc_class_high', G_abc_class_high);
643: END IF;

Line 642: dbms_sql.bind_variable(cur_item, ':abc_class_high', G_abc_class_high);

638: IF G_abc_class_low IS NOT NULL THEN
639: dbms_sql.bind_variable(cur_item, ':abc_class_low', G_abc_class_low);
640: END IF;
641: IF G_abc_class_high IS NOT NULL THEN
642: dbms_sql.bind_variable(cur_item, ':abc_class_high', G_abc_class_high);
643: END IF;
644:
645: IF G_itm_low IS NOT NULL THEN
646: dbms_sql.bind_variable(cur_item, ':item_name_low', G_itm_low);

Line 646: dbms_sql.bind_variable(cur_item, ':item_name_low', G_itm_low);

642: dbms_sql.bind_variable(cur_item, ':abc_class_high', G_abc_class_high);
643: END IF;
644:
645: IF G_itm_low IS NOT NULL THEN
646: dbms_sql.bind_variable(cur_item, ':item_name_low', G_itm_low);
647: END IF;
648: IF G_itm_high IS NOT NULL THEN
649: dbms_sql.bind_variable(cur_item, ':item_name_high', G_itm_high);
650: END IF;

Line 649: dbms_sql.bind_variable(cur_item, ':item_name_high', G_itm_high);

645: IF G_itm_low IS NOT NULL THEN
646: dbms_sql.bind_variable(cur_item, ':item_name_low', G_itm_low);
647: END IF;
648: IF G_itm_high IS NOT NULL THEN
649: dbms_sql.bind_variable(cur_item, ':item_name_high', G_itm_high);
650: END IF;
651: /*
652: IF G_fsort IS NOT NULL THEN
653: dbms_sql.bind_variable(cur_item, ':first_sort', G_fsort);

Line 653: dbms_sql.bind_variable(cur_item, ':first_sort', G_fsort);

649: dbms_sql.bind_variable(cur_item, ':item_name_high', G_itm_high);
650: END IF;
651: /*
652: IF G_fsort IS NOT NULL THEN
653: dbms_sql.bind_variable(cur_item, ':first_sort', G_fsort);
654: END IF;
655: IF G_ssort IS NOT NULL THEN
656: dbms_sql.bind_variable(cur_item, ':second_sort', G_ssort);
657: END IF;

Line 656: dbms_sql.bind_variable(cur_item, ':second_sort', G_ssort);

652: IF G_fsort IS NOT NULL THEN
653: dbms_sql.bind_variable(cur_item, ':first_sort', G_fsort);
654: END IF;
655: IF G_ssort IS NOT NULL THEN
656: dbms_sql.bind_variable(cur_item, ':second_sort', G_ssort);
657: END IF;
658: IF G_tsort IS NOT NULL THEN
659: dbms_sql.bind_variable(cur_item, ':third_sort', G_tsort);
660: END IF;

Line 659: dbms_sql.bind_variable(cur_item, ':third_sort', G_tsort);

655: IF G_ssort IS NOT NULL THEN
656: dbms_sql.bind_variable(cur_item, ':second_sort', G_ssort);
657: END IF;
658: IF G_tsort IS NOT NULL THEN
659: dbms_sql.bind_variable(cur_item, ':third_sort', G_tsort);
660: END IF;
661: */
662:
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' Item query - '||x_select );

Line 665: X_row_count := dbms_sql.EXECUTE (cur_item);

661: */
662:
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' Item query - '||x_select );
664:
665: X_row_count := dbms_sql.EXECUTE (cur_item);
666:
667: -- Vpedarla bug: 9366921
668: Items_count := X_row_count ;
669:

Line 672: dbms_sql.close_cursor (cur_item);

668: Items_count := X_row_count ;
669:
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of rows in gmp_pdr_items_gtmp '||to_char(X_row_count));
671:
672: dbms_sql.close_cursor (cur_item);
673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);

Line 677: IF dbms_sql.is_open (cur_item) THEN

673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
677: IF dbms_sql.is_open (cur_item) THEN
678: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
679: dbms_sql.close_cursor (cur_item);
680: END IF;
681: END insert_items;

Line 679: dbms_sql.close_cursor (cur_item);

675: WHEN OTHERS THEN
676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
677: IF dbms_sql.is_open (cur_item) THEN
678: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
679: dbms_sql.close_cursor (cur_item);
680: END IF;
681: END insert_items;
682:
683: