APPS.E_CHANGES_INT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

        select stock_locator_control_code from mtl_parameters
         where organization_id = X_Org_Id;

Line: 22

        select meaning from mfg_lookups
         where lookup_type = 'BOM_CO_ACTION'
	   and lookup_code = 4;

Line: 35

FUNCTION Get_Update RETURN VARCHAR2 IS
  cursor c3 is
        select meaning from mfg_lookups
         where lookup_type = 'BOM_CO_ACTION'
	   and lookup_code = 2;

Line: 40

  update_code VARCHAR2(80);

Line: 43

  fetch c3 into update_code;

Line: 45

  return(update_code);

Line: 47

END Get_Update;

Line: 53

        select structure_id, category_set_name
          from mtl_default_sets_view
         where functional_area_id = 1;

Line: 73

  P_Update out varchar2,
  P_DefaultCategory out varchar2,
  P_DefaultCatStruct out number,
  P_Eng_Install out varchar2) is

  X_DefaultCat varchar2(80) := null;

Line: 85

  P_Update := Get_Update;

Line: 91

PROCEDURE After_Delete (X_Org_Id			NUMBER,
			X_Change_Notice			VARCHAR2) IS
BEGIN
  DELETE FROM bom_inventory_comps_interface bici
   WHERE EXISTS (SELECT null FROM eng_revised_items_interface erii
                  WHERE erii.organization_id = X_Org_Id
                    AND erii.change_notice = X_Change_Notice
                    AND erii.revised_item_sequence_id =
                        bici.revised_item_sequence_id);

Line: 101

  DELETE FROM eng_revised_items_interface
   WHERE organization_id = X_Org_Id
     AND change_notice = X_Change_Notice;

Line: 105

END After_Delete;

Line: 108

  PROCEDURE Insert_Row(X_Rowid                   IN OUT VARCHAR2,
                       X_Change_Notice                  VARCHAR2,
                       X_Organization_Id                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Description                    VARCHAR2,
                       X_Change_Order_Type_Id           NUMBER,
                       X_Responsible_Organization_Id    NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM ENG_ENG_CHANGES_INTERFACE
                 WHERE organization_id = X_Organization_Id
                   AND change_notice = X_Change_Notice;

Line: 125

       INSERT INTO ENG_ENG_CHANGES_INTERFACE(
              change_notice,
              organization_id,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              last_update_login,
              description,
              change_order_type_id,
              responsible_organization_id
             ) VALUES (
              X_Change_Notice,
              X_Organization_Id,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              X_Description,
              X_Change_Order_Type_Id,
              X_Responsible_Organization_Id
             );

Line: 156

  END Insert_Row;

Line: 167

        SELECT *
        FROM   ENG_ENG_CHANGES_INTERFACE
        WHERE  rowid = X_Rowid
        FOR UPDATE of Organization_Id NOWAIT;

Line: 179

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 209

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Change_Notice                  VARCHAR2,
                       X_Organization_Id                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Description                    VARCHAR2,
                       X_Change_Order_Type_Id           NUMBER,
                       X_Responsible_Organization_Id    NUMBER
  ) IS
  BEGIN
    UPDATE ENG_ENG_CHANGES_INTERFACE
    SET
       change_notice                   =     X_Change_Notice,
       organization_id                 =     X_Organization_Id,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       description                     =     X_Description,
       change_order_type_id            =     X_Change_Order_Type_Id,
       responsible_organization_id     =     X_Responsible_Organization_Id
    WHERE rowid = X_Rowid;

Line: 235

  END Update_Row;

Line: 237

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
    X_Org_Id	number;

Line: 243

    SELECT CHANGE_NOTICE, ORGANIZATION_ID
	INTO X_Change_Notice, X_Org_Id
	FROM ENG_ENG_CHANGES_INTERFACE
	WHERE ROWID = X_Rowid;

Line: 252

    DELETE FROM ENG_ENG_CHANGES_INTERFACE
    WHERE rowid = X_Rowid;

Line: 260

    E_Changes_Int_Pkg.After_Delete(X_Org_Id => X_Org_Id,
		 X_Change_Notice => X_Change_Notice);

Line: 263

  END Delete_Row;