APPS.MSC_WS_ATP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 37

          InsertFlag                    IN MscNumberArr ,
          OEFlag                        IN MscChar1Arr ,
          OrderNumber                   IN MscNumberArr ,
          OldSourceOrganizationId       IN MscNumberArr ,
          OldDemandClass                IN MscChar30Arr ,
          Attribute01                   IN MscNumberArr ,
          Attribute02                   IN MscNumberArr ,
          CustomerCountry               IN MscChar60Arr ,
          CustomerState                 IN MscChar60Arr ,
          CustomerCity                  IN MscChar60Arr ,
          CustomerPostalCode            IN MscChar60Arr ,
          SubstitutionTypeCode          IN MscNumberArr ,
          ReqItemDetailFlag             IN MscNumberArr ,
          SalesRep                      IN MscChar255Arr ,
          CustomerContact               IN MscChar255Arr ,
          TopModelLineId                IN MscNumberArr ,
          ATOParentModelLineId          IN MscNumberArr ,
          ATOModelLineId                IN MscNumberArr ,
          ParentLineId                  IN MscNumberArr ,
          MatchItemId                   IN MscNumberArr ,
          ConfigItemLineId              IN MscNumberArr ,
          ValidationOrg                 IN MscNumberArr ,
          ComponentSequenceID           IN MscNumberArr ,
          ComponentCode                 IN MscChar255Arr ,
          LineNumber                    IN MscChar80Arr ,
          IncludedItemFlag              IN MscNumberArr ,
          PickComponentsFlag            IN MscChar1Arr ,
          CascadeModelInfoToComp        IN MscNumberArr ,
          SequenceNumber                IN MscNumberArr ,
          InternalOrgId                 IN MscNumberArr ,
          PartySiteId                   IN MscNumberArr ,
          PartOfSet                     IN MscChar1Arr ,

          InstanceIdOut                 OUT nocopy MscNumberArr,
          InventoryItemIdOut            OUT nocopy MscNumberArr,
          InventoryItemNameOut          OUT nocopy MscChar40Arr,
          SourceOrganizationIdOut       OUT nocopy MscNumberArr,
          SourceOrganizationCodeOut     OUT nocopy MscChar7Arr,
          OrganizationIdOut             OUT nocopy MscNumberArr,
          IdentifierOut                 OUT nocopy MscNumberArr,
          DemandSourceHeaderIdOut       OUT nocopy MscNumberArr,
          DemandSourceDeliveryOut       OUT nocopy MscChar30Arr,
          DemandSourceTypeOut           OUT nocopy MscNumberArr,
          CustomerIdOut                 OUT nocopy MscNumberArr,
          CustomerSiteIdOut             OUT nocopy MscNumberArr,
          QuanitytOrderedOut            OUT nocopy MscNumberArr,
          QuantityUOMOut                OUT nocopy MscChar3Arr,
          RequestedShipDateOut          OUT nocopy MscDateArr,
          RequestedArrivalDateOut       OUT nocopy MscDateArr,
          LatestAcceptableDateOut       OUT nocopy MscDateArr,
          DeliveryLeadTimeOut           OUT nocopy MscNumberArr,
          ShipMethodOut                 OUT nocopy MscChar30Arr,
          DemandClassOut                OUT nocopy MscChar30Arr,
          ShipSetNameOut                OUT nocopy MscChar30Arr,
          ArrivalSetNameOut             OUT nocopy MscChar30Arr,
          OverrideFlagOut               OUT nocopy MscChar1Arr,
          ShipDateOut                   OUT nocopy MscDateArr,
          ArrivalDateOut                OUT nocopy MscDateArr,
          AvailableQuantityOut          OUT nocopy MscNumberArr,
          RequestedDateQuantityOut      OUT nocopy MscNumberArr,
          GroupShipDateOut              OUT nocopy MscDateArr,
          GroupArrivalDateOut           OUT nocopy MscDateArr,
          AtpLeadTimeOut                OUT nocopy MscNumberArr,
          ErrorCodeOut                  OUT nocopy MscNumberArr,
          EndPeggingIdOut               OUT nocopy MscNumberArr,
          OldSourceOrganizationIdOut    OUT nocopy MscNumberArr,
          OldDemandClassOut             OUT nocopy MscChar30Arr,
          RequestItemIdOut              OUT nocopy MscNumberArr,
          ReqItemReqDateQtyOut          OUT nocopy MscNumberArr,
          ReqItemAvailableDateOut       OUT nocopy MscDateArr,
          ReqItemAvailableDateQtyOut    OUT nocopy MscNumberArr,
          RequestItemNameOut            OUT nocopy MscChar40Arr,
          OldInventoryItemIdOut         OUT nocopy MscNumberArr,
          SubstFlagOut                  OUT nocopy MscNumberArr,
          BaseModelIdOut                OUT nocopy MscNumberArr,
          OssErrorCodeOut               OUT nocopy MscNumberArr,
          MatchedItemNameOut            OUT nocopy MscChar255Arr,
          CascadeModelInfoToCompOut     OUT nocopy MscNumberArr,
          PlanIdOut                     OUT nocopy MscNumberArr
          ) is

          sessionId              NUMBER :=0;

Line: 366

         IF (InsertFlag is not NULL  and InsertFlag.Count <>0 AND InsertFlag.Count <> ln) THEN
                 parameterName := 'InsertFlag';

Line: 532

          SELECT responsibility_id,  application_id INTO respId, appId FROM fnd_responsibility WHERE responsibility_key = 'SYSTEM_ADMINISTRATOR';

Line: 535

          SELECT user_id            INTO userId FROM fnd_user WHERE user_name = 'SYSADMIN';

Line: 548

              SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;

Line: 653

           IF InsertFlag is not NULL and InsertFlag.Count <>0 THEN
                FOR i IN 1 .. ln LOOP p_atp_table.Insert_Flag (i) := InsertFlag(i);   END LOOP ;

Line: 770

         dbms_output.put_line('InsertFlag = ' || p_atp_table.Insert_Flag(i)) ;

Line: 974

           InsertFlag                    IN MscNumberArr ,
           OEFlag                        IN MscChar1Arr ,
           OrderNumber                   IN MscNumberArr ,
           OldSourceOrganizationId       IN MscNumberArr ,
           OldDemandClass                IN MscChar30Arr ,
           Attribute01                   IN MscNumberArr ,
           Attribute02                   IN MscNumberArr ,
           CustomerCountry               IN MscChar60Arr ,
           CustomerState                 IN MscChar60Arr ,
           CustomerCity                  IN MscChar60Arr ,
           CustomerPostalCode            IN MscChar60Arr ,
           SubstitutionTypeCode          IN MscNumberArr ,
           ReqItemDetailFlag             IN MscNumberArr ,
           SalesRep                      IN MscChar255Arr ,
           CustomerContact               IN MscChar255Arr ,
           TopModelLineId                IN MscNumberArr ,
           ATOParentModelLineId          IN MscNumberArr ,
           ATOModelLineId                IN MscNumberArr ,
           ParentLineId                  IN MscNumberArr ,
           MatchItemId                   IN MscNumberArr ,
           ConfigItemLineId              IN MscNumberArr ,
           ValidationOrg                 IN MscNumberArr ,
           ComponentSequenceID           IN MscNumberArr ,
           ComponentCode                 IN MscChar255Arr ,
           LineNumber                    IN MscChar80Arr ,
           IncludedItemFlag              IN MscNumberArr ,
           PickComponentsFlag            IN MscChar1Arr ,
           CascadeModelInfoToComp        IN MscNumberArr ,
           SequenceNumber                IN MscNumberArr ,
           InternalOrgId                 IN MscNumberArr ,
           PartySiteId                   IN MscNumberArr ,
           PartOfSet                     IN MscChar1Arr ,

           InstanceIdOut                 OUT nocopy MscNumberArr,
           InventoryItemIdOut            OUT nocopy MscNumberArr,
           InventoryItemNameOut          OUT nocopy MscChar40Arr,
           SourceOrganizationIdOut       OUT nocopy MscNumberArr,
           SourceOrganizationCodeOut     OUT nocopy MscChar7Arr,
           OrganizationIdOut             OUT nocopy MscNumberArr,
           IdentifierOut                 OUT nocopy MscNumberArr,
           DemandSourceHeaderIdOut       OUT nocopy MscNumberArr,
           DemandSourceDeliveryOut       OUT nocopy MscChar30Arr,
           DemandSourceTypeOut           OUT nocopy MscNumberArr,
           CustomerIdOut                 OUT nocopy MscNumberArr,
           CustomerSiteIdOut             OUT nocopy MscNumberArr,
           QuanitytOrderedOut            OUT nocopy MscNumberArr,
           QuantityUOMOut                OUT nocopy MscChar3Arr,
           RequestedShipDateOut          OUT nocopy MscDateArr,
           RequestedArrivalDateOut       OUT nocopy MscDateArr,
           LatestAcceptableDateOut       OUT nocopy MscDateArr,
           DeliveryLeadTimeOut           OUT nocopy MscNumberArr,
           ShipMethodOut                 OUT nocopy MscChar30Arr,
           DemandClassOut                OUT nocopy MscChar30Arr,
           ShipSetNameOut                OUT nocopy MscChar30Arr,
           ArrivalSetNameOut             OUT nocopy MscChar30Arr,
           OverrideFlagOut               OUT nocopy MscChar1Arr,
           ShipDateOut                   OUT nocopy MscDateArr,
           ArrivalDateOut                OUT nocopy MscDateArr,
           AvailableQuantityOut          OUT nocopy MscNumberArr,
           RequestedDateQuantityOut      OUT nocopy MscNumberArr,
           GroupShipDateOut              OUT nocopy MscDateArr,
           GroupArrivalDateOut           OUT nocopy MscDateArr,
           AtpLeadTimeOut                OUT nocopy MscNumberArr,
           ErrorCodeOut                  OUT nocopy MscNumberArr,
           EndPeggingIdOut               OUT nocopy MscNumberArr,
           OldSourceOrganizationIdOut    OUT nocopy MscNumberArr,
           OldDemandClassOut             OUT nocopy MscChar30Arr,
           RequestItemIdOut              OUT nocopy MscNumberArr,
           ReqItemReqDateQtyOut          OUT nocopy MscNumberArr,
           ReqItemAvailableDateOut       OUT nocopy MscDateArr,
           ReqItemAvailableDateQtyOut    OUT nocopy MscNumberArr,
           RequestItemNameOut            OUT nocopy MscChar40Arr,
           OldInventoryItemIdOut         OUT nocopy MscNumberArr,
           SubstFlagOut                  OUT nocopy MscNumberArr,
           BaseModelIdOut                OUT nocopy MscNumberArr,
           OssErrorCodeOut               OUT nocopy MscNumberArr,
           MatchedItemNameOut            OUT nocopy MscChar255Arr,
           CascadeModelInfoToCompOut     OUT nocopy MscNumberArr,
           PlanIdOut                     OUT nocopy MscNumberArr
           )AS
 		     userid    number;

Line: 1147

           					InsertFlag  ,
           					OEFlag  ,
           					OrderNumber ,
           					OldSourceOrganizationId,
           					OldDemandClass ,
           					Attribute01  ,
           					Attribute02,
           					CustomerCountry  ,
           					CustomerState  ,
           					CustomerCity ,
           					CustomerPostalCode ,
           					SubstitutionTypeCode ,
          					ReqItemDetailFlag  ,
           					SalesRep ,
           					CustomerContact  ,
           					TopModelLineId ,
           					ATOParentModelLineId ,
           					ATOModelLineId ,
           					ParentLineId ,
           					MatchItemId  ,
           					ConfigItemLineId ,
           					ValidationOrg ,
           					ComponentSequenceID ,
           					ComponentCode ,
           					LineNumber ,
           					IncludedItemFlag  ,
           					PickComponentsFlag ,
           					CascadeModelInfoToComp  ,
           					SequenceNumber,
          				        InternalOrgId ,
           					PartySiteId ,
           					PartOfSet ,

           					InstanceIdOut,
           					InventoryItemIdOut,
           					InventoryItemNameOut,
           					SourceOrganizationIdOut ,
           					SourceOrganizationCodeOut,
           					OrganizationIdOut ,
           					IdentifierOut,
           					DemandSourceHeaderIdOut ,
           					DemandSourceDeliveryOut,
           					DemandSourceTypeOut,
           					CustomerIdOut ,
           					CustomerSiteIdOut,
           					QuanitytOrderedOut,
           					QuantityUOMOut ,
           					RequestedShipDateOut   ,
           					RequestedArrivalDateOut ,
           					LatestAcceptableDateOut,
           					DeliveryLeadTimeOut ,
           					ShipMethodOut ,
           					DemandClassOut,
           					ShipSetNameOut ,
           					ArrivalSetNameOut,
           					OverrideFlagOut,
           					ShipDateOut ,
           					ArrivalDateOut ,
           					AvailableQuantityOut ,
           					RequestedDateQuantityOut,
           					GroupShipDateOut,
           					GroupArrivalDateOut,
           					AtpLeadTimeOut ,
           					ErrorCodeOut ,
           					EndPeggingIdOut ,
           					OldSourceOrganizationIdOut,
           					OldDemandClassOut,
           					RequestItemIdOut,
           					ReqItemReqDateQtyOut ,
           					ReqItemAvailableDateOut,
           					ReqItemAvailableDateQtyOut,
           					RequestItemNameOut,
           					OldInventoryItemIdOut ,
           					SubstFlagOut ,
           					BaseModelIdOut,
           					OssErrorCodeOut,
           					MatchedItemNameOut ,
           					CascadeModelInfoToCompOut,
           					PlanIdOut  );