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 414: cur_item := dbms_sql.open_cursor;

410: x_select := x_select || ' ORDER BY msi.inventory_item_id, msi.organization_id ';
411: END IF;
412: */
413:
414: cur_item := dbms_sql.open_cursor;
415: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
416:
417: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
418: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);

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

411: END IF;
412: */
413:
414: cur_item := dbms_sql.open_cursor;
415: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
416:
417: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
418: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
419: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);

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

413:
414: cur_item := dbms_sql.open_cursor;
415: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
416:
417: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
418: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
419: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
420: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
421:

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

414: cur_item := dbms_sql.open_cursor;
415: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
416:
417: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
418: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
419: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
420: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
421:
422: IF G_plan_org <> -999 THEN

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

415: dbms_sql.parse (cur_item, x_select,dbms_sql.NATIVE);
416:
417: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
418: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
419: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
420: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
421:
422: IF G_plan_org <> -999 THEN
423: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);

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

416:
417: dbms_sql.bind_variable(cur_item, ':inst_id', G_inst_id);
418: dbms_sql.bind_variable(cur_item, ':plan_id', G_plan_id);
419: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
420: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
421:
422: IF G_plan_org <> -999 THEN
423: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
424: END IF;

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

419: -- dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
420: dbms_sql.bind_variable(cur_item, ':cat_set_id', G_cat_set_id);
421:
422: IF G_plan_org <> -999 THEN
423: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
424: END IF;
425:
426: IF G_category_low IS NOT NULL THEN
427: dbms_sql.bind_variable(cur_item, ':category_low', G_category_low);

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

423: dbms_sql.bind_variable(cur_item, ':plan_org', G_plan_org);
424: END IF;
425:
426: IF G_category_low IS NOT NULL THEN
427: dbms_sql.bind_variable(cur_item, ':category_low', G_category_low);
428: END IF;
429: IF G_category_high IS NOT NULL THEN
430: dbms_sql.bind_variable(cur_item, ':category_high', G_category_high);
431: END IF;

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

426: IF G_category_low IS NOT NULL THEN
427: dbms_sql.bind_variable(cur_item, ':category_low', G_category_low);
428: END IF;
429: IF G_category_high IS NOT NULL THEN
430: dbms_sql.bind_variable(cur_item, ':category_high', G_category_high);
431: END IF;
432:
433: IF G_ex_typ IS NOT NULL THEN
434: dbms_sql.bind_variable(cur_item, ':exception_type', G_ex_typ);

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

430: dbms_sql.bind_variable(cur_item, ':category_high', G_category_high);
431: END IF;
432:
433: IF G_ex_typ IS NOT NULL THEN
434: dbms_sql.bind_variable(cur_item, ':exception_type', G_ex_typ);
435: END IF;
436:
437: IF G_plnr_low IS NOT NULL THEN
438: dbms_sql.bind_variable(cur_item, ':planner_low', G_plnr_low);

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

434: dbms_sql.bind_variable(cur_item, ':exception_type', G_ex_typ);
435: END IF;
436:
437: IF G_plnr_low IS NOT NULL THEN
438: dbms_sql.bind_variable(cur_item, ':planner_low', G_plnr_low);
439: END IF;
440: IF G_plnr_high IS NOT NULL THEN
441: dbms_sql.bind_variable(cur_item, ':planner_high', G_plnr_high);
442: END IF;

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

437: IF G_plnr_low IS NOT NULL THEN
438: dbms_sql.bind_variable(cur_item, ':planner_low', G_plnr_low);
439: END IF;
440: IF G_plnr_high IS NOT NULL THEN
441: dbms_sql.bind_variable(cur_item, ':planner_high', G_plnr_high);
442: END IF;
443:
444: IF G_byr_low IS NOT NULL THEN
445: dbms_sql.bind_variable(cur_item, ':buyer_low', G_byr_low);

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

441: dbms_sql.bind_variable(cur_item, ':planner_high', G_plnr_high);
442: END IF;
443:
444: IF G_byr_low IS NOT NULL THEN
445: dbms_sql.bind_variable(cur_item, ':buyer_low', G_byr_low);
446: END IF;
447: IF G_byr_high IS NOT NULL THEN
448: dbms_sql.bind_variable(cur_item, ':buyer_high', G_byr_high);
449: END IF;

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

444: IF G_byr_low IS NOT NULL THEN
445: dbms_sql.bind_variable(cur_item, ':buyer_low', G_byr_low);
446: END IF;
447: IF G_byr_high IS NOT NULL THEN
448: dbms_sql.bind_variable(cur_item, ':buyer_high', G_byr_high);
449: END IF;
450:
451: IF G_abc_class_low IS NOT NULL THEN
452: dbms_sql.bind_variable(cur_item, ':abc_class_low', G_abc_class_low);

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

448: dbms_sql.bind_variable(cur_item, ':buyer_high', G_byr_high);
449: END IF;
450:
451: IF G_abc_class_low IS NOT NULL THEN
452: dbms_sql.bind_variable(cur_item, ':abc_class_low', G_abc_class_low);
453: END IF;
454: IF G_abc_class_high IS NOT NULL THEN
455: dbms_sql.bind_variable(cur_item, ':abc_class_high', G_abc_class_high);
456: END IF;

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

451: IF G_abc_class_low IS NOT NULL THEN
452: dbms_sql.bind_variable(cur_item, ':abc_class_low', G_abc_class_low);
453: END IF;
454: IF G_abc_class_high IS NOT NULL THEN
455: dbms_sql.bind_variable(cur_item, ':abc_class_high', G_abc_class_high);
456: END IF;
457:
458: IF G_itm_low IS NOT NULL THEN
459: dbms_sql.bind_variable(cur_item, ':item_name_low', G_itm_low);

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

455: dbms_sql.bind_variable(cur_item, ':abc_class_high', G_abc_class_high);
456: END IF;
457:
458: IF G_itm_low IS NOT NULL THEN
459: dbms_sql.bind_variable(cur_item, ':item_name_low', G_itm_low);
460: END IF;
461: IF G_itm_high IS NOT NULL THEN
462: dbms_sql.bind_variable(cur_item, ':item_name_high', G_itm_high);
463: END IF;

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

458: IF G_itm_low IS NOT NULL THEN
459: dbms_sql.bind_variable(cur_item, ':item_name_low', G_itm_low);
460: END IF;
461: IF G_itm_high IS NOT NULL THEN
462: dbms_sql.bind_variable(cur_item, ':item_name_high', G_itm_high);
463: END IF;
464: /*
465: IF G_fsort IS NOT NULL THEN
466: dbms_sql.bind_variable(cur_item, ':first_sort', G_fsort);

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

462: dbms_sql.bind_variable(cur_item, ':item_name_high', G_itm_high);
463: END IF;
464: /*
465: IF G_fsort IS NOT NULL THEN
466: dbms_sql.bind_variable(cur_item, ':first_sort', G_fsort);
467: END IF;
468: IF G_ssort IS NOT NULL THEN
469: dbms_sql.bind_variable(cur_item, ':second_sort', G_ssort);
470: END IF;

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

465: IF G_fsort IS NOT NULL THEN
466: dbms_sql.bind_variable(cur_item, ':first_sort', G_fsort);
467: END IF;
468: IF G_ssort IS NOT NULL THEN
469: dbms_sql.bind_variable(cur_item, ':second_sort', G_ssort);
470: END IF;
471: IF G_tsort IS NOT NULL THEN
472: dbms_sql.bind_variable(cur_item, ':third_sort', G_tsort);
473: END IF;

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

468: IF G_ssort IS NOT NULL THEN
469: dbms_sql.bind_variable(cur_item, ':second_sort', G_ssort);
470: END IF;
471: IF G_tsort IS NOT NULL THEN
472: dbms_sql.bind_variable(cur_item, ':third_sort', G_tsort);
473: END IF;
474: */
475: X_row_count := dbms_sql.EXECUTE (cur_item);
476:

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

471: IF G_tsort IS NOT NULL THEN
472: dbms_sql.bind_variable(cur_item, ':third_sort', G_tsort);
473: END IF;
474: */
475: X_row_count := dbms_sql.EXECUTE (cur_item);
476:
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of rows in gmp_pdr_items_gtmp '||to_char(X_row_count));
478:
479: dbms_sql.close_cursor (cur_item);

Line 479: dbms_sql.close_cursor (cur_item);

475: X_row_count := dbms_sql.EXECUTE (cur_item);
476:
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of rows in gmp_pdr_items_gtmp '||to_char(X_row_count));
478:
479: dbms_sql.close_cursor (cur_item);
480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);

Line 484: IF dbms_sql.is_open (cur_item) THEN

480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
484: IF dbms_sql.is_open (cur_item) THEN
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
486: dbms_sql.close_cursor (cur_item);
487: END IF;
488: END insert_items;

Line 486: dbms_sql.close_cursor (cur_item);

482: WHEN OTHERS THEN
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
484: IF dbms_sql.is_open (cur_item) THEN
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
486: dbms_sql.close_cursor (cur_item);
487: END IF;
488: END insert_items;
489:
490: