8: -- =============================================================
9: PROCEDURE GetPromiseDate(
10: status OUT nocopy VARCHAR2,
11:
12: InstanceId IN MscNumberArr ,
13: InventoryItemId IN MscNumberArr,
14: InventoryItemName IN MscChar40Arr,
15: SourceOrganizationId IN MscNumberArr ,
16: SourceOrganizationCode IN MscChar7Arr ,
9: PROCEDURE GetPromiseDate(
10: status OUT nocopy VARCHAR2,
11:
12: InstanceId IN MscNumberArr ,
13: InventoryItemId IN MscNumberArr,
14: InventoryItemName IN MscChar40Arr,
15: SourceOrganizationId IN MscNumberArr ,
16: SourceOrganizationCode IN MscChar7Arr ,
17: OrganizationId IN MscNumberArr ,
11:
12: InstanceId IN MscNumberArr ,
13: InventoryItemId IN MscNumberArr,
14: InventoryItemName IN MscChar40Arr,
15: SourceOrganizationId IN MscNumberArr ,
16: SourceOrganizationCode IN MscChar7Arr ,
17: OrganizationId IN MscNumberArr ,
18: Identifier IN MscNumberArr ,
19: DemandSourceHeaderId IN MscNumberArr ,
13: InventoryItemId IN MscNumberArr,
14: InventoryItemName IN MscChar40Arr,
15: SourceOrganizationId IN MscNumberArr ,
16: SourceOrganizationCode IN MscChar7Arr ,
17: OrganizationId IN MscNumberArr ,
18: Identifier IN MscNumberArr ,
19: DemandSourceHeaderId IN MscNumberArr ,
20: DemandSourceDelivery IN MscChar30Arr ,
21: DemandSourceType IN MscNumberArr ,
14: InventoryItemName IN MscChar40Arr,
15: SourceOrganizationId IN MscNumberArr ,
16: SourceOrganizationCode IN MscChar7Arr ,
17: OrganizationId IN MscNumberArr ,
18: Identifier IN MscNumberArr ,
19: DemandSourceHeaderId IN MscNumberArr ,
20: DemandSourceDelivery IN MscChar30Arr ,
21: DemandSourceType IN MscNumberArr ,
22: CallingModule IN MscNumberArr ,
15: SourceOrganizationId IN MscNumberArr ,
16: SourceOrganizationCode IN MscChar7Arr ,
17: OrganizationId IN MscNumberArr ,
18: Identifier IN MscNumberArr ,
19: DemandSourceHeaderId IN MscNumberArr ,
20: DemandSourceDelivery IN MscChar30Arr ,
21: DemandSourceType IN MscNumberArr ,
22: CallingModule IN MscNumberArr ,
23: CustomerId IN MscNumberArr ,
17: OrganizationId IN MscNumberArr ,
18: Identifier IN MscNumberArr ,
19: DemandSourceHeaderId IN MscNumberArr ,
20: DemandSourceDelivery IN MscChar30Arr ,
21: DemandSourceType IN MscNumberArr ,
22: CallingModule IN MscNumberArr ,
23: CustomerId IN MscNumberArr ,
24: CustomerSiteId IN MscNumberArr ,
25: QuantityOrdered IN MscNumberArr ,
18: Identifier IN MscNumberArr ,
19: DemandSourceHeaderId IN MscNumberArr ,
20: DemandSourceDelivery IN MscChar30Arr ,
21: DemandSourceType IN MscNumberArr ,
22: CallingModule IN MscNumberArr ,
23: CustomerId IN MscNumberArr ,
24: CustomerSiteId IN MscNumberArr ,
25: QuantityOrdered IN MscNumberArr ,
26: QuantityUOM IN MscChar3Arr ,
19: DemandSourceHeaderId IN MscNumberArr ,
20: DemandSourceDelivery IN MscChar30Arr ,
21: DemandSourceType IN MscNumberArr ,
22: CallingModule IN MscNumberArr ,
23: CustomerId IN MscNumberArr ,
24: CustomerSiteId IN MscNumberArr ,
25: QuantityOrdered IN MscNumberArr ,
26: QuantityUOM IN MscChar3Arr ,
27: RequestedShipDate IN MscDateArr,
20: DemandSourceDelivery IN MscChar30Arr ,
21: DemandSourceType IN MscNumberArr ,
22: CallingModule IN MscNumberArr ,
23: CustomerId IN MscNumberArr ,
24: CustomerSiteId IN MscNumberArr ,
25: QuantityOrdered IN MscNumberArr ,
26: QuantityUOM IN MscChar3Arr ,
27: RequestedShipDate IN MscDateArr,
28: RequestedArrivalDate IN MscDateArr ,
21: DemandSourceType IN MscNumberArr ,
22: CallingModule IN MscNumberArr ,
23: CustomerId IN MscNumberArr ,
24: CustomerSiteId IN MscNumberArr ,
25: QuantityOrdered IN MscNumberArr ,
26: QuantityUOM IN MscChar3Arr ,
27: RequestedShipDate IN MscDateArr,
28: RequestedArrivalDate IN MscDateArr ,
29: LatestAcceptableDate IN MscDateArr ,
26: QuantityUOM IN MscChar3Arr ,
27: RequestedShipDate IN MscDateArr,
28: RequestedArrivalDate IN MscDateArr ,
29: LatestAcceptableDate IN MscDateArr ,
30: DeliveryLeadTime IN MscNumberArr ,
31: ShipMethod IN MscChar30Arr ,
32: DemandClass IN MscChar30Arr ,
33: ShipSetName IN MscChar30Arr ,
34: ArrivalSetName IN MscChar30Arr ,
32: DemandClass IN MscChar30Arr ,
33: ShipSetName IN MscChar30Arr ,
34: ArrivalSetName IN MscChar30Arr ,
35: OverrideFlag IN MscChar1Arr ,
36: Action IN MscNumberArr ,
37: InsertFlag IN MscNumberArr ,
38: OEFlag IN MscChar1Arr ,
39: OrderNumber IN MscNumberArr ,
40: OldSourceOrganizationId IN MscNumberArr ,
33: ShipSetName IN MscChar30Arr ,
34: ArrivalSetName IN MscChar30Arr ,
35: OverrideFlag IN MscChar1Arr ,
36: Action IN MscNumberArr ,
37: InsertFlag IN MscNumberArr ,
38: OEFlag IN MscChar1Arr ,
39: OrderNumber IN MscNumberArr ,
40: OldSourceOrganizationId IN MscNumberArr ,
41: OldDemandClass IN MscChar30Arr ,
35: OverrideFlag IN MscChar1Arr ,
36: Action IN MscNumberArr ,
37: InsertFlag IN MscNumberArr ,
38: OEFlag IN MscChar1Arr ,
39: OrderNumber IN MscNumberArr ,
40: OldSourceOrganizationId IN MscNumberArr ,
41: OldDemandClass IN MscChar30Arr ,
42: Attribute01 IN MscNumberArr ,
43: Attribute02 IN MscNumberArr ,
36: Action IN MscNumberArr ,
37: InsertFlag IN MscNumberArr ,
38: OEFlag IN MscChar1Arr ,
39: OrderNumber IN MscNumberArr ,
40: OldSourceOrganizationId IN MscNumberArr ,
41: OldDemandClass IN MscChar30Arr ,
42: Attribute01 IN MscNumberArr ,
43: Attribute02 IN MscNumberArr ,
44: CustomerCountry IN MscChar60Arr ,
38: OEFlag IN MscChar1Arr ,
39: OrderNumber IN MscNumberArr ,
40: OldSourceOrganizationId IN MscNumberArr ,
41: OldDemandClass IN MscChar30Arr ,
42: Attribute01 IN MscNumberArr ,
43: Attribute02 IN MscNumberArr ,
44: CustomerCountry IN MscChar60Arr ,
45: CustomerState IN MscChar60Arr ,
46: CustomerCity IN MscChar60Arr ,
39: OrderNumber IN MscNumberArr ,
40: OldSourceOrganizationId IN MscNumberArr ,
41: OldDemandClass IN MscChar30Arr ,
42: Attribute01 IN MscNumberArr ,
43: Attribute02 IN MscNumberArr ,
44: CustomerCountry IN MscChar60Arr ,
45: CustomerState IN MscChar60Arr ,
46: CustomerCity IN MscChar60Arr ,
47: CustomerPostalCode IN MscChar60Arr ,
44: CustomerCountry IN MscChar60Arr ,
45: CustomerState IN MscChar60Arr ,
46: CustomerCity IN MscChar60Arr ,
47: CustomerPostalCode IN MscChar60Arr ,
48: SubstitutionTypeCode IN MscNumberArr ,
49: ReqItemDetailFlag IN MscNumberArr ,
50: SalesRep IN MscChar255Arr ,
51: CustomerContact IN MscChar255Arr ,
52: TopModelLineId IN MscNumberArr ,
45: CustomerState IN MscChar60Arr ,
46: CustomerCity IN MscChar60Arr ,
47: CustomerPostalCode IN MscChar60Arr ,
48: SubstitutionTypeCode IN MscNumberArr ,
49: ReqItemDetailFlag IN MscNumberArr ,
50: SalesRep IN MscChar255Arr ,
51: CustomerContact IN MscChar255Arr ,
52: TopModelLineId IN MscNumberArr ,
53: ATOParentModelLineId IN MscNumberArr ,
48: SubstitutionTypeCode IN MscNumberArr ,
49: ReqItemDetailFlag IN MscNumberArr ,
50: SalesRep IN MscChar255Arr ,
51: CustomerContact IN MscChar255Arr ,
52: TopModelLineId IN MscNumberArr ,
53: ATOParentModelLineId IN MscNumberArr ,
54: ATOModelLineId IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
49: ReqItemDetailFlag IN MscNumberArr ,
50: SalesRep IN MscChar255Arr ,
51: CustomerContact IN MscChar255Arr ,
52: TopModelLineId IN MscNumberArr ,
53: ATOParentModelLineId IN MscNumberArr ,
54: ATOModelLineId IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
57: ConfigItemLineId IN MscNumberArr ,
50: SalesRep IN MscChar255Arr ,
51: CustomerContact IN MscChar255Arr ,
52: TopModelLineId IN MscNumberArr ,
53: ATOParentModelLineId IN MscNumberArr ,
54: ATOModelLineId IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
57: ConfigItemLineId IN MscNumberArr ,
58: ValidationOrg IN MscNumberArr ,
51: CustomerContact IN MscChar255Arr ,
52: TopModelLineId IN MscNumberArr ,
53: ATOParentModelLineId IN MscNumberArr ,
54: ATOModelLineId IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
57: ConfigItemLineId IN MscNumberArr ,
58: ValidationOrg IN MscNumberArr ,
59: ComponentSequenceID IN MscNumberArr ,
52: TopModelLineId IN MscNumberArr ,
53: ATOParentModelLineId IN MscNumberArr ,
54: ATOModelLineId IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
57: ConfigItemLineId IN MscNumberArr ,
58: ValidationOrg IN MscNumberArr ,
59: ComponentSequenceID IN MscNumberArr ,
60: ComponentCode IN MscChar255Arr ,
53: ATOParentModelLineId IN MscNumberArr ,
54: ATOModelLineId IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
57: ConfigItemLineId IN MscNumberArr ,
58: ValidationOrg IN MscNumberArr ,
59: ComponentSequenceID IN MscNumberArr ,
60: ComponentCode IN MscChar255Arr ,
61: LineNumber IN MscChar80Arr ,
54: ATOModelLineId IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
57: ConfigItemLineId IN MscNumberArr ,
58: ValidationOrg IN MscNumberArr ,
59: ComponentSequenceID IN MscNumberArr ,
60: ComponentCode IN MscChar255Arr ,
61: LineNumber IN MscChar80Arr ,
62: IncludedItemFlag IN MscNumberArr ,
55: ParentLineId IN MscNumberArr ,
56: MatchItemId IN MscNumberArr ,
57: ConfigItemLineId IN MscNumberArr ,
58: ValidationOrg IN MscNumberArr ,
59: ComponentSequenceID IN MscNumberArr ,
60: ComponentCode IN MscChar255Arr ,
61: LineNumber IN MscChar80Arr ,
62: IncludedItemFlag IN MscNumberArr ,
63: PickComponentsFlag IN MscChar1Arr ,
58: ValidationOrg IN MscNumberArr ,
59: ComponentSequenceID IN MscNumberArr ,
60: ComponentCode IN MscChar255Arr ,
61: LineNumber IN MscChar80Arr ,
62: IncludedItemFlag IN MscNumberArr ,
63: PickComponentsFlag IN MscChar1Arr ,
64: CascadeModelInfoToComp IN MscNumberArr ,
65: SequenceNumber IN MscNumberArr ,
66: InternalOrgId IN MscNumberArr ,
60: ComponentCode IN MscChar255Arr ,
61: LineNumber IN MscChar80Arr ,
62: IncludedItemFlag IN MscNumberArr ,
63: PickComponentsFlag IN MscChar1Arr ,
64: CascadeModelInfoToComp IN MscNumberArr ,
65: SequenceNumber IN MscNumberArr ,
66: InternalOrgId IN MscNumberArr ,
67: PartySiteId IN MscNumberArr ,
68: PartOfSet IN MscChar1Arr ,
61: LineNumber IN MscChar80Arr ,
62: IncludedItemFlag IN MscNumberArr ,
63: PickComponentsFlag IN MscChar1Arr ,
64: CascadeModelInfoToComp IN MscNumberArr ,
65: SequenceNumber IN MscNumberArr ,
66: InternalOrgId IN MscNumberArr ,
67: PartySiteId IN MscNumberArr ,
68: PartOfSet IN MscChar1Arr ,
69:
62: IncludedItemFlag IN MscNumberArr ,
63: PickComponentsFlag IN MscChar1Arr ,
64: CascadeModelInfoToComp IN MscNumberArr ,
65: SequenceNumber IN MscNumberArr ,
66: InternalOrgId IN MscNumberArr ,
67: PartySiteId IN MscNumberArr ,
68: PartOfSet IN MscChar1Arr ,
69:
70: InstanceIdOut OUT nocopy MscNumberArr,
63: PickComponentsFlag IN MscChar1Arr ,
64: CascadeModelInfoToComp IN MscNumberArr ,
65: SequenceNumber IN MscNumberArr ,
66: InternalOrgId IN MscNumberArr ,
67: PartySiteId IN MscNumberArr ,
68: PartOfSet IN MscChar1Arr ,
69:
70: InstanceIdOut OUT nocopy MscNumberArr,
71: InventoryItemIdOut OUT nocopy MscNumberArr,
66: InternalOrgId IN MscNumberArr ,
67: PartySiteId IN MscNumberArr ,
68: PartOfSet IN MscChar1Arr ,
69:
70: InstanceIdOut OUT nocopy MscNumberArr,
71: InventoryItemIdOut OUT nocopy MscNumberArr,
72: InventoryItemNameOut OUT nocopy MscChar40Arr,
73: SourceOrganizationIdOut OUT nocopy MscNumberArr,
74: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
67: PartySiteId IN MscNumberArr ,
68: PartOfSet IN MscChar1Arr ,
69:
70: InstanceIdOut OUT nocopy MscNumberArr,
71: InventoryItemIdOut OUT nocopy MscNumberArr,
72: InventoryItemNameOut OUT nocopy MscChar40Arr,
73: SourceOrganizationIdOut OUT nocopy MscNumberArr,
74: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
75: OrganizationIdOut OUT nocopy MscNumberArr,
69:
70: InstanceIdOut OUT nocopy MscNumberArr,
71: InventoryItemIdOut OUT nocopy MscNumberArr,
72: InventoryItemNameOut OUT nocopy MscChar40Arr,
73: SourceOrganizationIdOut OUT nocopy MscNumberArr,
74: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
75: OrganizationIdOut OUT nocopy MscNumberArr,
76: IdentifierOut OUT nocopy MscNumberArr,
77: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
71: InventoryItemIdOut OUT nocopy MscNumberArr,
72: InventoryItemNameOut OUT nocopy MscChar40Arr,
73: SourceOrganizationIdOut OUT nocopy MscNumberArr,
74: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
75: OrganizationIdOut OUT nocopy MscNumberArr,
76: IdentifierOut OUT nocopy MscNumberArr,
77: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
78: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
79: DemandSourceTypeOut OUT nocopy MscNumberArr,
72: InventoryItemNameOut OUT nocopy MscChar40Arr,
73: SourceOrganizationIdOut OUT nocopy MscNumberArr,
74: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
75: OrganizationIdOut OUT nocopy MscNumberArr,
76: IdentifierOut OUT nocopy MscNumberArr,
77: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
78: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
79: DemandSourceTypeOut OUT nocopy MscNumberArr,
80: CustomerIdOut OUT nocopy MscNumberArr,
73: SourceOrganizationIdOut OUT nocopy MscNumberArr,
74: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
75: OrganizationIdOut OUT nocopy MscNumberArr,
76: IdentifierOut OUT nocopy MscNumberArr,
77: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
78: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
79: DemandSourceTypeOut OUT nocopy MscNumberArr,
80: CustomerIdOut OUT nocopy MscNumberArr,
81: CustomerSiteIdOut OUT nocopy MscNumberArr,
75: OrganizationIdOut OUT nocopy MscNumberArr,
76: IdentifierOut OUT nocopy MscNumberArr,
77: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
78: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
79: DemandSourceTypeOut OUT nocopy MscNumberArr,
80: CustomerIdOut OUT nocopy MscNumberArr,
81: CustomerSiteIdOut OUT nocopy MscNumberArr,
82: QuanitytOrderedOut OUT nocopy MscNumberArr,
83: QuantityUOMOut OUT nocopy MscChar3Arr,
76: IdentifierOut OUT nocopy MscNumberArr,
77: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
78: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
79: DemandSourceTypeOut OUT nocopy MscNumberArr,
80: CustomerIdOut OUT nocopy MscNumberArr,
81: CustomerSiteIdOut OUT nocopy MscNumberArr,
82: QuanitytOrderedOut OUT nocopy MscNumberArr,
83: QuantityUOMOut OUT nocopy MscChar3Arr,
84: RequestedShipDateOut OUT nocopy MscDateArr,
77: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
78: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
79: DemandSourceTypeOut OUT nocopy MscNumberArr,
80: CustomerIdOut OUT nocopy MscNumberArr,
81: CustomerSiteIdOut OUT nocopy MscNumberArr,
82: QuanitytOrderedOut OUT nocopy MscNumberArr,
83: QuantityUOMOut OUT nocopy MscChar3Arr,
84: RequestedShipDateOut OUT nocopy MscDateArr,
85: RequestedArrivalDateOut OUT nocopy MscDateArr,
78: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
79: DemandSourceTypeOut OUT nocopy MscNumberArr,
80: CustomerIdOut OUT nocopy MscNumberArr,
81: CustomerSiteIdOut OUT nocopy MscNumberArr,
82: QuanitytOrderedOut OUT nocopy MscNumberArr,
83: QuantityUOMOut OUT nocopy MscChar3Arr,
84: RequestedShipDateOut OUT nocopy MscDateArr,
85: RequestedArrivalDateOut OUT nocopy MscDateArr,
86: LatestAcceptableDateOut OUT nocopy MscDateArr,
83: QuantityUOMOut OUT nocopy MscChar3Arr,
84: RequestedShipDateOut OUT nocopy MscDateArr,
85: RequestedArrivalDateOut OUT nocopy MscDateArr,
86: LatestAcceptableDateOut OUT nocopy MscDateArr,
87: DeliveryLeadTimeOut OUT nocopy MscNumberArr,
88: ShipMethodOut OUT nocopy MscChar30Arr,
89: DemandClassOut OUT nocopy MscChar30Arr,
90: ShipSetNameOut OUT nocopy MscChar30Arr,
91: ArrivalSetNameOut OUT nocopy MscChar30Arr,
91: ArrivalSetNameOut OUT nocopy MscChar30Arr,
92: OverrideFlagOut OUT nocopy MscChar1Arr,
93: ShipDateOut OUT nocopy MscDateArr,
94: ArrivalDateOut OUT nocopy MscDateArr,
95: AvailableQuantityOut OUT nocopy MscNumberArr,
96: RequestedDateQuantityOut OUT nocopy MscNumberArr,
97: GroupShipDateOut OUT nocopy MscDateArr,
98: GroupArrivalDateOut OUT nocopy MscDateArr,
99: AtpLeadTimeOut OUT nocopy MscNumberArr,
92: OverrideFlagOut OUT nocopy MscChar1Arr,
93: ShipDateOut OUT nocopy MscDateArr,
94: ArrivalDateOut OUT nocopy MscDateArr,
95: AvailableQuantityOut OUT nocopy MscNumberArr,
96: RequestedDateQuantityOut OUT nocopy MscNumberArr,
97: GroupShipDateOut OUT nocopy MscDateArr,
98: GroupArrivalDateOut OUT nocopy MscDateArr,
99: AtpLeadTimeOut OUT nocopy MscNumberArr,
100: ErrorCodeOut OUT nocopy MscNumberArr,
95: AvailableQuantityOut OUT nocopy MscNumberArr,
96: RequestedDateQuantityOut OUT nocopy MscNumberArr,
97: GroupShipDateOut OUT nocopy MscDateArr,
98: GroupArrivalDateOut OUT nocopy MscDateArr,
99: AtpLeadTimeOut OUT nocopy MscNumberArr,
100: ErrorCodeOut OUT nocopy MscNumberArr,
101: EndPeggingIdOut OUT nocopy MscNumberArr,
102: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
103: OldDemandClassOut OUT nocopy MscChar30Arr,
96: RequestedDateQuantityOut OUT nocopy MscNumberArr,
97: GroupShipDateOut OUT nocopy MscDateArr,
98: GroupArrivalDateOut OUT nocopy MscDateArr,
99: AtpLeadTimeOut OUT nocopy MscNumberArr,
100: ErrorCodeOut OUT nocopy MscNumberArr,
101: EndPeggingIdOut OUT nocopy MscNumberArr,
102: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
103: OldDemandClassOut OUT nocopy MscChar30Arr,
104: RequestItemIdOut OUT nocopy MscNumberArr,
97: GroupShipDateOut OUT nocopy MscDateArr,
98: GroupArrivalDateOut OUT nocopy MscDateArr,
99: AtpLeadTimeOut OUT nocopy MscNumberArr,
100: ErrorCodeOut OUT nocopy MscNumberArr,
101: EndPeggingIdOut OUT nocopy MscNumberArr,
102: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
103: OldDemandClassOut OUT nocopy MscChar30Arr,
104: RequestItemIdOut OUT nocopy MscNumberArr,
105: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
98: GroupArrivalDateOut OUT nocopy MscDateArr,
99: AtpLeadTimeOut OUT nocopy MscNumberArr,
100: ErrorCodeOut OUT nocopy MscNumberArr,
101: EndPeggingIdOut OUT nocopy MscNumberArr,
102: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
103: OldDemandClassOut OUT nocopy MscChar30Arr,
104: RequestItemIdOut OUT nocopy MscNumberArr,
105: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
106: ReqItemAvailableDateOut OUT nocopy MscDateArr,
100: ErrorCodeOut OUT nocopy MscNumberArr,
101: EndPeggingIdOut OUT nocopy MscNumberArr,
102: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
103: OldDemandClassOut OUT nocopy MscChar30Arr,
104: RequestItemIdOut OUT nocopy MscNumberArr,
105: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
106: ReqItemAvailableDateOut OUT nocopy MscDateArr,
107: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
108: RequestItemNameOut OUT nocopy MscChar40Arr,
101: EndPeggingIdOut OUT nocopy MscNumberArr,
102: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
103: OldDemandClassOut OUT nocopy MscChar30Arr,
104: RequestItemIdOut OUT nocopy MscNumberArr,
105: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
106: ReqItemAvailableDateOut OUT nocopy MscDateArr,
107: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
108: RequestItemNameOut OUT nocopy MscChar40Arr,
109: OldInventoryItemIdOut OUT nocopy MscNumberArr,
103: OldDemandClassOut OUT nocopy MscChar30Arr,
104: RequestItemIdOut OUT nocopy MscNumberArr,
105: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
106: ReqItemAvailableDateOut OUT nocopy MscDateArr,
107: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
108: RequestItemNameOut OUT nocopy MscChar40Arr,
109: OldInventoryItemIdOut OUT nocopy MscNumberArr,
110: SubstFlagOut OUT nocopy MscNumberArr,
111: BaseModelIdOut OUT nocopy MscNumberArr,
105: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
106: ReqItemAvailableDateOut OUT nocopy MscDateArr,
107: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
108: RequestItemNameOut OUT nocopy MscChar40Arr,
109: OldInventoryItemIdOut OUT nocopy MscNumberArr,
110: SubstFlagOut OUT nocopy MscNumberArr,
111: BaseModelIdOut OUT nocopy MscNumberArr,
112: OssErrorCodeOut OUT nocopy MscNumberArr,
113: MatchedItemNameOut OUT nocopy MscChar255Arr,
106: ReqItemAvailableDateOut OUT nocopy MscDateArr,
107: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
108: RequestItemNameOut OUT nocopy MscChar40Arr,
109: OldInventoryItemIdOut OUT nocopy MscNumberArr,
110: SubstFlagOut OUT nocopy MscNumberArr,
111: BaseModelIdOut OUT nocopy MscNumberArr,
112: OssErrorCodeOut OUT nocopy MscNumberArr,
113: MatchedItemNameOut OUT nocopy MscChar255Arr,
114: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
107: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
108: RequestItemNameOut OUT nocopy MscChar40Arr,
109: OldInventoryItemIdOut OUT nocopy MscNumberArr,
110: SubstFlagOut OUT nocopy MscNumberArr,
111: BaseModelIdOut OUT nocopy MscNumberArr,
112: OssErrorCodeOut OUT nocopy MscNumberArr,
113: MatchedItemNameOut OUT nocopy MscChar255Arr,
114: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
115: PlanIdOut OUT nocopy MscNumberArr
108: RequestItemNameOut OUT nocopy MscChar40Arr,
109: OldInventoryItemIdOut OUT nocopy MscNumberArr,
110: SubstFlagOut OUT nocopy MscNumberArr,
111: BaseModelIdOut OUT nocopy MscNumberArr,
112: OssErrorCodeOut OUT nocopy MscNumberArr,
113: MatchedItemNameOut OUT nocopy MscChar255Arr,
114: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
115: PlanIdOut OUT nocopy MscNumberArr
116: ) is
110: SubstFlagOut OUT nocopy MscNumberArr,
111: BaseModelIdOut OUT nocopy MscNumberArr,
112: OssErrorCodeOut OUT nocopy MscNumberArr,
113: MatchedItemNameOut OUT nocopy MscChar255Arr,
114: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
115: PlanIdOut OUT nocopy MscNumberArr
116: ) is
117:
118: sessionId NUMBER :=0;
111: BaseModelIdOut OUT nocopy MscNumberArr,
112: OssErrorCodeOut OUT nocopy MscNumberArr,
113: MatchedItemNameOut OUT nocopy MscChar255Arr,
114: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
115: PlanIdOut OUT nocopy MscNumberArr
116: ) is
117:
118: sessionId NUMBER :=0;
119: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
142:
143: BEGIN
144:
145: error_tracking_number := 100;
146: InstanceIdOut := MscNumberArr();
147: InventoryItemIdOut := MscNumberArr();
148: InventoryItemNameOut := MscChar40Arr();
149: SourceOrganizationIdOut := MscNumberArr();
150: SourceOrganizationCodeOut := MscChar7Arr();
143: BEGIN
144:
145: error_tracking_number := 100;
146: InstanceIdOut := MscNumberArr();
147: InventoryItemIdOut := MscNumberArr();
148: InventoryItemNameOut := MscChar40Arr();
149: SourceOrganizationIdOut := MscNumberArr();
150: SourceOrganizationCodeOut := MscChar7Arr();
151: OrganizationIdOut := MscNumberArr();
145: error_tracking_number := 100;
146: InstanceIdOut := MscNumberArr();
147: InventoryItemIdOut := MscNumberArr();
148: InventoryItemNameOut := MscChar40Arr();
149: SourceOrganizationIdOut := MscNumberArr();
150: SourceOrganizationCodeOut := MscChar7Arr();
151: OrganizationIdOut := MscNumberArr();
152: IdentifierOut := MscNumberArr();
153: DemandSourceHeaderIdOut := MscNumberArr();
147: InventoryItemIdOut := MscNumberArr();
148: InventoryItemNameOut := MscChar40Arr();
149: SourceOrganizationIdOut := MscNumberArr();
150: SourceOrganizationCodeOut := MscChar7Arr();
151: OrganizationIdOut := MscNumberArr();
152: IdentifierOut := MscNumberArr();
153: DemandSourceHeaderIdOut := MscNumberArr();
154: DemandSourceDeliveryOut := MscChar30Arr();
155: DemandSourceTypeOut := MscNumberArr();
148: InventoryItemNameOut := MscChar40Arr();
149: SourceOrganizationIdOut := MscNumberArr();
150: SourceOrganizationCodeOut := MscChar7Arr();
151: OrganizationIdOut := MscNumberArr();
152: IdentifierOut := MscNumberArr();
153: DemandSourceHeaderIdOut := MscNumberArr();
154: DemandSourceDeliveryOut := MscChar30Arr();
155: DemandSourceTypeOut := MscNumberArr();
156: CustomerIdOut := MscNumberArr();
149: SourceOrganizationIdOut := MscNumberArr();
150: SourceOrganizationCodeOut := MscChar7Arr();
151: OrganizationIdOut := MscNumberArr();
152: IdentifierOut := MscNumberArr();
153: DemandSourceHeaderIdOut := MscNumberArr();
154: DemandSourceDeliveryOut := MscChar30Arr();
155: DemandSourceTypeOut := MscNumberArr();
156: CustomerIdOut := MscNumberArr();
157: CustomerSiteIdOut := MscNumberArr();
151: OrganizationIdOut := MscNumberArr();
152: IdentifierOut := MscNumberArr();
153: DemandSourceHeaderIdOut := MscNumberArr();
154: DemandSourceDeliveryOut := MscChar30Arr();
155: DemandSourceTypeOut := MscNumberArr();
156: CustomerIdOut := MscNumberArr();
157: CustomerSiteIdOut := MscNumberArr();
158: QuanitytOrderedOut := MscNumberArr();
159: QuantityUOMOut := MscChar3Arr();
152: IdentifierOut := MscNumberArr();
153: DemandSourceHeaderIdOut := MscNumberArr();
154: DemandSourceDeliveryOut := MscChar30Arr();
155: DemandSourceTypeOut := MscNumberArr();
156: CustomerIdOut := MscNumberArr();
157: CustomerSiteIdOut := MscNumberArr();
158: QuanitytOrderedOut := MscNumberArr();
159: QuantityUOMOut := MscChar3Arr();
160: RequestedShipDateOut := MscDateArr();
153: DemandSourceHeaderIdOut := MscNumberArr();
154: DemandSourceDeliveryOut := MscChar30Arr();
155: DemandSourceTypeOut := MscNumberArr();
156: CustomerIdOut := MscNumberArr();
157: CustomerSiteIdOut := MscNumberArr();
158: QuanitytOrderedOut := MscNumberArr();
159: QuantityUOMOut := MscChar3Arr();
160: RequestedShipDateOut := MscDateArr();
161: RequestedArrivalDateOut := MscDateArr();
154: DemandSourceDeliveryOut := MscChar30Arr();
155: DemandSourceTypeOut := MscNumberArr();
156: CustomerIdOut := MscNumberArr();
157: CustomerSiteIdOut := MscNumberArr();
158: QuanitytOrderedOut := MscNumberArr();
159: QuantityUOMOut := MscChar3Arr();
160: RequestedShipDateOut := MscDateArr();
161: RequestedArrivalDateOut := MscDateArr();
162: LatestAcceptableDateOut := MscDateArr();
159: QuantityUOMOut := MscChar3Arr();
160: RequestedShipDateOut := MscDateArr();
161: RequestedArrivalDateOut := MscDateArr();
162: LatestAcceptableDateOut := MscDateArr();
163: DeliveryLeadTimeOut := MscNumberArr();
164: ShipMethodOut := MscChar30Arr();
165: DemandClassOut := MscChar30Arr();
166: ShipSetNameOut := MscChar30Arr();
167: ArrivalSetNameOut := MscChar30Arr();
167: ArrivalSetNameOut := MscChar30Arr();
168: OverrideFlagOut := MscChar1Arr();
169: ShipDateOut := MscDateArr();
170: ArrivalDateOut := MscDateArr();
171: AvailableQuantityOut := MscNumberArr();
172: RequestedDateQuantityOut := MscNumberArr();
173: GroupShipDateOut := MscDateArr();
174: GroupArrivalDateOut := MscDateArr();
175: AtpLeadTimeOut := MscNumberArr();
168: OverrideFlagOut := MscChar1Arr();
169: ShipDateOut := MscDateArr();
170: ArrivalDateOut := MscDateArr();
171: AvailableQuantityOut := MscNumberArr();
172: RequestedDateQuantityOut := MscNumberArr();
173: GroupShipDateOut := MscDateArr();
174: GroupArrivalDateOut := MscDateArr();
175: AtpLeadTimeOut := MscNumberArr();
176: ErrorCodeOut := MscNumberArr();
171: AvailableQuantityOut := MscNumberArr();
172: RequestedDateQuantityOut := MscNumberArr();
173: GroupShipDateOut := MscDateArr();
174: GroupArrivalDateOut := MscDateArr();
175: AtpLeadTimeOut := MscNumberArr();
176: ErrorCodeOut := MscNumberArr();
177: EndPeggingIdOut := MscNumberArr();
178: OldSourceOrganizationIdOut := MscNumberArr();
179: OldDemandClassOut := MscChar30Arr();
172: RequestedDateQuantityOut := MscNumberArr();
173: GroupShipDateOut := MscDateArr();
174: GroupArrivalDateOut := MscDateArr();
175: AtpLeadTimeOut := MscNumberArr();
176: ErrorCodeOut := MscNumberArr();
177: EndPeggingIdOut := MscNumberArr();
178: OldSourceOrganizationIdOut := MscNumberArr();
179: OldDemandClassOut := MscChar30Arr();
180: RequestItemIdOut := MscNumberArr();
173: GroupShipDateOut := MscDateArr();
174: GroupArrivalDateOut := MscDateArr();
175: AtpLeadTimeOut := MscNumberArr();
176: ErrorCodeOut := MscNumberArr();
177: EndPeggingIdOut := MscNumberArr();
178: OldSourceOrganizationIdOut := MscNumberArr();
179: OldDemandClassOut := MscChar30Arr();
180: RequestItemIdOut := MscNumberArr();
181: ReqItemReqDateQtyOut := MscNumberArr();
174: GroupArrivalDateOut := MscDateArr();
175: AtpLeadTimeOut := MscNumberArr();
176: ErrorCodeOut := MscNumberArr();
177: EndPeggingIdOut := MscNumberArr();
178: OldSourceOrganizationIdOut := MscNumberArr();
179: OldDemandClassOut := MscChar30Arr();
180: RequestItemIdOut := MscNumberArr();
181: ReqItemReqDateQtyOut := MscNumberArr();
182: ReqItemAvailableDateOut := MscDateArr();
176: ErrorCodeOut := MscNumberArr();
177: EndPeggingIdOut := MscNumberArr();
178: OldSourceOrganizationIdOut := MscNumberArr();
179: OldDemandClassOut := MscChar30Arr();
180: RequestItemIdOut := MscNumberArr();
181: ReqItemReqDateQtyOut := MscNumberArr();
182: ReqItemAvailableDateOut := MscDateArr();
183: ReqItemAvailableDateQtyOut := MscNumberArr();
184: RequestItemNameOut := MscChar40Arr();
177: EndPeggingIdOut := MscNumberArr();
178: OldSourceOrganizationIdOut := MscNumberArr();
179: OldDemandClassOut := MscChar30Arr();
180: RequestItemIdOut := MscNumberArr();
181: ReqItemReqDateQtyOut := MscNumberArr();
182: ReqItemAvailableDateOut := MscDateArr();
183: ReqItemAvailableDateQtyOut := MscNumberArr();
184: RequestItemNameOut := MscChar40Arr();
185: OldInventoryItemIdOut := MscNumberArr();
179: OldDemandClassOut := MscChar30Arr();
180: RequestItemIdOut := MscNumberArr();
181: ReqItemReqDateQtyOut := MscNumberArr();
182: ReqItemAvailableDateOut := MscDateArr();
183: ReqItemAvailableDateQtyOut := MscNumberArr();
184: RequestItemNameOut := MscChar40Arr();
185: OldInventoryItemIdOut := MscNumberArr();
186: SubstFlagOut := MscNumberArr();
187: BaseModelIdOut := MscNumberArr();
181: ReqItemReqDateQtyOut := MscNumberArr();
182: ReqItemAvailableDateOut := MscDateArr();
183: ReqItemAvailableDateQtyOut := MscNumberArr();
184: RequestItemNameOut := MscChar40Arr();
185: OldInventoryItemIdOut := MscNumberArr();
186: SubstFlagOut := MscNumberArr();
187: BaseModelIdOut := MscNumberArr();
188: OssErrorCodeOut := MscNumberArr();
189: MatchedItemNameOut := MscChar255Arr();
182: ReqItemAvailableDateOut := MscDateArr();
183: ReqItemAvailableDateQtyOut := MscNumberArr();
184: RequestItemNameOut := MscChar40Arr();
185: OldInventoryItemIdOut := MscNumberArr();
186: SubstFlagOut := MscNumberArr();
187: BaseModelIdOut := MscNumberArr();
188: OssErrorCodeOut := MscNumberArr();
189: MatchedItemNameOut := MscChar255Arr();
190: CascadeModelInfoToCompOut := MscNumberArr();
183: ReqItemAvailableDateQtyOut := MscNumberArr();
184: RequestItemNameOut := MscChar40Arr();
185: OldInventoryItemIdOut := MscNumberArr();
186: SubstFlagOut := MscNumberArr();
187: BaseModelIdOut := MscNumberArr();
188: OssErrorCodeOut := MscNumberArr();
189: MatchedItemNameOut := MscChar255Arr();
190: CascadeModelInfoToCompOut := MscNumberArr();
191: PlanIdOut := MscNumberArr();
184: RequestItemNameOut := MscChar40Arr();
185: OldInventoryItemIdOut := MscNumberArr();
186: SubstFlagOut := MscNumberArr();
187: BaseModelIdOut := MscNumberArr();
188: OssErrorCodeOut := MscNumberArr();
189: MatchedItemNameOut := MscChar255Arr();
190: CascadeModelInfoToCompOut := MscNumberArr();
191: PlanIdOut := MscNumberArr();
192:
186: SubstFlagOut := MscNumberArr();
187: BaseModelIdOut := MscNumberArr();
188: OssErrorCodeOut := MscNumberArr();
189: MatchedItemNameOut := MscChar255Arr();
190: CascadeModelInfoToCompOut := MscNumberArr();
191: PlanIdOut := MscNumberArr();
192:
193:
194: --dbms_output.put_line('ln= ' || ln );
187: BaseModelIdOut := MscNumberArr();
188: OssErrorCodeOut := MscNumberArr();
189: MatchedItemNameOut := MscChar255Arr();
190: CascadeModelInfoToCompOut := MscNumberArr();
191: PlanIdOut := MscNumberArr();
192:
193:
194: --dbms_output.put_line('ln= ' || ln );
195:
945: RespName IN VARCHAR2,
946: RespApplName IN VARCHAR2,
947: SecurityGroupName IN VARCHAR2,
948: Language IN VARCHAR2,
949: InstanceId IN MscNumberArr ,
950: InventoryItemId IN MscNumberArr,
951: InventoryItemName IN MscChar40Arr,
952: SourceOrganizationId IN MscNumberArr ,
953: SourceOrganizationCode IN MscChar7Arr ,
946: RespApplName IN VARCHAR2,
947: SecurityGroupName IN VARCHAR2,
948: Language IN VARCHAR2,
949: InstanceId IN MscNumberArr ,
950: InventoryItemId IN MscNumberArr,
951: InventoryItemName IN MscChar40Arr,
952: SourceOrganizationId IN MscNumberArr ,
953: SourceOrganizationCode IN MscChar7Arr ,
954: OrganizationId IN MscNumberArr ,
948: Language IN VARCHAR2,
949: InstanceId IN MscNumberArr ,
950: InventoryItemId IN MscNumberArr,
951: InventoryItemName IN MscChar40Arr,
952: SourceOrganizationId IN MscNumberArr ,
953: SourceOrganizationCode IN MscChar7Arr ,
954: OrganizationId IN MscNumberArr ,
955: Identifier IN MscNumberArr ,
956: DemandSourceHeaderId IN MscNumberArr ,
950: InventoryItemId IN MscNumberArr,
951: InventoryItemName IN MscChar40Arr,
952: SourceOrganizationId IN MscNumberArr ,
953: SourceOrganizationCode IN MscChar7Arr ,
954: OrganizationId IN MscNumberArr ,
955: Identifier IN MscNumberArr ,
956: DemandSourceHeaderId IN MscNumberArr ,
957: DemandSourceDelivery IN MscChar30Arr ,
958: DemandSourceType IN MscNumberArr ,
951: InventoryItemName IN MscChar40Arr,
952: SourceOrganizationId IN MscNumberArr ,
953: SourceOrganizationCode IN MscChar7Arr ,
954: OrganizationId IN MscNumberArr ,
955: Identifier IN MscNumberArr ,
956: DemandSourceHeaderId IN MscNumberArr ,
957: DemandSourceDelivery IN MscChar30Arr ,
958: DemandSourceType IN MscNumberArr ,
959: CallingModule IN MscNumberArr ,
952: SourceOrganizationId IN MscNumberArr ,
953: SourceOrganizationCode IN MscChar7Arr ,
954: OrganizationId IN MscNumberArr ,
955: Identifier IN MscNumberArr ,
956: DemandSourceHeaderId IN MscNumberArr ,
957: DemandSourceDelivery IN MscChar30Arr ,
958: DemandSourceType IN MscNumberArr ,
959: CallingModule IN MscNumberArr ,
960: CustomerId IN MscNumberArr ,
954: OrganizationId IN MscNumberArr ,
955: Identifier IN MscNumberArr ,
956: DemandSourceHeaderId IN MscNumberArr ,
957: DemandSourceDelivery IN MscChar30Arr ,
958: DemandSourceType IN MscNumberArr ,
959: CallingModule IN MscNumberArr ,
960: CustomerId IN MscNumberArr ,
961: CustomerSiteId IN MscNumberArr ,
962: QuantityOrdered IN MscNumberArr ,
955: Identifier IN MscNumberArr ,
956: DemandSourceHeaderId IN MscNumberArr ,
957: DemandSourceDelivery IN MscChar30Arr ,
958: DemandSourceType IN MscNumberArr ,
959: CallingModule IN MscNumberArr ,
960: CustomerId IN MscNumberArr ,
961: CustomerSiteId IN MscNumberArr ,
962: QuantityOrdered IN MscNumberArr ,
963: QuantityUOM IN MscChar3Arr ,
956: DemandSourceHeaderId IN MscNumberArr ,
957: DemandSourceDelivery IN MscChar30Arr ,
958: DemandSourceType IN MscNumberArr ,
959: CallingModule IN MscNumberArr ,
960: CustomerId IN MscNumberArr ,
961: CustomerSiteId IN MscNumberArr ,
962: QuantityOrdered IN MscNumberArr ,
963: QuantityUOM IN MscChar3Arr ,
964: RequestedShipDate IN MscDateArr,
957: DemandSourceDelivery IN MscChar30Arr ,
958: DemandSourceType IN MscNumberArr ,
959: CallingModule IN MscNumberArr ,
960: CustomerId IN MscNumberArr ,
961: CustomerSiteId IN MscNumberArr ,
962: QuantityOrdered IN MscNumberArr ,
963: QuantityUOM IN MscChar3Arr ,
964: RequestedShipDate IN MscDateArr,
965: RequestedArrivalDate IN MscDateArr ,
958: DemandSourceType IN MscNumberArr ,
959: CallingModule IN MscNumberArr ,
960: CustomerId IN MscNumberArr ,
961: CustomerSiteId IN MscNumberArr ,
962: QuantityOrdered IN MscNumberArr ,
963: QuantityUOM IN MscChar3Arr ,
964: RequestedShipDate IN MscDateArr,
965: RequestedArrivalDate IN MscDateArr ,
966: LatestAcceptableDate IN MscDateArr ,
963: QuantityUOM IN MscChar3Arr ,
964: RequestedShipDate IN MscDateArr,
965: RequestedArrivalDate IN MscDateArr ,
966: LatestAcceptableDate IN MscDateArr ,
967: DeliveryLeadTime IN MscNumberArr ,
968: ShipMethod IN MscChar30Arr ,
969: DemandClass IN MscChar30Arr ,
970: ShipSetName IN MscChar30Arr ,
971: ArrivalSetName IN MscChar30Arr ,
969: DemandClass IN MscChar30Arr ,
970: ShipSetName IN MscChar30Arr ,
971: ArrivalSetName IN MscChar30Arr ,
972: OverrideFlag IN MscChar1Arr ,
973: Action IN MscNumberArr ,
974: InsertFlag IN MscNumberArr ,
975: OEFlag IN MscChar1Arr ,
976: OrderNumber IN MscNumberArr ,
977: OldSourceOrganizationId IN MscNumberArr ,
970: ShipSetName IN MscChar30Arr ,
971: ArrivalSetName IN MscChar30Arr ,
972: OverrideFlag IN MscChar1Arr ,
973: Action IN MscNumberArr ,
974: InsertFlag IN MscNumberArr ,
975: OEFlag IN MscChar1Arr ,
976: OrderNumber IN MscNumberArr ,
977: OldSourceOrganizationId IN MscNumberArr ,
978: OldDemandClass IN MscChar30Arr ,
972: OverrideFlag IN MscChar1Arr ,
973: Action IN MscNumberArr ,
974: InsertFlag IN MscNumberArr ,
975: OEFlag IN MscChar1Arr ,
976: OrderNumber IN MscNumberArr ,
977: OldSourceOrganizationId IN MscNumberArr ,
978: OldDemandClass IN MscChar30Arr ,
979: Attribute01 IN MscNumberArr ,
980: Attribute02 IN MscNumberArr ,
973: Action IN MscNumberArr ,
974: InsertFlag IN MscNumberArr ,
975: OEFlag IN MscChar1Arr ,
976: OrderNumber IN MscNumberArr ,
977: OldSourceOrganizationId IN MscNumberArr ,
978: OldDemandClass IN MscChar30Arr ,
979: Attribute01 IN MscNumberArr ,
980: Attribute02 IN MscNumberArr ,
981: CustomerCountry IN MscChar60Arr ,
975: OEFlag IN MscChar1Arr ,
976: OrderNumber IN MscNumberArr ,
977: OldSourceOrganizationId IN MscNumberArr ,
978: OldDemandClass IN MscChar30Arr ,
979: Attribute01 IN MscNumberArr ,
980: Attribute02 IN MscNumberArr ,
981: CustomerCountry IN MscChar60Arr ,
982: CustomerState IN MscChar60Arr ,
983: CustomerCity IN MscChar60Arr ,
976: OrderNumber IN MscNumberArr ,
977: OldSourceOrganizationId IN MscNumberArr ,
978: OldDemandClass IN MscChar30Arr ,
979: Attribute01 IN MscNumberArr ,
980: Attribute02 IN MscNumberArr ,
981: CustomerCountry IN MscChar60Arr ,
982: CustomerState IN MscChar60Arr ,
983: CustomerCity IN MscChar60Arr ,
984: CustomerPostalCode IN MscChar60Arr ,
981: CustomerCountry IN MscChar60Arr ,
982: CustomerState IN MscChar60Arr ,
983: CustomerCity IN MscChar60Arr ,
984: CustomerPostalCode IN MscChar60Arr ,
985: SubstitutionTypeCode IN MscNumberArr ,
986: ReqItemDetailFlag IN MscNumberArr ,
987: SalesRep IN MscChar255Arr ,
988: CustomerContact IN MscChar255Arr ,
989: TopModelLineId IN MscNumberArr ,
982: CustomerState IN MscChar60Arr ,
983: CustomerCity IN MscChar60Arr ,
984: CustomerPostalCode IN MscChar60Arr ,
985: SubstitutionTypeCode IN MscNumberArr ,
986: ReqItemDetailFlag IN MscNumberArr ,
987: SalesRep IN MscChar255Arr ,
988: CustomerContact IN MscChar255Arr ,
989: TopModelLineId IN MscNumberArr ,
990: ATOParentModelLineId IN MscNumberArr ,
985: SubstitutionTypeCode IN MscNumberArr ,
986: ReqItemDetailFlag IN MscNumberArr ,
987: SalesRep IN MscChar255Arr ,
988: CustomerContact IN MscChar255Arr ,
989: TopModelLineId IN MscNumberArr ,
990: ATOParentModelLineId IN MscNumberArr ,
991: ATOModelLineId IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
986: ReqItemDetailFlag IN MscNumberArr ,
987: SalesRep IN MscChar255Arr ,
988: CustomerContact IN MscChar255Arr ,
989: TopModelLineId IN MscNumberArr ,
990: ATOParentModelLineId IN MscNumberArr ,
991: ATOModelLineId IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
994: ConfigItemLineId IN MscNumberArr ,
987: SalesRep IN MscChar255Arr ,
988: CustomerContact IN MscChar255Arr ,
989: TopModelLineId IN MscNumberArr ,
990: ATOParentModelLineId IN MscNumberArr ,
991: ATOModelLineId IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
994: ConfigItemLineId IN MscNumberArr ,
995: ValidationOrg IN MscNumberArr ,
988: CustomerContact IN MscChar255Arr ,
989: TopModelLineId IN MscNumberArr ,
990: ATOParentModelLineId IN MscNumberArr ,
991: ATOModelLineId IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
994: ConfigItemLineId IN MscNumberArr ,
995: ValidationOrg IN MscNumberArr ,
996: ComponentSequenceID IN MscNumberArr ,
989: TopModelLineId IN MscNumberArr ,
990: ATOParentModelLineId IN MscNumberArr ,
991: ATOModelLineId IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
994: ConfigItemLineId IN MscNumberArr ,
995: ValidationOrg IN MscNumberArr ,
996: ComponentSequenceID IN MscNumberArr ,
997: ComponentCode IN MscChar255Arr ,
990: ATOParentModelLineId IN MscNumberArr ,
991: ATOModelLineId IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
994: ConfigItemLineId IN MscNumberArr ,
995: ValidationOrg IN MscNumberArr ,
996: ComponentSequenceID IN MscNumberArr ,
997: ComponentCode IN MscChar255Arr ,
998: LineNumber IN MscChar80Arr ,
991: ATOModelLineId IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
994: ConfigItemLineId IN MscNumberArr ,
995: ValidationOrg IN MscNumberArr ,
996: ComponentSequenceID IN MscNumberArr ,
997: ComponentCode IN MscChar255Arr ,
998: LineNumber IN MscChar80Arr ,
999: IncludedItemFlag IN MscNumberArr ,
992: ParentLineId IN MscNumberArr ,
993: MatchItemId IN MscNumberArr ,
994: ConfigItemLineId IN MscNumberArr ,
995: ValidationOrg IN MscNumberArr ,
996: ComponentSequenceID IN MscNumberArr ,
997: ComponentCode IN MscChar255Arr ,
998: LineNumber IN MscChar80Arr ,
999: IncludedItemFlag IN MscNumberArr ,
1000: PickComponentsFlag IN MscChar1Arr ,
995: ValidationOrg IN MscNumberArr ,
996: ComponentSequenceID IN MscNumberArr ,
997: ComponentCode IN MscChar255Arr ,
998: LineNumber IN MscChar80Arr ,
999: IncludedItemFlag IN MscNumberArr ,
1000: PickComponentsFlag IN MscChar1Arr ,
1001: CascadeModelInfoToComp IN MscNumberArr ,
1002: SequenceNumber IN MscNumberArr ,
1003: InternalOrgId IN MscNumberArr ,
997: ComponentCode IN MscChar255Arr ,
998: LineNumber IN MscChar80Arr ,
999: IncludedItemFlag IN MscNumberArr ,
1000: PickComponentsFlag IN MscChar1Arr ,
1001: CascadeModelInfoToComp IN MscNumberArr ,
1002: SequenceNumber IN MscNumberArr ,
1003: InternalOrgId IN MscNumberArr ,
1004: PartySiteId IN MscNumberArr ,
1005: PartOfSet IN MscChar1Arr ,
998: LineNumber IN MscChar80Arr ,
999: IncludedItemFlag IN MscNumberArr ,
1000: PickComponentsFlag IN MscChar1Arr ,
1001: CascadeModelInfoToComp IN MscNumberArr ,
1002: SequenceNumber IN MscNumberArr ,
1003: InternalOrgId IN MscNumberArr ,
1004: PartySiteId IN MscNumberArr ,
1005: PartOfSet IN MscChar1Arr ,
1006:
999: IncludedItemFlag IN MscNumberArr ,
1000: PickComponentsFlag IN MscChar1Arr ,
1001: CascadeModelInfoToComp IN MscNumberArr ,
1002: SequenceNumber IN MscNumberArr ,
1003: InternalOrgId IN MscNumberArr ,
1004: PartySiteId IN MscNumberArr ,
1005: PartOfSet IN MscChar1Arr ,
1006:
1007: InstanceIdOut OUT nocopy MscNumberArr,
1000: PickComponentsFlag IN MscChar1Arr ,
1001: CascadeModelInfoToComp IN MscNumberArr ,
1002: SequenceNumber IN MscNumberArr ,
1003: InternalOrgId IN MscNumberArr ,
1004: PartySiteId IN MscNumberArr ,
1005: PartOfSet IN MscChar1Arr ,
1006:
1007: InstanceIdOut OUT nocopy MscNumberArr,
1008: InventoryItemIdOut OUT nocopy MscNumberArr,
1003: InternalOrgId IN MscNumberArr ,
1004: PartySiteId IN MscNumberArr ,
1005: PartOfSet IN MscChar1Arr ,
1006:
1007: InstanceIdOut OUT nocopy MscNumberArr,
1008: InventoryItemIdOut OUT nocopy MscNumberArr,
1009: InventoryItemNameOut OUT nocopy MscChar40Arr,
1010: SourceOrganizationIdOut OUT nocopy MscNumberArr,
1011: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
1004: PartySiteId IN MscNumberArr ,
1005: PartOfSet IN MscChar1Arr ,
1006:
1007: InstanceIdOut OUT nocopy MscNumberArr,
1008: InventoryItemIdOut OUT nocopy MscNumberArr,
1009: InventoryItemNameOut OUT nocopy MscChar40Arr,
1010: SourceOrganizationIdOut OUT nocopy MscNumberArr,
1011: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
1012: OrganizationIdOut OUT nocopy MscNumberArr,
1006:
1007: InstanceIdOut OUT nocopy MscNumberArr,
1008: InventoryItemIdOut OUT nocopy MscNumberArr,
1009: InventoryItemNameOut OUT nocopy MscChar40Arr,
1010: SourceOrganizationIdOut OUT nocopy MscNumberArr,
1011: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
1012: OrganizationIdOut OUT nocopy MscNumberArr,
1013: IdentifierOut OUT nocopy MscNumberArr,
1014: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
1008: InventoryItemIdOut OUT nocopy MscNumberArr,
1009: InventoryItemNameOut OUT nocopy MscChar40Arr,
1010: SourceOrganizationIdOut OUT nocopy MscNumberArr,
1011: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
1012: OrganizationIdOut OUT nocopy MscNumberArr,
1013: IdentifierOut OUT nocopy MscNumberArr,
1014: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
1015: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
1016: DemandSourceTypeOut OUT nocopy MscNumberArr,
1009: InventoryItemNameOut OUT nocopy MscChar40Arr,
1010: SourceOrganizationIdOut OUT nocopy MscNumberArr,
1011: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
1012: OrganizationIdOut OUT nocopy MscNumberArr,
1013: IdentifierOut OUT nocopy MscNumberArr,
1014: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
1015: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
1016: DemandSourceTypeOut OUT nocopy MscNumberArr,
1017: CustomerIdOut OUT nocopy MscNumberArr,
1010: SourceOrganizationIdOut OUT nocopy MscNumberArr,
1011: SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
1012: OrganizationIdOut OUT nocopy MscNumberArr,
1013: IdentifierOut OUT nocopy MscNumberArr,
1014: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
1015: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
1016: DemandSourceTypeOut OUT nocopy MscNumberArr,
1017: CustomerIdOut OUT nocopy MscNumberArr,
1018: CustomerSiteIdOut OUT nocopy MscNumberArr,
1012: OrganizationIdOut OUT nocopy MscNumberArr,
1013: IdentifierOut OUT nocopy MscNumberArr,
1014: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
1015: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
1016: DemandSourceTypeOut OUT nocopy MscNumberArr,
1017: CustomerIdOut OUT nocopy MscNumberArr,
1018: CustomerSiteIdOut OUT nocopy MscNumberArr,
1019: QuanitytOrderedOut OUT nocopy MscNumberArr,
1020: QuantityUOMOut OUT nocopy MscChar3Arr,
1013: IdentifierOut OUT nocopy MscNumberArr,
1014: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
1015: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
1016: DemandSourceTypeOut OUT nocopy MscNumberArr,
1017: CustomerIdOut OUT nocopy MscNumberArr,
1018: CustomerSiteIdOut OUT nocopy MscNumberArr,
1019: QuanitytOrderedOut OUT nocopy MscNumberArr,
1020: QuantityUOMOut OUT nocopy MscChar3Arr,
1021: RequestedShipDateOut OUT nocopy MscDateArr,
1014: DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
1015: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
1016: DemandSourceTypeOut OUT nocopy MscNumberArr,
1017: CustomerIdOut OUT nocopy MscNumberArr,
1018: CustomerSiteIdOut OUT nocopy MscNumberArr,
1019: QuanitytOrderedOut OUT nocopy MscNumberArr,
1020: QuantityUOMOut OUT nocopy MscChar3Arr,
1021: RequestedShipDateOut OUT nocopy MscDateArr,
1022: RequestedArrivalDateOut OUT nocopy MscDateArr,
1015: DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
1016: DemandSourceTypeOut OUT nocopy MscNumberArr,
1017: CustomerIdOut OUT nocopy MscNumberArr,
1018: CustomerSiteIdOut OUT nocopy MscNumberArr,
1019: QuanitytOrderedOut OUT nocopy MscNumberArr,
1020: QuantityUOMOut OUT nocopy MscChar3Arr,
1021: RequestedShipDateOut OUT nocopy MscDateArr,
1022: RequestedArrivalDateOut OUT nocopy MscDateArr,
1023: LatestAcceptableDateOut OUT nocopy MscDateArr,
1020: QuantityUOMOut OUT nocopy MscChar3Arr,
1021: RequestedShipDateOut OUT nocopy MscDateArr,
1022: RequestedArrivalDateOut OUT nocopy MscDateArr,
1023: LatestAcceptableDateOut OUT nocopy MscDateArr,
1024: DeliveryLeadTimeOut OUT nocopy MscNumberArr,
1025: ShipMethodOut OUT nocopy MscChar30Arr,
1026: DemandClassOut OUT nocopy MscChar30Arr,
1027: ShipSetNameOut OUT nocopy MscChar30Arr,
1028: ArrivalSetNameOut OUT nocopy MscChar30Arr,
1028: ArrivalSetNameOut OUT nocopy MscChar30Arr,
1029: OverrideFlagOut OUT nocopy MscChar1Arr,
1030: ShipDateOut OUT nocopy MscDateArr,
1031: ArrivalDateOut OUT nocopy MscDateArr,
1032: AvailableQuantityOut OUT nocopy MscNumberArr,
1033: RequestedDateQuantityOut OUT nocopy MscNumberArr,
1034: GroupShipDateOut OUT nocopy MscDateArr,
1035: GroupArrivalDateOut OUT nocopy MscDateArr,
1036: AtpLeadTimeOut OUT nocopy MscNumberArr,
1029: OverrideFlagOut OUT nocopy MscChar1Arr,
1030: ShipDateOut OUT nocopy MscDateArr,
1031: ArrivalDateOut OUT nocopy MscDateArr,
1032: AvailableQuantityOut OUT nocopy MscNumberArr,
1033: RequestedDateQuantityOut OUT nocopy MscNumberArr,
1034: GroupShipDateOut OUT nocopy MscDateArr,
1035: GroupArrivalDateOut OUT nocopy MscDateArr,
1036: AtpLeadTimeOut OUT nocopy MscNumberArr,
1037: ErrorCodeOut OUT nocopy MscNumberArr,
1032: AvailableQuantityOut OUT nocopy MscNumberArr,
1033: RequestedDateQuantityOut OUT nocopy MscNumberArr,
1034: GroupShipDateOut OUT nocopy MscDateArr,
1035: GroupArrivalDateOut OUT nocopy MscDateArr,
1036: AtpLeadTimeOut OUT nocopy MscNumberArr,
1037: ErrorCodeOut OUT nocopy MscNumberArr,
1038: EndPeggingIdOut OUT nocopy MscNumberArr,
1039: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
1040: OldDemandClassOut OUT nocopy MscChar30Arr,
1033: RequestedDateQuantityOut OUT nocopy MscNumberArr,
1034: GroupShipDateOut OUT nocopy MscDateArr,
1035: GroupArrivalDateOut OUT nocopy MscDateArr,
1036: AtpLeadTimeOut OUT nocopy MscNumberArr,
1037: ErrorCodeOut OUT nocopy MscNumberArr,
1038: EndPeggingIdOut OUT nocopy MscNumberArr,
1039: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
1040: OldDemandClassOut OUT nocopy MscChar30Arr,
1041: RequestItemIdOut OUT nocopy MscNumberArr,
1034: GroupShipDateOut OUT nocopy MscDateArr,
1035: GroupArrivalDateOut OUT nocopy MscDateArr,
1036: AtpLeadTimeOut OUT nocopy MscNumberArr,
1037: ErrorCodeOut OUT nocopy MscNumberArr,
1038: EndPeggingIdOut OUT nocopy MscNumberArr,
1039: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
1040: OldDemandClassOut OUT nocopy MscChar30Arr,
1041: RequestItemIdOut OUT nocopy MscNumberArr,
1042: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
1035: GroupArrivalDateOut OUT nocopy MscDateArr,
1036: AtpLeadTimeOut OUT nocopy MscNumberArr,
1037: ErrorCodeOut OUT nocopy MscNumberArr,
1038: EndPeggingIdOut OUT nocopy MscNumberArr,
1039: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
1040: OldDemandClassOut OUT nocopy MscChar30Arr,
1041: RequestItemIdOut OUT nocopy MscNumberArr,
1042: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
1043: ReqItemAvailableDateOut OUT nocopy MscDateArr,
1037: ErrorCodeOut OUT nocopy MscNumberArr,
1038: EndPeggingIdOut OUT nocopy MscNumberArr,
1039: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
1040: OldDemandClassOut OUT nocopy MscChar30Arr,
1041: RequestItemIdOut OUT nocopy MscNumberArr,
1042: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
1043: ReqItemAvailableDateOut OUT nocopy MscDateArr,
1044: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
1045: RequestItemNameOut OUT nocopy MscChar40Arr,
1038: EndPeggingIdOut OUT nocopy MscNumberArr,
1039: OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
1040: OldDemandClassOut OUT nocopy MscChar30Arr,
1041: RequestItemIdOut OUT nocopy MscNumberArr,
1042: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
1043: ReqItemAvailableDateOut OUT nocopy MscDateArr,
1044: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
1045: RequestItemNameOut OUT nocopy MscChar40Arr,
1046: OldInventoryItemIdOut OUT nocopy MscNumberArr,
1040: OldDemandClassOut OUT nocopy MscChar30Arr,
1041: RequestItemIdOut OUT nocopy MscNumberArr,
1042: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
1043: ReqItemAvailableDateOut OUT nocopy MscDateArr,
1044: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
1045: RequestItemNameOut OUT nocopy MscChar40Arr,
1046: OldInventoryItemIdOut OUT nocopy MscNumberArr,
1047: SubstFlagOut OUT nocopy MscNumberArr,
1048: BaseModelIdOut OUT nocopy MscNumberArr,
1042: ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
1043: ReqItemAvailableDateOut OUT nocopy MscDateArr,
1044: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
1045: RequestItemNameOut OUT nocopy MscChar40Arr,
1046: OldInventoryItemIdOut OUT nocopy MscNumberArr,
1047: SubstFlagOut OUT nocopy MscNumberArr,
1048: BaseModelIdOut OUT nocopy MscNumberArr,
1049: OssErrorCodeOut OUT nocopy MscNumberArr,
1050: MatchedItemNameOut OUT nocopy MscChar255Arr,
1043: ReqItemAvailableDateOut OUT nocopy MscDateArr,
1044: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
1045: RequestItemNameOut OUT nocopy MscChar40Arr,
1046: OldInventoryItemIdOut OUT nocopy MscNumberArr,
1047: SubstFlagOut OUT nocopy MscNumberArr,
1048: BaseModelIdOut OUT nocopy MscNumberArr,
1049: OssErrorCodeOut OUT nocopy MscNumberArr,
1050: MatchedItemNameOut OUT nocopy MscChar255Arr,
1051: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
1044: ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
1045: RequestItemNameOut OUT nocopy MscChar40Arr,
1046: OldInventoryItemIdOut OUT nocopy MscNumberArr,
1047: SubstFlagOut OUT nocopy MscNumberArr,
1048: BaseModelIdOut OUT nocopy MscNumberArr,
1049: OssErrorCodeOut OUT nocopy MscNumberArr,
1050: MatchedItemNameOut OUT nocopy MscChar255Arr,
1051: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
1052: PlanIdOut OUT nocopy MscNumberArr
1045: RequestItemNameOut OUT nocopy MscChar40Arr,
1046: OldInventoryItemIdOut OUT nocopy MscNumberArr,
1047: SubstFlagOut OUT nocopy MscNumberArr,
1048: BaseModelIdOut OUT nocopy MscNumberArr,
1049: OssErrorCodeOut OUT nocopy MscNumberArr,
1050: MatchedItemNameOut OUT nocopy MscChar255Arr,
1051: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
1052: PlanIdOut OUT nocopy MscNumberArr
1053: )AS
1047: SubstFlagOut OUT nocopy MscNumberArr,
1048: BaseModelIdOut OUT nocopy MscNumberArr,
1049: OssErrorCodeOut OUT nocopy MscNumberArr,
1050: MatchedItemNameOut OUT nocopy MscChar255Arr,
1051: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
1052: PlanIdOut OUT nocopy MscNumberArr
1053: )AS
1054: userid number;
1055: respid number;
1048: BaseModelIdOut OUT nocopy MscNumberArr,
1049: OssErrorCodeOut OUT nocopy MscNumberArr,
1050: MatchedItemNameOut OUT nocopy MscChar255Arr,
1051: CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
1052: PlanIdOut OUT nocopy MscNumberArr
1053: )AS
1054: userid number;
1055: respid number;
1056: l_String VARCHAR2(30);
1056: l_String VARCHAR2(30);
1057: error_tracking_num number;
1058: l_SecutirtGroupId NUMBER;
1059: BEGIN
1060: InstanceIdOut := MscNumberArr();
1061: InventoryItemIdOut := MscNumberArr();
1062: InventoryItemNameOut := MscChar40Arr();
1063: SourceOrganizationIdOut := MscNumberArr();
1064: SourceOrganizationCodeOut := MscChar7Arr();
1057: error_tracking_num number;
1058: l_SecutirtGroupId NUMBER;
1059: BEGIN
1060: InstanceIdOut := MscNumberArr();
1061: InventoryItemIdOut := MscNumberArr();
1062: InventoryItemNameOut := MscChar40Arr();
1063: SourceOrganizationIdOut := MscNumberArr();
1064: SourceOrganizationCodeOut := MscChar7Arr();
1065: OrganizationIdOut := MscNumberArr();
1059: BEGIN
1060: InstanceIdOut := MscNumberArr();
1061: InventoryItemIdOut := MscNumberArr();
1062: InventoryItemNameOut := MscChar40Arr();
1063: SourceOrganizationIdOut := MscNumberArr();
1064: SourceOrganizationCodeOut := MscChar7Arr();
1065: OrganizationIdOut := MscNumberArr();
1066: IdentifierOut := MscNumberArr();
1067: DemandSourceHeaderIdOut := MscNumberArr();
1061: InventoryItemIdOut := MscNumberArr();
1062: InventoryItemNameOut := MscChar40Arr();
1063: SourceOrganizationIdOut := MscNumberArr();
1064: SourceOrganizationCodeOut := MscChar7Arr();
1065: OrganizationIdOut := MscNumberArr();
1066: IdentifierOut := MscNumberArr();
1067: DemandSourceHeaderIdOut := MscNumberArr();
1068: DemandSourceDeliveryOut := MscChar30Arr();
1069: DemandSourceTypeOut := MscNumberArr();
1062: InventoryItemNameOut := MscChar40Arr();
1063: SourceOrganizationIdOut := MscNumberArr();
1064: SourceOrganizationCodeOut := MscChar7Arr();
1065: OrganizationIdOut := MscNumberArr();
1066: IdentifierOut := MscNumberArr();
1067: DemandSourceHeaderIdOut := MscNumberArr();
1068: DemandSourceDeliveryOut := MscChar30Arr();
1069: DemandSourceTypeOut := MscNumberArr();
1070: CustomerIdOut := MscNumberArr();
1063: SourceOrganizationIdOut := MscNumberArr();
1064: SourceOrganizationCodeOut := MscChar7Arr();
1065: OrganizationIdOut := MscNumberArr();
1066: IdentifierOut := MscNumberArr();
1067: DemandSourceHeaderIdOut := MscNumberArr();
1068: DemandSourceDeliveryOut := MscChar30Arr();
1069: DemandSourceTypeOut := MscNumberArr();
1070: CustomerIdOut := MscNumberArr();
1071: CustomerSiteIdOut := MscNumberArr();
1065: OrganizationIdOut := MscNumberArr();
1066: IdentifierOut := MscNumberArr();
1067: DemandSourceHeaderIdOut := MscNumberArr();
1068: DemandSourceDeliveryOut := MscChar30Arr();
1069: DemandSourceTypeOut := MscNumberArr();
1070: CustomerIdOut := MscNumberArr();
1071: CustomerSiteIdOut := MscNumberArr();
1072: QuanitytOrderedOut := MscNumberArr();
1073: QuantityUOMOut := MscChar3Arr();
1066: IdentifierOut := MscNumberArr();
1067: DemandSourceHeaderIdOut := MscNumberArr();
1068: DemandSourceDeliveryOut := MscChar30Arr();
1069: DemandSourceTypeOut := MscNumberArr();
1070: CustomerIdOut := MscNumberArr();
1071: CustomerSiteIdOut := MscNumberArr();
1072: QuanitytOrderedOut := MscNumberArr();
1073: QuantityUOMOut := MscChar3Arr();
1074: RequestedShipDateOut := MscDateArr();
1067: DemandSourceHeaderIdOut := MscNumberArr();
1068: DemandSourceDeliveryOut := MscChar30Arr();
1069: DemandSourceTypeOut := MscNumberArr();
1070: CustomerIdOut := MscNumberArr();
1071: CustomerSiteIdOut := MscNumberArr();
1072: QuanitytOrderedOut := MscNumberArr();
1073: QuantityUOMOut := MscChar3Arr();
1074: RequestedShipDateOut := MscDateArr();
1075: RequestedArrivalDateOut := MscDateArr();
1068: DemandSourceDeliveryOut := MscChar30Arr();
1069: DemandSourceTypeOut := MscNumberArr();
1070: CustomerIdOut := MscNumberArr();
1071: CustomerSiteIdOut := MscNumberArr();
1072: QuanitytOrderedOut := MscNumberArr();
1073: QuantityUOMOut := MscChar3Arr();
1074: RequestedShipDateOut := MscDateArr();
1075: RequestedArrivalDateOut := MscDateArr();
1076: LatestAcceptableDateOut := MscDateArr();
1073: QuantityUOMOut := MscChar3Arr();
1074: RequestedShipDateOut := MscDateArr();
1075: RequestedArrivalDateOut := MscDateArr();
1076: LatestAcceptableDateOut := MscDateArr();
1077: DeliveryLeadTimeOut := MscNumberArr();
1078: ShipMethodOut := MscChar30Arr();
1079: DemandClassOut := MscChar30Arr();
1080: ShipSetNameOut := MscChar30Arr();
1081: ArrivalSetNameOut := MscChar30Arr();
1081: ArrivalSetNameOut := MscChar30Arr();
1082: OverrideFlagOut := MscChar1Arr();
1083: ShipDateOut := MscDateArr();
1084: ArrivalDateOut := MscDateArr();
1085: AvailableQuantityOut := MscNumberArr();
1086: RequestedDateQuantityOut := MscNumberArr();
1087: GroupShipDateOut := MscDateArr();
1088: GroupArrivalDateOut := MscDateArr();
1089: AtpLeadTimeOut := MscNumberArr();
1082: OverrideFlagOut := MscChar1Arr();
1083: ShipDateOut := MscDateArr();
1084: ArrivalDateOut := MscDateArr();
1085: AvailableQuantityOut := MscNumberArr();
1086: RequestedDateQuantityOut := MscNumberArr();
1087: GroupShipDateOut := MscDateArr();
1088: GroupArrivalDateOut := MscDateArr();
1089: AtpLeadTimeOut := MscNumberArr();
1090: ErrorCodeOut := MscNumberArr();
1085: AvailableQuantityOut := MscNumberArr();
1086: RequestedDateQuantityOut := MscNumberArr();
1087: GroupShipDateOut := MscDateArr();
1088: GroupArrivalDateOut := MscDateArr();
1089: AtpLeadTimeOut := MscNumberArr();
1090: ErrorCodeOut := MscNumberArr();
1091: EndPeggingIdOut := MscNumberArr();
1092: OldSourceOrganizationIdOut := MscNumberArr();
1093: OldDemandClassOut := MscChar30Arr();
1086: RequestedDateQuantityOut := MscNumberArr();
1087: GroupShipDateOut := MscDateArr();
1088: GroupArrivalDateOut := MscDateArr();
1089: AtpLeadTimeOut := MscNumberArr();
1090: ErrorCodeOut := MscNumberArr();
1091: EndPeggingIdOut := MscNumberArr();
1092: OldSourceOrganizationIdOut := MscNumberArr();
1093: OldDemandClassOut := MscChar30Arr();
1094: RequestItemIdOut := MscNumberArr();
1087: GroupShipDateOut := MscDateArr();
1088: GroupArrivalDateOut := MscDateArr();
1089: AtpLeadTimeOut := MscNumberArr();
1090: ErrorCodeOut := MscNumberArr();
1091: EndPeggingIdOut := MscNumberArr();
1092: OldSourceOrganizationIdOut := MscNumberArr();
1093: OldDemandClassOut := MscChar30Arr();
1094: RequestItemIdOut := MscNumberArr();
1095: ReqItemReqDateQtyOut := MscNumberArr();
1088: GroupArrivalDateOut := MscDateArr();
1089: AtpLeadTimeOut := MscNumberArr();
1090: ErrorCodeOut := MscNumberArr();
1091: EndPeggingIdOut := MscNumberArr();
1092: OldSourceOrganizationIdOut := MscNumberArr();
1093: OldDemandClassOut := MscChar30Arr();
1094: RequestItemIdOut := MscNumberArr();
1095: ReqItemReqDateQtyOut := MscNumberArr();
1096: ReqItemAvailableDateOut := MscDateArr();
1090: ErrorCodeOut := MscNumberArr();
1091: EndPeggingIdOut := MscNumberArr();
1092: OldSourceOrganizationIdOut := MscNumberArr();
1093: OldDemandClassOut := MscChar30Arr();
1094: RequestItemIdOut := MscNumberArr();
1095: ReqItemReqDateQtyOut := MscNumberArr();
1096: ReqItemAvailableDateOut := MscDateArr();
1097: ReqItemAvailableDateQtyOut := MscNumberArr();
1098: RequestItemNameOut := MscChar40Arr();
1091: EndPeggingIdOut := MscNumberArr();
1092: OldSourceOrganizationIdOut := MscNumberArr();
1093: OldDemandClassOut := MscChar30Arr();
1094: RequestItemIdOut := MscNumberArr();
1095: ReqItemReqDateQtyOut := MscNumberArr();
1096: ReqItemAvailableDateOut := MscDateArr();
1097: ReqItemAvailableDateQtyOut := MscNumberArr();
1098: RequestItemNameOut := MscChar40Arr();
1099: OldInventoryItemIdOut := MscNumberArr();
1093: OldDemandClassOut := MscChar30Arr();
1094: RequestItemIdOut := MscNumberArr();
1095: ReqItemReqDateQtyOut := MscNumberArr();
1096: ReqItemAvailableDateOut := MscDateArr();
1097: ReqItemAvailableDateQtyOut := MscNumberArr();
1098: RequestItemNameOut := MscChar40Arr();
1099: OldInventoryItemIdOut := MscNumberArr();
1100: SubstFlagOut := MscNumberArr();
1101: BaseModelIdOut := MscNumberArr();
1095: ReqItemReqDateQtyOut := MscNumberArr();
1096: ReqItemAvailableDateOut := MscDateArr();
1097: ReqItemAvailableDateQtyOut := MscNumberArr();
1098: RequestItemNameOut := MscChar40Arr();
1099: OldInventoryItemIdOut := MscNumberArr();
1100: SubstFlagOut := MscNumberArr();
1101: BaseModelIdOut := MscNumberArr();
1102: OssErrorCodeOut := MscNumberArr();
1103: MatchedItemNameOut := MscChar255Arr();
1096: ReqItemAvailableDateOut := MscDateArr();
1097: ReqItemAvailableDateQtyOut := MscNumberArr();
1098: RequestItemNameOut := MscChar40Arr();
1099: OldInventoryItemIdOut := MscNumberArr();
1100: SubstFlagOut := MscNumberArr();
1101: BaseModelIdOut := MscNumberArr();
1102: OssErrorCodeOut := MscNumberArr();
1103: MatchedItemNameOut := MscChar255Arr();
1104: CascadeModelInfoToCompOut := MscNumberArr();
1097: ReqItemAvailableDateQtyOut := MscNumberArr();
1098: RequestItemNameOut := MscChar40Arr();
1099: OldInventoryItemIdOut := MscNumberArr();
1100: SubstFlagOut := MscNumberArr();
1101: BaseModelIdOut := MscNumberArr();
1102: OssErrorCodeOut := MscNumberArr();
1103: MatchedItemNameOut := MscChar255Arr();
1104: CascadeModelInfoToCompOut := MscNumberArr();
1105: PlanIdOut := MscNumberArr();
1098: RequestItemNameOut := MscChar40Arr();
1099: OldInventoryItemIdOut := MscNumberArr();
1100: SubstFlagOut := MscNumberArr();
1101: BaseModelIdOut := MscNumberArr();
1102: OssErrorCodeOut := MscNumberArr();
1103: MatchedItemNameOut := MscChar255Arr();
1104: CascadeModelInfoToCompOut := MscNumberArr();
1105: PlanIdOut := MscNumberArr();
1106: error_tracking_num :=2010;
1100: SubstFlagOut := MscNumberArr();
1101: BaseModelIdOut := MscNumberArr();
1102: OssErrorCodeOut := MscNumberArr();
1103: MatchedItemNameOut := MscChar255Arr();
1104: CascadeModelInfoToCompOut := MscNumberArr();
1105: PlanIdOut := MscNumberArr();
1106: error_tracking_num :=2010;
1107: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1108: IF (l_String <> 'OK') THEN
1101: BaseModelIdOut := MscNumberArr();
1102: OssErrorCodeOut := MscNumberArr();
1103: MatchedItemNameOut := MscChar255Arr();
1104: CascadeModelInfoToCompOut := MscNumberArr();
1105: PlanIdOut := MscNumberArr();
1106: error_tracking_num :=2010;
1107: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1108: IF (l_String <> 'OK') THEN
1109: Status := l_String;