DBA Data[Home] [Help]

APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSCPLANNEDSUPPLYTBL

Line 2975: BadRecTbl OUT NOCOPY MscPlannedSupplyTbl,

2971: -- BadRecTbl List of firmed plann orders that are failed the validation.
2972: -- =============================================================
2973: PROCEDURE UPLOAD_PLANNED_SUPPLY(
2974: Status OUT NOCOPY VARCHAR2,
2975: BadRecTbl OUT NOCOPY MscPlannedSupplyTbl,
2976: -- UserId IN NUMBER,
2977: -- ResponsibilityId IN NUMBER,
2978: UserName IN VARCHAR2,
2979: RespName IN VARCHAR2,

Line 2986: PlannedSupplyTbl IN MscPlannedSupplyTbl

2982: Language IN VARCHAR2,
2983: PlanName IN VARCHAR2,
2984: OwningOrgId IN NUMBER,
2985: SrInstanceId IN NUMBER,
2986: PlannedSupplyTbl IN MscPlannedSupplyTbl
2987: ) AS
2988: l_String VARCHAR2(100);
2989: l_ResponsibilityId NUMBER;
2990: l_SecurityGroupId NUMBER;

Line 3001: BadRecTbl := MscPlannedSupplyTbl();

2997: -- init global variables
2998: g_ErrorCode := '';
2999:
3000: -- init bad record table
3001: BadRecTbl := MscPlannedSupplyTbl();
3002:
3003: -- query user id, responsibility id and security group id
3004: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
3005: IF (l_String <> 'OK') THEN