APPS.MTL_MOVEMENT_PARAMETERS_PKG dependencies on MTL_MOVEMENT_PARAMETERS

Line 1: PACKAGE BODY MTL_MOVEMENT_PARAMETERS_PKG as

1: PACKAGE BODY MTL_MOVEMENT_PARAMETERS_PKG as
2: /* $Header: INVTTMVB.pls 120.1 2005/06/11 13:03:02 appldev $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5:

Line 61: CURSOR C IS SELECT rowid FROM MTL_MOVEMENT_PARAMETERS

57: X_Attribute28 VARCHAR2,
58: X_Attribute29 VARCHAR2,
59: X_Attribute30 VARCHAR2
60: ) IS
61: CURSOR C IS SELECT rowid FROM MTL_MOVEMENT_PARAMETERS
62: WHERE entity_org_id = X_Entity_Org_Id;
63:
64: BEGIN
65:

Line 67: INSERT INTO MTL_MOVEMENT_PARAMETERS(

63:
64: BEGIN
65:
66:
67: INSERT INTO MTL_MOVEMENT_PARAMETERS(
68:
69: entity_org_id,
70: period_set_name,
71: weight_uom_code,

Line 246: FROM MTL_MOVEMENT_PARAMETERS

242: X_Attribute30 VARCHAR2
243: ) IS
244: CURSOR C IS
245: SELECT *
246: FROM MTL_MOVEMENT_PARAMETERS
247: WHERE rowid = X_Rowid
248: FOR UPDATE of Entity_Org_Id NOWAIT;
249: Recinfo C%ROWTYPE;
250:

Line 471: UPDATE MTL_MOVEMENT_PARAMETERS

467: X_Attribute30 VARCHAR2
468:
469: ) IS
470: BEGIN
471: UPDATE MTL_MOVEMENT_PARAMETERS
472: SET
473: entity_org_id = X_Entity_Org_Id,
474: period_set_name = X_Period_Set_Name,
475: weight_uom_code = X_Weight_Uom_Code,

Line 533: DELETE FROM MTL_MOVEMENT_PARAMETERS

529: end if;
530: END Update_Row;
531: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
532: BEGIN
533: DELETE FROM MTL_MOVEMENT_PARAMETERS
534: WHERE rowid = X_Rowid;
535:
536: if (SQL%NOTFOUND) then
537: Raise NO_DATA_FOUND;

Line 542: END MTL_MOVEMENT_PARAMETERS_PKG;

538: end if;
539: END Delete_Row;
540:
541:
542: END MTL_MOVEMENT_PARAMETERS_PKG;