APPS.MTL_CYCLE_COUNT_ENTRIES_PKG dependencies on STANDARD

Line 4: --GSCC File.Sql.39 standard Bug:4410902

1: PACKAGE BODY MTL_CYCLE_COUNT_ENTRIES_PKG as
2: /* $Header: INVATCEB.pls 120.1.12000000.2 2007/07/18 10:29:20 abaid ship $ */
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,
6: X_Cycle_Count_Entry_Id NUMBER,
7: X_Last_Update_Date DATE,
8: X_Last_Updated_By NUMBER,

Line 733: l_standard_operation_id NUMBER;

729: -- END INVCONV
730:
731: ) IS
732: --Bug 6012343 -Added the following variables
733: l_standard_operation_id NUMBER;
734: l_wms_installed boolean;
735: l_return_status VARCHAR2(300);
736: l_msg_count NUMBER;
737: l_msg_data VARCHAR2(300);

Line 740: l_standard_operation_id := NULL;

736: l_msg_count NUMBER;
737: l_msg_data VARCHAR2(300);
738: BEGIN
739: /* Bug 6012343 */
740: l_standard_operation_id := NULL;
741: l_wms_installed := WMS_INSTALL.check_install(l_return_status,
742: l_msg_count,
743: l_msg_data,
744: x_organization_id);

Line 749: SELECT STANDARD_OPERATION_ID

745:
746: IF ((l_wms_installed) AND X_Entry_Status_Code=3) THEN
747:
748: BEGIN
749: SELECT STANDARD_OPERATION_ID
750: INTO l_standard_operation_id
751: FROM BOM_STANDARD_OPERATIONS
752: WHERE WMS_TASK_TYPE = 3
753: AND ORGANIZATION_ID = x_organization_id

Line 750: INTO l_standard_operation_id

746: IF ((l_wms_installed) AND X_Entry_Status_Code=3) THEN
747:
748: BEGIN
749: SELECT STANDARD_OPERATION_ID
750: INTO l_standard_operation_id
751: FROM BOM_STANDARD_OPERATIONS
752: WHERE WMS_TASK_TYPE = 3
753: AND ORGANIZATION_ID = x_organization_id
754: AND ROWNUM = 1;

Line 751: FROM BOM_STANDARD_OPERATIONS

747:
748: BEGIN
749: SELECT STANDARD_OPERATION_ID
750: INTO l_standard_operation_id
751: FROM BOM_STANDARD_OPERATIONS
752: WHERE WMS_TASK_TYPE = 3
753: AND ORGANIZATION_ID = x_organization_id
754: AND ROWNUM = 1;
755:

Line 758: l_standard_operation_id := NULL ;

754: AND ROWNUM = 1;
755:
756: EXCEPTION
757: WHEN OTHERS THEN
758: l_standard_operation_id := NULL ;
759: END;
760:
761: END IF ;
762:

Line 851: standard_operation_id = l_standard_operation_id --End of fix of Bug 6012343

847: Secondary_System_Qty_Current = X_Secondary_System_Qty_Current,
848: Secondary_System_Qty_Prior = X_Secondary_System_Qty_Prior,
849: Secondary_Adjustment_Quantity = X_Secondary_Adjustment_Qty,
850: -- END INVCONV
851: standard_operation_id = l_standard_operation_id --End of fix of Bug 6012343
852: WHERE rowid = X_Rowid;
853:
854: if (SQL%NOTFOUND) then
855: Raise NO_DATA_FOUND;