APPS.MSC_WS_OTM_BPEL dependencies on MSC_ITEM_EXCEPTIONS

Line 576: from msc_item_exceptions

572:
573:
574: select count(1)
575: into countItemExc
576: from msc_item_exceptions
577: where plan_id = planId
578: and organization_id = v_org_id
579: and sr_Instance_id = srInstanceId
580: and inventory_item_id = v_inv_item_id

Line 586: INSERT INTO msc_item_exceptions(plan_id, organization_id, sr_Instance_id, inventory_item_id, exception_type,

582:
583:
584:
585: if ( countItemExc = 0) then
586: INSERT INTO msc_item_exceptions(plan_id, organization_id, sr_Instance_id, inventory_item_id, exception_type,
587: exception_group,
588: LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
589: supplier_id, supplier_site_id, exception_count)
590: VALUES(planId, v_org_id, srInstanceId,v_inv_item_id, excType,

Line 598: from msc_item_exceptions

594:
595: else
596: select exception_count
597: into countItemExc
598: from msc_item_exceptions
599: where plan_id = planId
600: and organization_id = v_org_id
601: and sr_Instance_id = srInstanceId
602: and inventory_item_id = v_inv_item_id

Line 608: update msc_item_exceptions

604:
605: countItemExc := countItemExc +1;
606: --dbms_output.put_line('countExc=' || countItemExc);
607:
608: update msc_item_exceptions
609: set exception_count = countItemExc,
610: LAST_UPDATE_DATE = SYSDATE,
611: LAST_UPDATED_BY = userId
612: where plan_id = planId

Line 763: from msc_item_exceptions

759: end if;
760:
761: select count(1)
762: into countItemExc
763: from msc_item_exceptions
764: where plan_id = planId
765: and organization_id = v_org_id
766: and sr_Instance_id = srInstanceId
767: and inventory_item_id = v_inv_item_id

Line 774: INSERT INTO msc_item_exceptions(plan_id, organization_id, sr_Instance_id, inventory_item_id, exception_type,

770: --dbms_output.put_line('countItemExec=' || countItemExc);
771:
772:
773: if ( countItemExc = 0) then
774: INSERT INTO msc_item_exceptions(plan_id, organization_id, sr_Instance_id, inventory_item_id, exception_type,
775: exception_group,
776: LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
777: supplier_id, supplier_site_id, exception_count)
778: VALUES(planId, v_org_id, srInstanceId,v_inv_item_id, excType,

Line 792: from msc_item_exceptions

788: dbms_output.put_line('excType=' || excType);*/
789:
790: select exception_count
791: into countItemExc
792: from msc_item_exceptions
793: where plan_id = planId
794: and organization_id = v_org_id
795: and sr_Instance_id = srInstanceId
796: and inventory_item_id = v_inv_item_id

Line 802: update msc_item_exceptions

798:
799: countItemExc := countItemExc +1;
800: --dbms_output.put_line('countExc=' || countItemExc);
801:
802: update msc_item_exceptions
803: set exception_count = countItemExc,
804: LAST_UPDATE_DATE = SYSDATE,
805: LAST_UPDATED_BY = userId
806: where plan_id = planId