APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSCSAFETYSTOCKREC

Line 115: PROCEDURE InsertSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);

111:
112: -- Private helper functions used by UPLOAD_SAFETY_STOCKS only.
113: FUNCTION ValidatePeriodStartDate(PlanId IN NUMBER, OrgId IN NUMBER, SrInstId IN NUMBER, PeriodStartDate IN DATE) RETURN VARCHAR2;
114: FUNCTION ValidateProjectDate(PlanId IN NUMBER, OrgId IN NUMBER, SrInstId IN NUMBER, ProjectId IN NUMBER, TaskId IN NUMBER, PlanningGroup IN VARCHAR2) RETURN VARCHAR2;
115: PROCEDURE InsertSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);
116: PROCEDURE UpdateSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);
117: FUNCTION ProcessSafetyStock(PlanId IN NUMBER, OwningOrgId IN NUMBER, SrInstId IN NUMBER, SafetyStockData IN MscSafetyStockRec) RETURN VARCHAR2;
118:
119: -- Private helper functions used by DOWNLOAD_SAFETY_STOCKS only.

Line 116: PROCEDURE UpdateSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);

112: -- Private helper functions used by UPLOAD_SAFETY_STOCKS only.
113: FUNCTION ValidatePeriodStartDate(PlanId IN NUMBER, OrgId IN NUMBER, SrInstId IN NUMBER, PeriodStartDate IN DATE) RETURN VARCHAR2;
114: FUNCTION ValidateProjectDate(PlanId IN NUMBER, OrgId IN NUMBER, SrInstId IN NUMBER, ProjectId IN NUMBER, TaskId IN NUMBER, PlanningGroup IN VARCHAR2) RETURN VARCHAR2;
115: PROCEDURE InsertSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);
116: PROCEDURE UpdateSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);
117: FUNCTION ProcessSafetyStock(PlanId IN NUMBER, OwningOrgId IN NUMBER, SrInstId IN NUMBER, SafetyStockData IN MscSafetyStockRec) RETURN VARCHAR2;
118:
119: -- Private helper functions used by DOWNLOAD_SAFETY_STOCKS only.
120: PROCEDURE QuerySafetyStocks(SafetyStockTbl OUT NOCOPY MscSafetyStockTbl, WhereClause IN VARCHAR2);

Line 117: FUNCTION ProcessSafetyStock(PlanId IN NUMBER, OwningOrgId IN NUMBER, SrInstId IN NUMBER, SafetyStockData IN MscSafetyStockRec) RETURN VARCHAR2;

113: FUNCTION ValidatePeriodStartDate(PlanId IN NUMBER, OrgId IN NUMBER, SrInstId IN NUMBER, PeriodStartDate IN DATE) RETURN VARCHAR2;
114: FUNCTION ValidateProjectDate(PlanId IN NUMBER, OrgId IN NUMBER, SrInstId IN NUMBER, ProjectId IN NUMBER, TaskId IN NUMBER, PlanningGroup IN VARCHAR2) RETURN VARCHAR2;
115: PROCEDURE InsertSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);
116: PROCEDURE UpdateSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);
117: FUNCTION ProcessSafetyStock(PlanId IN NUMBER, OwningOrgId IN NUMBER, SrInstId IN NUMBER, SafetyStockData IN MscSafetyStockRec) RETURN VARCHAR2;
118:
119: -- Private helper functions used by DOWNLOAD_SAFETY_STOCKS only.
120: PROCEDURE QuerySafetyStocks(SafetyStockTbl OUT NOCOPY MscSafetyStockTbl, WhereClause IN VARCHAR2);
121:

Line 1795: SafetyStockData IN MscSafetyStockRec

1791: -- Output: No output.
1792: -- =============================================================
1793: PROCEDURE InsertSafetyStock(
1794: PlanId IN NUMBER,
1795: SafetyStockData IN MscSafetyStockRec
1796: ) AS
1797: BEGIN
1798: BEGIN
1799: INSERT INTO msc_safety_stocks

Line 1846: SafetyStockData IN MscSafetyStockRec

1842: -- Output: No output.
1843: -- =============================================================
1844: PROCEDURE UpdateSafetyStock(
1845: PlanId IN NUMBER,
1846: SafetyStockData IN MscSafetyStockRec
1847: ) AS
1848: BEGIN
1849: UPDATE msc_safety_stocks
1850: SET

Line 1912: SafetyStockData IN MscSafetyStockRec

1908: FUNCTION ProcessSafetyStock(
1909: PlanId IN NUMBER,
1910: OwningOrgId IN NUMBER,
1911: SrInstId IN NUMBER,
1912: SafetyStockData IN MscSafetyStockRec
1913: ) RETURN VARCHAR2 AS
1914: l_String VARCHAR2(100);
1915: BEGIN
1916: -- check organization id

Line 2103: MscSafetyStockRec(

2099: EXIT WHEN ss_cursor%NOTFOUND;
2100:
2101: SafetyStockTbl.extend;
2102: SafetyStockTbl(SafetyStockTbl.count) :=
2103: MscSafetyStockRec(
2104: l_OrganizationId,
2105: l_SrInstanceId,
2106: l_ItemId,
2107: l_PeriodStartDate,

Line 2735: l_BadData MscSafetyStockRec;

2731: l_PlanId NUMBER;
2732: l_Date DATE;
2733: l_GoodRecCount NUMBER;
2734: l_BadRecCount NUMBER;
2735: l_BadData MscSafetyStockRec;
2736: BEGIN
2737: -- init global variables
2738: g_ErrorCode := '';
2739: