APPS.MTL_MOVEMENT_STATISTICS1_PKG dependencies on MTL_MOVEMENT_STATISTICS

Line 1: PACKAGE BODY MTL_MOVEMENT_STATISTICS1_PKG as

1: PACKAGE BODY MTL_MOVEMENT_STATISTICS1_PKG as
2: /* $Header: INVTTM1B.pls 120.1 2005/06/11 12:53:42 appldev $ */
3:
4: procedure insert_row ( v_rowid IN OUT NOCOPY /* file.sql.39 change */ varchar2,
5: v_movement_id IN OUT NOCOPY /* file.sql.39 change */ number,

Line 116: CURSOR C IS SELECT rowid FROM mtl_movement_statistics

112: v_attribute14 varchar2 ,
113: v_attribute15 varchar2) is
114:
115:
116: CURSOR C IS SELECT rowid FROM mtl_movement_statistics
117: WHERE movement_id = v_movement_id;
118:
119: CURSOR C2 IS SELECT mtl_movement_statistics_s.nextval FROM dual;
120:

Line 119: CURSOR C2 IS SELECT mtl_movement_statistics_s.nextval FROM dual;

115:
116: CURSOR C IS SELECT rowid FROM mtl_movement_statistics
117: WHERE movement_id = v_movement_id;
118:
119: CURSOR C2 IS SELECT mtl_movement_statistics_s.nextval FROM dual;
120:
121: BEGIN
122: if (v_movement_Id is NULL) then
123: OPEN C2;

Line 128: INSERT INTO mtl_movement_statistics(

124: FETCH C2 INTO v_movement_Id;
125: CLOSE C2;
126: end if;
127:
128: INSERT INTO mtl_movement_statistics(
129: MOVEMENT_ID ,
130: ORGANIZATION_ID ,
131: ENTITY_ORG_ID ,
132: MOVEMENT_TYPE ,

Line 364: DELETE FROM mtl_movement_statistics

360:
361: procedure delete_row(v_rowid varchar2) is
362: begin
363:
364: DELETE FROM mtl_movement_statistics
365: WHERE rowid = v_RowId;
366:
367: if (SQL%NOTFOUND) then
368: Raise NO_DATA_FOUND;

Line 372: END MTL_MOVEMENT_STATISTICS1_PKG;

368: Raise NO_DATA_FOUND;
369: end if;
370: END Delete_Row;
371:
372: END MTL_MOVEMENT_STATISTICS1_PKG;