APPS.WMS_STRATEGY_ASSIGN_PKG dependencies on WMS_STRATEGY_ASSIGNMENTS

Line 48: SELECT rowid FROM WMS_STRATEGY_ASSIGNMENTS

44: X_Sequence_Number NUMBER DEFAULT NULL
45:
46: ) IS
47: CURSOR C IS
48: SELECT rowid FROM WMS_STRATEGY_ASSIGNMENTS
49: WHERE organization_id = X_Organization_Id
50: AND object_id = X_Object_Id
51: AND NVL(object_name,chr(0)) = NVL(X_Object_Name,chr(0))
52: AND pk1_value = X_PK1_Value

Line 66: INSERT INTO WMS_STRATEGY_ASSIGNMENTS(

62: = NVL(X_Effective_To,TO_DATE('31124000','DDMMYYYY'));
63:
64: BEGIN
65:
66: INSERT INTO WMS_STRATEGY_ASSIGNMENTS(
67: Organization_Id,
68: Object_Type_Code,
69: Object_Name,
70: Object_Id,

Line 195: FROM WMS_STRATEGY_ASSIGNMENTS

191: X_Date_Type_To NUMBER DEFAULT NULL,
192: X_Sequence_Number NUMBER DEFAULT NULL
193: ) IS
194: CURSOR C IS SELECT *
195: FROM WMS_STRATEGY_ASSIGNMENTS
196: WHERE rowid = X_Rowid
197: FOR UPDATE of Strategy_Id NOWAIT;
198: Recinfo C%ROWTYPE;
199:

Line 350: UPDATE WMS_STRATEGY_ASSIGNMENTS

346: X_Date_Type_To NUMBER DEFAULT NULL,
347: X_Sequence_Number NUMBER DEFAULT NULL
348: ) IS
349: BEGIN
350: UPDATE WMS_STRATEGY_ASSIGNMENTS
351: SET
352: organization_id = X_Organization_Id,
353: object_type_code = X_Object_Type_Code,
354: object_name = X_Object_Name,

Line 399: DELETE FROM WMS_STRATEGY_ASSIGNMENTS

395: END Update_Row;
396:
397: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
398: BEGIN
399: DELETE FROM WMS_STRATEGY_ASSIGNMENTS
400: WHERE rowid = X_Rowid;
401:
402: if (SQL%NOTFOUND) then
403: Raise NO_DATA_FOUND;