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

Line 614: l_cursor := dbms_sql.open_cursor;

610: l_sql := l_sql || ' order by inventory_item_id ';
611:
612: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: l_sql='||l_sql );
613:
614: l_cursor := dbms_sql.open_cursor;
615: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
616: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);

Line 615: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

611:
612: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: l_sql='||l_sql );
613:
614: l_cursor := dbms_sql.open_cursor;
615: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
616: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);

Line 616: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);

612: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: l_sql='||l_sql );
613:
614: l_cursor := dbms_sql.open_cursor;
615: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
616: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
620: if(l_cat_ids is not null) then

Line 617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);

613:
614: l_cursor := dbms_sql.open_cursor;
615: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
616: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
620: if(l_cat_ids is not null) then
621: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);

Line 618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);

614: l_cursor := dbms_sql.open_cursor;
615: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
616: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
620: if(l_cat_ids is not null) then
621: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
622: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);

Line 619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);

615: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
616: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
620: if(l_cat_ids is not null) then
621: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
622: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
623: end if;

Line 621: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);

617: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
620: if(l_cat_ids is not null) then
621: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
622: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
623: end if;
624:
625: if(l_item_ids is not null) then

Line 622: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);

618: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
619: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
620: if(l_cat_ids is not null) then
621: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
622: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
623: end if;
624:
625: if(l_item_ids is not null) then
626: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);

Line 626: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);

622: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
623: end if;
624:
625: if(l_item_ids is not null) then
626: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
627: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);

Line 627: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );

623: end if;
624:
625: if(l_item_ids is not null) then
626: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
627: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);

Line 628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);

624:
625: if(l_item_ids is not null) then
626: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
627: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);

Line 629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);

625: if(l_item_ids is not null) then
626: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
627: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);

Line 630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);

626: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
627: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);

Line 631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);

627: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
635: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);

Line 632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);

628: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
635: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
636: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);

Line 633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);

629: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
635: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
636: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
637:

Line 634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);

630: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
635: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
636: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
637:
638: end if;

Line 635: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);

631: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
635: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
636: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
637:
638: end if;
639:

Line 636: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);

632: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
633: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
634: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
635: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
636: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
637:
638: end if;
639:
640: l_dummy := dbms_sql.execute(l_cursor);

Line 640: l_dummy := dbms_sql.execute(l_cursor);

636: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
637:
638: end if;
639:
640: l_dummy := dbms_sql.execute(l_cursor);
641:
642: LOOP
643: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
644: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);

Line 643: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;

639:
640: l_dummy := dbms_sql.execute(l_cursor);
641:
642: LOOP
643: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
644: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
645: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
646: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: component='||l_inv_item_id||', subinv_code='||l_subinv_code );
647: if(l_inv_item_id <> l_old_inv_item_id) then

Line 644: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);

640: l_dummy := dbms_sql.execute(l_cursor);
641:
642: LOOP
643: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
644: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
645: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
646: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: component='||l_inv_item_id||', subinv_code='||l_subinv_code );
647: if(l_inv_item_id <> l_old_inv_item_id) then
648: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: calling orgonhand for component='||l_inv_item_id );

Line 645: dbms_sql.column_value(l_cursor, 2, l_subinv_code);

641:
642: LOOP
643: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
644: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
645: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
646: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: component='||l_inv_item_id||', subinv_code='||l_subinv_code );
647: if(l_inv_item_id <> l_old_inv_item_id) then
648: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: calling orgonhand for component='||l_inv_item_id );
649: l_comp_avail := get_org_component_onhand(p_org_id, l_inv_item_id);

Line 664: dbms_sql.close_cursor(l_cursor);

660: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: shortage calc=subinv, back from insert_critical_component, org='||p_org_id||', item ='||l_inv_item_id);
661: end if;
662: l_old_inv_item_id := l_inv_item_id;
663: END LOOP;
664: dbms_sql.close_cursor(l_cursor);
665:
666:
667: EXCEPTION
668: WHEN OTHERS THEN

Line 669: dbms_sql.close_cursor(l_cursor);

665:
666:
667: EXCEPTION
668: WHEN OTHERS THEN
669: dbms_sql.close_cursor(l_cursor);
670:
671: END get_pref_critical_components;
672:
673:

Line 725: l_cursor := dbms_sql.open_cursor;

721: l_sql := l_sql || ' wo.operation_seq_num ';
722:
723: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:l_sql='||l_sql);
724:
725: l_cursor := dbms_sql.open_cursor;
726: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
727: dbms_sql.define_column(l_cursor, 1, l_org_id);
728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);

Line 726: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

722:
723: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:l_sql='||l_sql);
724:
725: l_cursor := dbms_sql.open_cursor;
726: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
727: dbms_sql.define_column(l_cursor, 1, l_org_id);
728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);

Line 727: dbms_sql.define_column(l_cursor, 1, l_org_id);

723: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:l_sql='||l_sql);
724:
725: l_cursor := dbms_sql.open_cursor;
726: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
727: dbms_sql.define_column(l_cursor, 1, l_org_id);
728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );

Line 728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);

724:
725: l_cursor := dbms_sql.open_cursor;
726: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
727: dbms_sql.define_column(l_cursor, 1, l_org_id);
728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );

Line 729: dbms_sql.define_column(l_cursor, 3, l_dept_id);

725: l_cursor := dbms_sql.open_cursor;
726: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
727: dbms_sql.define_column(l_cursor, 1, l_org_id);
728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );

Line 730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);

726: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
727: dbms_sql.define_column(l_cursor, 1, l_org_id);
728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );

Line 731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );

727: dbms_sql.define_column(l_cursor, 1, l_org_id);
728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
735:

Line 732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );

728: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
735:
736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);

Line 733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );

729: dbms_sql.define_column(l_cursor, 3, l_dept_id);
730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
735:
736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
737: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);

Line 734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );

730: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
731: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
735:
736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
737: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
738: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);

Line 736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);

732: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
735:
736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
737: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
738: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
739:
740: l_dummy := dbms_sql.execute(l_cursor);

Line 737: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);

733: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
735:
736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
737: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
738: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
739:
740: l_dummy := dbms_sql.execute(l_cursor);
741: i := 0;

Line 738: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);

734: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
735:
736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
737: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
738: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
739:
740: l_dummy := dbms_sql.execute(l_cursor);
741: i := 0;
742: LOOP

Line 740: l_dummy := dbms_sql.execute(l_cursor);

736: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
737: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
738: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
739:
740: l_dummy := dbms_sql.execute(l_cursor);
741: i := 0;
742: LOOP
743: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
744: dbms_sql.column_value(l_cursor, 1, l_org_id);

Line 743: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;

739:
740: l_dummy := dbms_sql.execute(l_cursor);
741: i := 0;
742: LOOP
743: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
744: dbms_sql.column_value(l_cursor, 1, l_org_id);
745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);

Line 744: dbms_sql.column_value(l_cursor, 1, l_org_id);

740: l_dummy := dbms_sql.execute(l_cursor);
741: i := 0;
742: LOOP
743: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
744: dbms_sql.column_value(l_cursor, 1, l_org_id);
745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);

Line 745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);

741: i := 0;
742: LOOP
743: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
744: dbms_sql.column_value(l_cursor, 1, l_org_id);
745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);

Line 746: dbms_sql.column_value(l_cursor, 3, l_dept_id);

742: LOOP
743: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
744: dbms_sql.column_value(l_cursor, 1, l_org_id);
745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
750: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);

Line 747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);

743: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
744: dbms_sql.column_value(l_cursor, 1, l_org_id);
745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
750: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
751: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);

Line 748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);

744: dbms_sql.column_value(l_cursor, 1, l_org_id);
745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
750: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
751: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
752:

Line 749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);

745: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
750: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
751: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
752:
753: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:Adding job op, l_org_id='||l_org_id||',l_wip_ent_id='||l_wip_ent_id||

Line 750: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);

746: dbms_sql.column_value(l_cursor, 3, l_dept_id);
747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
750: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
751: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
752:
753: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:Adding job op, l_org_id='||l_org_id||',l_wip_ent_id='||l_wip_ent_id||
754: ',l_op_seq_num='||l_op_seq_num||',l_dept_id='||l_dept_id||',l_op_fusd='||l_op_fusd||',l_op_start_qty='||l_op_start_qty||

Line 751: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);

747: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
748: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
749: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
750: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
751: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
752:
753: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:Adding job op, l_org_id='||l_org_id||',l_wip_ent_id='||l_wip_ent_id||
754: ',l_op_seq_num='||l_op_seq_num||',l_dept_id='||l_dept_id||',l_op_fusd='||l_op_fusd||',l_op_start_qty='||l_op_start_qty||
755: ',l_op_open_qty='||l_op_open_qty||',l_op_sch_qty='||l_op_sch_qty);

Line 767: dbms_sql.close_cursor(l_cursor);

763: g_wip_job_op_tbl(i).OPEN_QTY := l_op_open_qty;
764: g_wip_job_op_tbl(i).SCHEDULED_QTY := l_op_sch_qty;
765: i := i+1;
766: END LOOP;
767: dbms_sql.close_cursor(l_cursor);
768:
769: --call custom hook procedure to reorder operations if necessary
770: begin
771: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:Calling custom procedure for reordering operations');

Line 785: dbms_sql.close_cursor(l_cursor);

781: end;
782:
783: EXCEPTION
784: WHEN OTHERS THEN
785: dbms_sql.close_cursor(l_cursor);
786:
787:
788: END get_job_ops;
789:

Line 966: l_cursor := dbms_sql.open_cursor;

962: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components:Entered in for loop for org_id='||g_wip_job_op_tbl(i).ORGANIZATION_ID||
963: ',wip_ent_id='||g_wip_job_op_tbl(i).WIP_ENTITY_ID||',op_seq_num='||g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
964:
965:
966: l_cursor := dbms_sql.open_cursor;
967: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);

Line 967: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

963: ',wip_ent_id='||g_wip_job_op_tbl(i).WIP_ENTITY_ID||',op_seq_num='||g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
964:
965:
966: l_cursor := dbms_sql.open_cursor;
967: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);

Line 968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);

964:
965:
966: l_cursor := dbms_sql.open_cursor;
967: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);

Line 969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);

965:
966: l_cursor := dbms_sql.open_cursor;
967: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);

Line 970: dbms_sql.define_column(l_cursor, 3, l_req_qty);

966: l_cursor := dbms_sql.open_cursor;
967: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);

Line 971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);

967: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);
975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);

Line 972: dbms_sql.define_column(l_cursor, 5, l_qpa);

968: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);
975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);

Line 973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);

969: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);
975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
977: dbms_sql.define_column(l_cursor, 10, l_yield);

Line 974: dbms_sql.define_column(l_cursor, 7, l_basis_type);

970: dbms_sql.define_column(l_cursor, 3, l_req_qty);
971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);
975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
977: dbms_sql.define_column(l_cursor, 10, l_yield);
978:

Line 975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);

971: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);
975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
977: dbms_sql.define_column(l_cursor, 10, l_yield);
978:
979: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);

Line 976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);

972: dbms_sql.define_column(l_cursor, 5, l_qpa);
973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);
975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
977: dbms_sql.define_column(l_cursor, 10, l_yield);
978:
979: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
980: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);

Line 977: dbms_sql.define_column(l_cursor, 10, l_yield);

973: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
974: dbms_sql.define_column(l_cursor, 7, l_basis_type);
975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
977: dbms_sql.define_column(l_cursor, 10, l_yield);
978:
979: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
980: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
981: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);

Line 979: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);

975: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
977: dbms_sql.define_column(l_cursor, 10, l_yield);
978:
979: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
980: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
981: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
982:
983: if(l_cat_ids is not null) then

Line 980: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);

976: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
977: dbms_sql.define_column(l_cursor, 10, l_yield);
978:
979: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
980: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
981: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
982:
983: if(l_cat_ids is not null) then
984: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);

Line 981: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);

977: dbms_sql.define_column(l_cursor, 10, l_yield);
978:
979: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
980: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
981: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
982:
983: if(l_cat_ids is not null) then
984: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
985: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);

Line 984: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);

980: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
981: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
982:
983: if(l_cat_ids is not null) then
984: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
985: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
986: end if;
987: if(l_item_ids is not null) then
988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);

Line 985: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);

981: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
982:
983: if(l_cat_ids is not null) then
984: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
985: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
986: end if;
987: if(l_item_ids is not null) then
988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );

Line 988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);

984: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
985: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
986: end if;
987: if(l_item_ids is not null) then
988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);

Line 989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );

985: dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
986: end if;
987: if(l_item_ids is not null) then
988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);

Line 990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);

986: end if;
987: if(l_item_ids is not null) then
988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);

Line 991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);

987: if(l_item_ids is not null) then
988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);

Line 992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);

988: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);

Line 993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);

989: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
997: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);

Line 994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);

990: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
997: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
998: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);

Line 995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);

991: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
997: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
998: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
999:

Line 996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);

992: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
997: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
998: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
999:
1000: end if;

Line 997: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);

993: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
997: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
998: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
999:
1000: end if;
1001:

Line 998: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);

994: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
995: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
996: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
997: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
998: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
999:
1000: end if;
1001:
1002: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');

Line 1002: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');

998: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
999:
1000: end if;
1001:
1002: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1003: l_dummy := dbms_sql.execute(l_cursor);
1004: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1005: LOOP
1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;

Line 1003: l_dummy := dbms_sql.execute(l_cursor);

999:
1000: end if;
1001:
1002: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1003: l_dummy := dbms_sql.execute(l_cursor);
1004: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1005: LOOP
1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1007: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');

Line 1004: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');

1000: end if;
1001:
1002: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1003: l_dummy := dbms_sql.execute(l_cursor);
1004: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1005: LOOP
1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1007: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);

Line 1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;

1002: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1003: l_dummy := dbms_sql.execute(l_cursor);
1004: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1005: LOOP
1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1007: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);

Line 1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);

1004: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1005: LOOP
1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1007: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);

Line 1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);

1005: LOOP
1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1007: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);

Line 1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);

1006: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1007: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);

Line 1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);

1007: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);

Line 1012: dbms_sql.column_value(l_cursor, 5, l_qpa);

1008: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1016: dbms_sql.column_value(l_cursor, 9, l_uom_code);

Line 1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);

1009: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1016: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1017: dbms_sql.column_value(l_cursor, 10, l_yield);

Line 1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);

1010: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1016: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1017: dbms_sql.column_value(l_cursor, 10, l_yield);
1018:

Line 1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);

1011: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1016: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1017: dbms_sql.column_value(l_cursor, 10, l_yield);
1018:
1019: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components:add_critical_component=l_inv_item_id='||l_inv_item_id||

Line 1016: dbms_sql.column_value(l_cursor, 9, l_uom_code);

1012: dbms_sql.column_value(l_cursor, 5, l_qpa);
1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1016: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1017: dbms_sql.column_value(l_cursor, 10, l_yield);
1018:
1019: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components:add_critical_component=l_inv_item_id='||l_inv_item_id||
1020: ',l_qpa='||l_qpa||',l_req_qty='||l_req_qty||',l_qty_issued='||l_qty_issued||

Line 1017: dbms_sql.column_value(l_cursor, 10, l_yield);

1013: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1014: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1015: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1016: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1017: dbms_sql.column_value(l_cursor, 10, l_yield);
1018:
1019: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components:add_critical_component=l_inv_item_id='||l_inv_item_id||
1020: ',l_qpa='||l_qpa||',l_req_qty='||l_req_qty||',l_qty_issued='||l_qty_issued||
1021: ',l_op_open_qty='||g_wip_job_op_tbl(i).OPEN_QTY||

Line 1080: dbms_sql.close_cursor(l_cursor);

1076: end if;
1077: END LOOP;
1078:
1079:
1080: dbms_sql.close_cursor(l_cursor);
1081:
1082: END LOOP;
1083: END IF;
1084: --EXCEPTION

Line 1086: -- dbms_sql.close_cursor(l_cursor);

1082: END LOOP;
1083: END IF;
1084: --EXCEPTION
1085: -- WHEN OTHERS THEN
1086: -- dbms_sql.close_cursor(l_cursor);
1087:
1088: END get_job_critical_components;
1089:
1090: