APPS.WMS_DEPT_SUBS_PKG dependencies on WMS_DEPARTMENT_SUBINVENTORIES

Line 34: SELECT rowid FROM WMS_DEPARTMENT_SUBINVENTORIES

30: X_Attribute15 VARCHAR2 DEFAULT NULL,
31: X_Attribute_Category VARCHAR2 DEFAULT NULL
32: ) IS
33: CURSOR C IS
34: SELECT rowid FROM WMS_DEPARTMENT_SUBINVENTORIES
35: WHERE organization_id = X_Organization_Id
36: AND subinventory_code = X_subinventory_code
37: AND department_id = X_department_Id
38: AND NVL(effective_from_date,TO_DATE('01011900','DDMMYYYY'))

Line 45: INSERT INTO WMS_DEPARTMENT_SUBINVENTORIES(

41: = NVL(X_Effective_To_date, TO_DATE('31124000','DDMMYYYY'));
42:
43: BEGIN
44:
45: INSERT INTO WMS_DEPARTMENT_SUBINVENTORIES(
46: Organization_Id,
47: subinventory_Code,
48: department_Id,
49: Effective_From_date,

Line 140: FROM WMS_DEPARTMENT_SUBINVENTORIES

136: X_Attribute15 VARCHAR2 DEFAULT NULL,
137: X_Attribute_Category VARCHAR2 DEFAULT NULL
138: ) IS
139: CURSOR C IS SELECT *
140: FROM WMS_DEPARTMENT_SUBINVENTORIES
141: WHERE rowid = X_Rowid
142: FOR UPDATE of department_Id NOWAIT;
143: Recinfo C%ROWTYPE;
144:

Line 249: UPDATE WMS_DEPARTMENT_SUBINVENTORIES

245: X_Attribute15 VARCHAR2 DEFAULT NULL,
246: X_Attribute_Category VARCHAR2 DEFAULT NULL
247: ) IS
248: BEGIN
249: UPDATE WMS_DEPARTMENT_SUBINVENTORIES
250: SET
251: organization_id = X_Organization_Id,
252: subinventory_code = X_subinventory_Code,
253: department_id = X_department_Id,

Line 284: DELETE FROM WMS_DEPARTMENT_SUBINVENTORIES

280: END Update_Row;
281:
282: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
283: BEGIN
284: DELETE FROM WMS_DEPARTMENT_SUBINVENTORIES
285: WHERE rowid = X_Rowid;
286:
287: if (SQL%NOTFOUND) then
288: Raise NO_DATA_FOUND;