APPS.MSC_WS_OTM_BPEL dependencies on MSC_EXCEPTION_DETAILS

Line 521: from msc_exception_details

517: end if;
518:
519: select count(1)
520: into count_exc_this_order
521: from msc_exception_details
522: where exception_type = excType
523: and plan_id = planId
524: and organization_id =v_org_id
525: and inventory_item_id =v_inv_item_id

Line 532: update msc_exception_details

528: and supplier_id = v_supplier_id
529: and order_number =v_order_number;
530:
531: if ( count_exc_this_order > 0) then
532: update msc_exception_details
533: set date2=newArrivalDate
534: where exception_type = excType
535: and plan_id = planId
536: and organization_id =v_org_id

Line 595: INSERT into msc_exception_details

591: and exception_type = excType;
592:
593: end if;
594:
595: INSERT into msc_exception_details
596: (
597: exception_detail_id, exception_type, plan_id, organization_id, inventory_item_id, resource_id, -- -1
598: department_id, sr_Instance_id, LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
599: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,

Line 603: VALUES (MSC_EXCEPTION_DETAILS_S.nextval, excType, planId, v_org_id, v_inv_item_id, -1,

599: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,
600: transaction_id
601: )
602:
603: VALUES (MSC_EXCEPTION_DETAILS_S.nextval, excType, planId, v_org_id, v_inv_item_id, -1,
604: -1, srInstanceId, SYSDATE, userId, SYSDATE, userId,
605: v_supplier_id, v_supplier_site_id, v_order_number, newArrivalDate, v_old_dock_date,v_q, v_sr_org_id, v_source_sr_inst_id,
606: supp_Transaction_id);
607:

Line 710: from msc_exception_details

706:
707:
708: select count(1)
709: into count_exc_this_order
710: from msc_exception_details
711: where exception_type = excType
712: and plan_id = planId
713: and organization_id =v_org_id
714: and inventory_item_id =v_inv_item_id

Line 721: update msc_exception_details

717: and supplier_id = v_supplier_id
718: and order_number =v_order_number;
719:
720: if ( count_exc_this_order > 0) then
721: update msc_exception_details
722: set date2=newArrivalDate
723: where exception_type = excType
724: and plan_id = planId
725: and organization_id =v_org_id

Line 791: INSERT into msc_exception_details

787:
788: end if;
789:
790: --dbms_output.put_line(supp_Transaction_id);
791: INSERT into msc_exception_details
792: (
793: exception_detail_id, exception_type, plan_id, organization_id, inventory_item_id, resource_id, -- -1
794: department_id, sr_Instance_id, LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
795: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,

Line 799: VALUES (MSC_EXCEPTION_DETAILS_S.nextval, excType, planId, v_org_id, v_inv_item_id, -1,

795: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,
796: transaction_id
797: )
798:
799: VALUES (MSC_EXCEPTION_DETAILS_S.nextval, excType, planId, v_org_id, v_inv_item_id, -1,
800: -1, srInstanceId, SYSDATE, userId, SYSDATE, userId,
801: v_supplier_id, v_supplier_site_id, v_order_number, newArrivalDate, v_old_dock_date, v_q,
802: v_sr_org_id, v_source_sr_Inst_id, supp_Transaction_id);
803: