APPS.MSC_WS_OTM_BPEL dependencies on MSC_ITEM_EXCEPTIONS

Line 551: from msc_item_exceptions

547:
548:
549: select count(1)
550: into countItemExc
551: from msc_item_exceptions
552: where plan_id = planId
553: and organization_id = v_org_id
554: and sr_Instance_id = srInstanceId
555: and inventory_item_id = v_inv_item_id

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

557:
558:
559:
560: if ( countItemExc = 0) then
561: INSERT INTO msc_item_exceptions(plan_id, organization_id, sr_Instance_id, inventory_item_id, exception_type,
562: exception_group,
563: LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
564: supplier_id, supplier_site_id, exception_count)
565: VALUES(planId, v_org_id, srInstanceId,v_inv_item_id, excType,

Line 573: from msc_item_exceptions

569:
570: else
571: select exception_count
572: into countItemExc
573: from msc_item_exceptions
574: where plan_id = planId
575: and organization_id = v_org_id
576: and sr_Instance_id = srInstanceId
577: and inventory_item_id = v_inv_item_id

Line 583: update msc_item_exceptions

579:
580: countItemExc := countItemExc +1;
581: --dbms_output.put_line('countExc=' || countItemExc);
582:
583: update msc_item_exceptions
584: set exception_count = countItemExc,
585: LAST_UPDATE_DATE = SYSDATE,
586: LAST_UPDATED_BY = userId
587: where plan_id = planId

Line 738: from msc_item_exceptions

734: end if;
735:
736: select count(1)
737: into countItemExc
738: from msc_item_exceptions
739: where plan_id = planId
740: and organization_id = v_org_id
741: and sr_Instance_id = srInstanceId
742: and inventory_item_id = v_inv_item_id

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

745: --dbms_output.put_line('countItemExec=' || countItemExc);
746:
747:
748: if ( countItemExc = 0) then
749: INSERT INTO msc_item_exceptions(plan_id, organization_id, sr_Instance_id, inventory_item_id, exception_type,
750: exception_group,
751: LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
752: supplier_id, supplier_site_id, exception_count)
753: VALUES(planId, v_org_id, srInstanceId,v_inv_item_id, excType,

Line 767: from msc_item_exceptions

763: dbms_output.put_line('excType=' || excType);*/
764:
765: select exception_count
766: into countItemExc
767: from msc_item_exceptions
768: where plan_id = planId
769: and organization_id = v_org_id
770: and sr_Instance_id = srInstanceId
771: and inventory_item_id = v_inv_item_id

Line 777: update msc_item_exceptions

773:
774: countItemExc := countItemExc +1;
775: --dbms_output.put_line('countExc=' || countItemExc);
776:
777: update msc_item_exceptions
778: set exception_count = countItemExc,
779: LAST_UPDATE_DATE = SYSDATE,
780: LAST_UPDATED_BY = userId
781: where plan_id = planId