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 648: l_cursor := dbms_sql.open_cursor;

644: l_sql := l_sql || ' order by inventory_item_id ';
645:
646: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: l_sql='||l_sql );
647:
648: l_cursor := dbms_sql.open_cursor;
649: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
650: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
651: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);

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

645:
646: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: l_sql='||l_sql );
647:
648: l_cursor := dbms_sql.open_cursor;
649: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
650: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
651: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
653: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);

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

646: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: l_sql='||l_sql );
647:
648: l_cursor := dbms_sql.open_cursor;
649: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
650: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
651: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
653: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
654: if(l_cat_ids is not null) then

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

647:
648: l_cursor := dbms_sql.open_cursor;
649: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
650: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
651: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
653: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
654: if(l_cat_ids is not null) then
655: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);

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

648: l_cursor := dbms_sql.open_cursor;
649: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
650: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
651: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
653: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
654: if(l_cat_ids is not null) then
655: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
656: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);

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

649: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
650: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
651: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
653: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
654: if(l_cat_ids is not null) then
655: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
656: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
657: -- Bug 14169271: Bind variables in l_cat_clause

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

651: dbms_sql.define_column(l_cursor, 2, l_subinv_code,10);
652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
653: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
654: if(l_cat_ids is not null) then
655: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
656: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
657: -- Bug 14169271: Bind variables in l_cat_clause
658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);

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

652: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
653: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
654: if(l_cat_ids is not null) then
655: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
656: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
657: -- Bug 14169271: Bind variables in l_cat_clause
658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);

Line 658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);

654: if(l_cat_ids is not null) then
655: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
656: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
657: -- Bug 14169271: Bind variables in l_cat_clause
658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
661: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
662: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);

Line 659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);

655: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
656: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
657: -- Bug 14169271: Bind variables in l_cat_clause
658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
661: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
662: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
663: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);

Line 660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);

656: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
657: -- Bug 14169271: Bind variables in l_cat_clause
658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
661: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
662: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
663: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
664: end if;

Line 661: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);

657: -- Bug 14169271: Bind variables in l_cat_clause
658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
661: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
662: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
663: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
664: end if;
665:

Line 662: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);

658: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
661: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
662: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
663: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
664: end if;
665:
666: if(l_item_ids is not null) then

Line 663: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);

659: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
660: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
661: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
662: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
663: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
664: end if;
665:
666: if(l_item_ids is not null) then
667: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);

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

663: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
664: end if;
665:
666: if(l_item_ids is not null) then
667: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
668: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
669: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);

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

664: end if;
665:
666: if(l_item_ids is not null) then
667: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
668: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
669: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);

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

665:
666: if(l_item_ids is not null) then
667: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
668: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
669: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);

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

666: if(l_item_ids is not null) then
667: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
668: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
669: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);

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

667: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
668: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
669: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
675: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);

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

668: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
669: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
675: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
676: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);

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

669: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
675: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
676: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
677: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);

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

670: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
675: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
676: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
677: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
678:

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

671: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
675: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
676: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
677: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
678:
679: end if;

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

672: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
675: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
676: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
677: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
678:
679: end if;
680:

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

673: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
674: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
675: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
676: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
677: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
678:
679: end if;
680:
681: l_dummy := dbms_sql.execute(l_cursor);

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

677: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
678:
679: end if;
680:
681: l_dummy := dbms_sql.execute(l_cursor);
682:
683: LOOP
684: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
685: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);

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

680:
681: l_dummy := dbms_sql.execute(l_cursor);
682:
683: LOOP
684: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
685: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
686: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
687: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: component='||l_inv_item_id||', subinv_code='||l_subinv_code );
688: if(l_inv_item_id <> l_old_inv_item_id) then

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

681: l_dummy := dbms_sql.execute(l_cursor);
682:
683: LOOP
684: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
685: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
686: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
687: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: component='||l_inv_item_id||', subinv_code='||l_subinv_code );
688: if(l_inv_item_id <> l_old_inv_item_id) then
689: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: calling orgonhand for component='||l_inv_item_id );

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

682:
683: LOOP
684: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
685: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
686: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
687: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: component='||l_inv_item_id||', subinv_code='||l_subinv_code );
688: if(l_inv_item_id <> l_old_inv_item_id) then
689: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_pref_critical_components: calling orgonhand for component='||l_inv_item_id );
690: l_comp_avail := get_org_component_onhand(p_org_id, l_inv_item_id);

Line 705: dbms_sql.close_cursor(l_cursor);

701: 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);
702: end if;
703: l_old_inv_item_id := l_inv_item_id;
704: END LOOP;
705: dbms_sql.close_cursor(l_cursor);
706:
707:
708: EXCEPTION
709: WHEN OTHERS THEN

Line 710: dbms_sql.close_cursor(l_cursor);

706:
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: dbms_sql.close_cursor(l_cursor);
711:
712: END get_pref_critical_components;
713:
714:

Line 766: l_cursor := dbms_sql.open_cursor;

762: l_sql := l_sql || ' wo.operation_seq_num ';
763:
764: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:l_sql='||l_sql);
765:
766: l_cursor := dbms_sql.open_cursor;
767: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
768: dbms_sql.define_column(l_cursor, 1, l_org_id);
769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);

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

763:
764: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:l_sql='||l_sql);
765:
766: l_cursor := dbms_sql.open_cursor;
767: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
768: dbms_sql.define_column(l_cursor, 1, l_org_id);
769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);

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

764: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:l_sql='||l_sql);
765:
766: l_cursor := dbms_sql.open_cursor;
767: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
768: dbms_sql.define_column(l_cursor, 1, l_org_id);
769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );

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

765:
766: l_cursor := dbms_sql.open_cursor;
767: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
768: dbms_sql.define_column(l_cursor, 1, l_org_id);
769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );

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

766: l_cursor := dbms_sql.open_cursor;
767: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
768: dbms_sql.define_column(l_cursor, 1, l_org_id);
769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );

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

767: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
768: dbms_sql.define_column(l_cursor, 1, l_org_id);
769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );

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

768: dbms_sql.define_column(l_cursor, 1, l_org_id);
769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
776:

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

769: dbms_sql.define_column(l_cursor, 2, l_wip_ent_id);
770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
776:
777: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);

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

770: dbms_sql.define_column(l_cursor, 3, l_dept_id);
771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
776:
777: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
778: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);

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

771: dbms_sql.define_column(l_cursor, 4, l_op_seq_num);
772: dbms_sql.define_column(l_cursor, 5, l_op_fusd );
773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
776:
777: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
778: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
779: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);

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

773: dbms_sql.define_column(l_cursor, 6, l_op_sch_qty );
774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
776:
777: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
778: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
779: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
780:
781: l_dummy := dbms_sql.execute(l_cursor);

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

774: dbms_sql.define_column(l_cursor, 7, l_op_start_qty );
775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
776:
777: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
778: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
779: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
780:
781: l_dummy := dbms_sql.execute(l_cursor);
782: i := 0;

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

775: dbms_sql.define_column(l_cursor, 8, l_op_open_qty );
776:
777: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
778: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
779: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
780:
781: l_dummy := dbms_sql.execute(l_cursor);
782: i := 0;
783: LOOP

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

777: dbms_sql.bind_variable(l_cursor, ':org_id', p_org_id);
778: dbms_sql.bind_variable(l_cursor, ':shift_end_time', p_end_time);
779: dbms_sql.bind_variable(l_cursor, ':shift_end_time2', p_end_time);
780:
781: l_dummy := dbms_sql.execute(l_cursor);
782: i := 0;
783: LOOP
784: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
785: dbms_sql.column_value(l_cursor, 1, l_org_id);

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

780:
781: l_dummy := dbms_sql.execute(l_cursor);
782: i := 0;
783: LOOP
784: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
785: dbms_sql.column_value(l_cursor, 1, l_org_id);
786: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);

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

781: l_dummy := dbms_sql.execute(l_cursor);
782: i := 0;
783: LOOP
784: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
785: dbms_sql.column_value(l_cursor, 1, l_org_id);
786: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);

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

782: i := 0;
783: LOOP
784: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
785: dbms_sql.column_value(l_cursor, 1, l_org_id);
786: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
790: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);

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

783: LOOP
784: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
785: dbms_sql.column_value(l_cursor, 1, l_org_id);
786: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
790: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
791: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);

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

784: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
785: dbms_sql.column_value(l_cursor, 1, l_org_id);
786: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
790: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
791: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
792: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);

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

785: dbms_sql.column_value(l_cursor, 1, l_org_id);
786: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
790: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
791: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
792: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
793:

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

786: dbms_sql.column_value(l_cursor, 2, l_wip_ent_id);
787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
790: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
791: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
792: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
793:
794: 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 791: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);

787: dbms_sql.column_value(l_cursor, 3, l_dept_id);
788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
790: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
791: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
792: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
793:
794: 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||
795: ',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 792: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);

788: dbms_sql.column_value(l_cursor, 4, l_op_seq_num);
789: dbms_sql.column_value(l_cursor, 5, l_op_fusd);
790: dbms_sql.column_value(l_cursor, 6, l_op_sch_qty);
791: dbms_sql.column_value(l_cursor, 7, l_op_start_qty);
792: dbms_sql.column_value(l_cursor, 8, l_op_open_qty);
793:
794: 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||
795: ',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||
796: ',l_op_open_qty='||l_op_open_qty||',l_op_sch_qty='||l_op_sch_qty);

Line 808: dbms_sql.close_cursor(l_cursor);

804: g_wip_job_op_tbl(i).OPEN_QTY := l_op_open_qty;
805: g_wip_job_op_tbl(i).SCHEDULED_QTY := l_op_sch_qty;
806: i := i+1;
807: END LOOP;
808: dbms_sql.close_cursor(l_cursor);
809:
810: --call custom hook procedure to reorder operations if necessary
811: begin
812: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:Calling custom procedure for reordering operations');

Line 826: dbms_sql.close_cursor(l_cursor);

822: end;
823:
824: EXCEPTION
825: WHEN OTHERS THEN
826: dbms_sql.close_cursor(l_cursor);
827:
828:
829: END get_job_ops;
830:

Line 1028: l_cursor := dbms_sql.open_cursor;

1024: 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||
1025: ',wip_ent_id='||g_wip_job_op_tbl(i).WIP_ENTITY_ID||',op_seq_num='||g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
1026:
1027:
1028: l_cursor := dbms_sql.open_cursor;
1029: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1030: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);

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

1025: ',wip_ent_id='||g_wip_job_op_tbl(i).WIP_ENTITY_ID||',op_seq_num='||g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
1026:
1027:
1028: l_cursor := dbms_sql.open_cursor;
1029: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1030: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);

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

1026:
1027:
1028: l_cursor := dbms_sql.open_cursor;
1029: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1030: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);

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

1027:
1028: l_cursor := dbms_sql.open_cursor;
1029: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1030: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);

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

1028: l_cursor := dbms_sql.open_cursor;
1029: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1030: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);

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

1029: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1030: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);
1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);

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

1030: dbms_sql.define_column(l_cursor, 1, l_inv_item_id);
1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);
1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);

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

1031: dbms_sql.define_column(l_cursor, 2, l_subinv_code, 10);
1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);
1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
1039: dbms_sql.define_column(l_cursor, 10, l_yield);

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

1032: dbms_sql.define_column(l_cursor, 3, l_req_qty);
1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);
1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
1039: dbms_sql.define_column(l_cursor, 10, l_yield);
1040:

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

1033: dbms_sql.define_column(l_cursor, 4, l_qty_issued);
1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);
1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
1039: dbms_sql.define_column(l_cursor, 10, l_yield);
1040:
1041: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);

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

1034: dbms_sql.define_column(l_cursor, 5, l_qpa);
1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);
1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
1039: dbms_sql.define_column(l_cursor, 10, l_yield);
1040:
1041: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
1042: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);

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

1035: dbms_sql.define_column(l_cursor, 6, l_qty_allocated);
1036: dbms_sql.define_column(l_cursor, 7, l_basis_type);
1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
1039: dbms_sql.define_column(l_cursor, 10, l_yield);
1040:
1041: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
1042: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
1043: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);

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

1037: dbms_sql.define_column(l_cursor, 8, l_wip_supply_type);
1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
1039: dbms_sql.define_column(l_cursor, 10, l_yield);
1040:
1041: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
1042: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
1043: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
1044:
1045: if(l_cat_ids is not null) then

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

1038: dbms_sql.define_column(l_cursor, 9, l_uom_code, 3);
1039: dbms_sql.define_column(l_cursor, 10, l_yield);
1040:
1041: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
1042: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
1043: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
1044:
1045: if(l_cat_ids is not null) then
1046: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);

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

1039: dbms_sql.define_column(l_cursor, 10, l_yield);
1040:
1041: dbms_sql.bind_variable(l_cursor, ':l_org_id', g_wip_job_op_tbl(i).ORGANIZATION_ID);
1042: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
1043: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
1044:
1045: if(l_cat_ids is not null) then
1046: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
1047: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);

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

1042: dbms_sql.bind_variable(l_cursor, ':l_wip_ent_id', g_wip_job_op_tbl(i).WIP_ENTITY_ID);
1043: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
1044:
1045: if(l_cat_ids is not null) then
1046: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
1047: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
1048: -- Bug 14169271: Bind variables in l_cat_clause
1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);

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

1043: dbms_sql.bind_variable(l_cursor, ':l_operation_seq_num', g_wip_job_op_tbl(i).OPERATION_SEQ_NUM);
1044:
1045: if(l_cat_ids is not null) then
1046: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
1047: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
1048: -- Bug 14169271: Bind variables in l_cat_clause
1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);

Line 1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);

1045: if(l_cat_ids is not null) then
1046: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
1047: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
1048: -- Bug 14169271: Bind variables in l_cat_clause
1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
1052: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);

Line 1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);

1046: dbms_sql.bind_variable(l_cursor, ':cat_set_id', g_org_comp_calc_rec.category_set_id);
1047: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
1048: -- Bug 14169271: Bind variables in l_cat_clause
1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
1052: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);

Line 1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);

1047: --dbms_sql.bind_variable(l_cursor, ':cat_ids', l_cat_ids);
1048: -- Bug 14169271: Bind variables in l_cat_clause
1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
1052: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
1055: end if;

Line 1052: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);

1048: -- Bug 14169271: Bind variables in l_cat_clause
1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
1052: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
1055: end if;
1056: if(l_item_ids is not null) then

Line 1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);

1049: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short', g_pref_id_comp_short);
1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
1052: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
1055: end if;
1056: if(l_item_ids is not null) then
1057: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);

Line 1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);

1050: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site', g_pref_level_id_site);
1051: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat_att', g_pref_val_comp_type_cat_att);
1052: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att', g_pref_val_comp_type_att);
1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
1055: end if;
1056: if(l_item_ids is not null) then
1057: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
1058: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );

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

1053: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_cat', g_pref_val_comp_type_cat);
1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
1055: end if;
1056: if(l_item_ids is not null) then
1057: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
1058: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
1059: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);

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

1054: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att', g_pref_val_dtl_org_att);
1055: end if;
1056: if(l_item_ids is not null) then
1057: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
1058: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
1059: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);

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

1055: end if;
1056: if(l_item_ids is not null) then
1057: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
1058: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
1059: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);

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

1056: if(l_item_ids is not null) then
1057: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
1058: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
1059: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);

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

1057: --dbms_sql.bind_variable(l_cursor, ':inv_item_ids', l_item_ids);
1058: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
1059: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
1065: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);

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

1058: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short1', g_pref_id_comp_short );
1059: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
1065: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
1066: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);

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

1059: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site1', g_pref_level_id_site);
1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
1065: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
1066: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
1067: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);

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

1060: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item_att1', g_pref_val_comp_type_item_att);
1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
1065: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
1066: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
1067: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
1068:

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

1061: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short2', g_pref_id_comp_short);
1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
1065: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
1066: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
1067: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
1068:
1069: end if;

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

1062: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site2', g_pref_level_id_site);
1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
1065: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
1066: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
1067: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
1068:
1069: end if;
1070:

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

1063: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_att2', g_pref_val_comp_type_att);
1064: dbms_sql.bind_variable(l_cursor, ':pref_val_comp_type_item2', g_pref_val_comp_type_item);
1065: dbms_sql.bind_variable(l_cursor, ':pref_id_comp_short3', g_pref_id_comp_short);
1066: dbms_sql.bind_variable(l_cursor, ':pref_level_id_site3', g_pref_level_id_site);
1067: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
1068:
1069: end if;
1070:
1071: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');

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

1067: dbms_sql.bind_variable(l_cursor, ':pref_val_dtl_org_att3', g_pref_val_dtl_org_att);
1068:
1069: end if;
1070:
1071: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1072: l_dummy := dbms_sql.execute(l_cursor);
1073: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1074: LOOP
1075: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;

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

1068:
1069: end if;
1070:
1071: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1072: l_dummy := dbms_sql.execute(l_cursor);
1073: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1074: LOOP
1075: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1076: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');

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

1069: end if;
1070:
1071: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1072: l_dummy := dbms_sql.execute(l_cursor);
1073: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1074: LOOP
1075: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1076: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1077: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);

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

1071: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 10 - before dbms_sql.execute');
1072: l_dummy := dbms_sql.execute(l_cursor);
1073: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1074: LOOP
1075: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1076: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1077: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1078: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);

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

1073: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 20 - after dbms_sql.execute');
1074: LOOP
1075: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1076: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1077: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1078: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);

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

1074: LOOP
1075: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1076: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1077: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1078: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);

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

1075: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1076: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1077: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1078: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);

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

1076: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components: point 50');
1077: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1078: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1084: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);

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

1077: dbms_sql.column_value(l_cursor, 1, l_inv_item_id);
1078: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1084: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1085: dbms_sql.column_value(l_cursor, 9, l_uom_code);

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

1078: dbms_sql.column_value(l_cursor, 2, l_subinv_code);
1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1084: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1085: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1086: dbms_sql.column_value(l_cursor, 10, l_yield);

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

1079: dbms_sql.column_value(l_cursor, 3, l_req_qty);
1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1084: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1085: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1086: dbms_sql.column_value(l_cursor, 10, l_yield);
1087:

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

1080: dbms_sql.column_value(l_cursor, 4, l_qty_issued);
1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1084: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1085: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1086: dbms_sql.column_value(l_cursor, 10, l_yield);
1087:
1088: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components:add_critical_component=l_inv_item_id='||l_inv_item_id||

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

1081: dbms_sql.column_value(l_cursor, 5, l_qpa);
1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1084: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1085: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1086: dbms_sql.column_value(l_cursor, 10, l_yield);
1087:
1088: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components:add_critical_component=l_inv_item_id='||l_inv_item_id||
1089: ',l_qpa='||l_qpa||',l_req_qty='||l_req_qty||',l_qty_issued='||l_qty_issued||

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

1082: dbms_sql.column_value(l_cursor, 6, l_qty_allocated);
1083: dbms_sql.column_value(l_cursor, 7, l_basis_type);
1084: dbms_sql.column_value(l_cursor, 8, l_wip_supply_type);
1085: dbms_sql.column_value(l_cursor, 9, l_uom_code);
1086: dbms_sql.column_value(l_cursor, 10, l_yield);
1087:
1088: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_critical_components:add_critical_component=l_inv_item_id='||l_inv_item_id||
1089: ',l_qpa='||l_qpa||',l_req_qty='||l_req_qty||',l_qty_issued='||l_qty_issued||
1090: ',l_op_open_qty='||g_wip_job_op_tbl(i).OPEN_QTY||

Line 1149: dbms_sql.close_cursor(l_cursor);

1145: end if;
1146: END LOOP;
1147:
1148:
1149: dbms_sql.close_cursor(l_cursor);
1150:
1151: END LOOP;
1152: END IF;
1153: --EXCEPTION

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

1151: END LOOP;
1152: END IF;
1153: --EXCEPTION
1154: -- WHEN OTHERS THEN
1155: -- dbms_sql.close_cursor(l_cursor);
1156:
1157: END get_job_critical_components;
1158:
1159: