[Home] [Help]
1: PACKAGE BODY MTL_CYCLE_COUNT_HEADERS_PKG as
2: /* $Header: INVADCYB.pls 120.1 2005/06/19 05:43:32 appldev $ */
3: --Added NOCOPY hint to X_Rowid IN OUT parameter to comply with
4: --GSCC File.Sql.39 standard Bug:4410902
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
60: , X_Container_Enabled_Flag NUMBER DEFAULT NULL
61: , X_Container_Adjustment_Option NUMBER DEFAULT NULL
62: , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
63: ) IS
64: CURSOR C IS SELECT rowid FROM mtl_cycle_count_headers
65: WHERE cycle_count_header_id = X_Cycle_Count_Header_Id;
66:
67: BEGIN
68: INSERT INTO mtl_cycle_count_headers(
64: CURSOR C IS SELECT rowid FROM mtl_cycle_count_headers
65: WHERE cycle_count_header_id = X_Cycle_Count_Header_Id;
66:
67: BEGIN
68: INSERT INTO mtl_cycle_count_headers(
69: cycle_count_header_id,
70: organization_id,
71: last_update_date,
72: last_updated_by,
249: , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
250: ) IS
251: CURSOR C IS
252: SELECT *
253: FROM mtl_cycle_count_headers
254: WHERE rowid = X_Rowid
255: FOR UPDATE of Cycle_Count_Header_Id NOWAIT;
256: Recinfo C%ROWTYPE;
257:
476: , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
477: ) IS
478:
479: BEGIN
480: UPDATE mtl_cycle_count_headers
481: SET
482: cycle_count_header_id = X_Cycle_Count_Header_Id,
483: organization_id = X_Organization_Id,
484: last_update_date = X_Last_Update_Date,
541: end if;
542: END Update_Row;
543: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
544: BEGIN
545: DELETE FROM mtl_cycle_count_headers
546: WHERE rowid = X_Rowid;
547:
548: if (SQL%NOTFOUND) then
549: Raise NO_DATA_FOUND;
550: end if;
551: END Delete_Row;
552:
553:
554: END MTL_CYCLE_COUNT_HEADERS_PKG;