APPS.MSC_WS_OTM_BPEL dependencies on MSC_EXCEPTION_DETAILS

Line 546: from msc_exception_details

542: end if;
543:
544: select count(1)
545: into count_exc_this_order
546: from msc_exception_details
547: where exception_type = excType
548: and plan_id = planId
549: and organization_id =v_org_id
550: and inventory_item_id =v_inv_item_id

Line 557: update msc_exception_details

553: and supplier_id = v_supplier_id
554: and order_number =v_order_number;
555:
556: if ( count_exc_this_order > 0) then
557: update msc_exception_details
558: set date2=newArrivalDate
559: where exception_type = excType
560: and plan_id = planId
561: and organization_id =v_org_id

Line 620: INSERT into msc_exception_details

616: and exception_type = excType;
617:
618: end if;
619:
620: INSERT into msc_exception_details
621: (
622: exception_detail_id, exception_type, plan_id, organization_id, inventory_item_id, resource_id, -- -1
623: department_id, sr_Instance_id, LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
624: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,

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

624: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,
625: transaction_id
626: )
627:
628: VALUES (MSC_EXCEPTION_DETAILS_S.nextval, excType, planId, v_org_id, v_inv_item_id, -1,
629: -1, srInstanceId, SYSDATE, userId, SYSDATE, userId,
630: 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,
631: supp_Transaction_id);
632:

Line 735: from msc_exception_details

731:
732:
733: select count(1)
734: into count_exc_this_order
735: from msc_exception_details
736: where exception_type = excType
737: and plan_id = planId
738: and organization_id =v_org_id
739: and inventory_item_id =v_inv_item_id

Line 746: update msc_exception_details

742: and supplier_id = v_supplier_id
743: and order_number =v_order_number;
744:
745: if ( count_exc_this_order > 0) then
746: update msc_exception_details
747: set date2=newArrivalDate
748: where exception_type = excType
749: and plan_id = planId
750: and organization_id =v_org_id

Line 816: INSERT into msc_exception_details

812:
813: end if;
814:
815: --dbms_output.put_line(supp_Transaction_id);
816: INSERT into msc_exception_details
817: (
818: exception_detail_id, exception_type, plan_id, organization_id, inventory_item_id, resource_id, -- -1
819: department_id, sr_Instance_id, LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE ,CREATED_BY,
820: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,

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

820: supplier_id, supplier_site_id, order_number, date2, date1, quantity, number1, number2,
821: transaction_id
822: )
823:
824: VALUES (MSC_EXCEPTION_DETAILS_S.nextval, excType, planId, v_org_id, v_inv_item_id, -1,
825: -1, srInstanceId, SYSDATE, userId, SYSDATE, userId,
826: v_supplier_id, v_supplier_site_id, v_order_number, newArrivalDate, v_old_dock_date, v_q,
827: v_sr_org_id, v_source_sr_Inst_id, supp_Transaction_id);
828: