eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PC_HIERARCHIES_PKG SQL Statements

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

Line: 4


procedure INSERT_ROW (
  X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
  X_NODE_ID in NUMBER,
  X_NODE_TYPE in VARCHAR2,
  X_NODE_REFERENCE in NUMBER,
  X_TOP_NODE_ID  in NUMBER,
  X_PARENT_NODE_ID in NUMBER,
  X_LEVEL_NUMBER in NUMBER,
  X_ACTIVE in VARCHAR2,
  X_ORG_ID in NUMBER DEFAULT NULL,
  X_DEPENDENT in VARCHAR2 DEFAULT NULL,
  X_START_DATE_EFFECTIVE in DATE,
  X_END_DATE_EFFECTIVE in DATE DEFAULT NULL,
  X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
) is

  CURSOR C is SELECT rowid FROM JTF_PC_HIERARCHIES
              WHERE  NODE_ID = X_Node_Id;

Line: 44


INSERT INTO jtf_pc_hierarchies (
NODE_ID,
NODE_TYPE,
NODE_REFERENCE,
TOP_NODE_ID,
PARENT_NODE_ID,
OBJECT_VERSION_NUMBER,
LEVEL_NUMBER,
ACTIVE,
ORG_ID,
DEPENDENT,
START_DATE_EFFECTIVE,
END_DATE_EFFECTIVE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15)
VALUES (
X_NODE_ID,
X_NODE_TYPE,
X_NODE_REFERENCE,
X_TOP_NODE_ID,
X_PARENT_NODE_ID,
1,
X_LEVEL_NUMBER,
X_ACTIVE,
X_ORG_ID,
X_DEPENDENT,
X_START_DATE_EFFECTIVE,
X_END_DATE_EFFECTIVE,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15
  );

Line: 121


  select count(node_id) into X_Rowid from jtf_pc_hierarchies;

Line: 123


end INSERT_ROW;

Line: 155


  CURSOR C is SELECT *
              FROM   jtf_pc_hierarchies
              WHERE  node_id = X_Node_Id
              FOR UPDATE of node_id NOWAIT;

Line: 167


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

Line: 245


procedure UPDATE_ROW (
  X_NODE_ID in NUMBER,
  X_NODE_TYPE in VARCHAR2,
  X_NODE_REFERENCE in NUMBER,
  X_TOP_NODE_ID  in NUMBER,
  X_PARENT_NODE_ID in NUMBER,
  X_LEVEL_NUMBER in NUMBER,
  X_ACTIVE in VARCHAR2,
  X_ORG_ID in NUMBER DEFAULT NULL,
  X_DEPENDENT in VARCHAR2 DEFAULT NULL,
  X_START_DATE_EFFECTIVE in DATE,
  X_END_DATE_EFFECTIVE in DATE DEFAULT NULL,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
) is

begin

  UPDATE jtf_pc_hierarchies
  SET    node_type = X_Node_Type,
         node_reference = X_Node_Reference,
         top_node_id = X_Top_Node_Id,
         parent_node_id = X_Parent_Node_Id,
         level_number = X_Level_Number,
         active = X_Active,
         org_id = X_Org_Id,
         dependent = X_Dependent,
         start_date_effective = X_Start_Date_Effective,
         end_date_effective = X_End_Date_Effective,
         object_version_number = X_Object_Version_Number + 1,
         attribute_category = X_Attribute_Category,
         attribute1 = X_Attribute1,
         attribute2 = X_Attribute2,
         attribute3 = X_Attribute3,
         attribute4 = X_Attribute4,
         attribute5 = X_Attribute5,
         attribute6 = X_Attribute6,
         attribute7 = X_Attribute7,
         attribute8 = X_Attribute8,
         attribute9 = X_Attribute9,
         attribute10 = X_Attribute10,
         attribute11 = X_Attribute11,
         attribute12 = X_Attribute12,
         attribute13 = X_Attribute13,
         attribute14 = X_Attribute14,
         attribute15 = X_Attribute15,
         last_update_date = X_Last_Update_Date,
         last_updated_by = X_Last_Updated_By,
         last_update_login = X_Last_Update_Login
  WHERE  node_id = X_Node_Id
  AND object_version_number = X_Object_Version_Number;

Line: 319


end UPDATE_ROW;

Line: 321


procedure DELETE_ROW (
  X_NODE_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is

begin

  DELETE FROM jtf_pc_hierarchies
  WHERE  node_id = X_Node_Id
  AND object_version_number = X_Object_Version_Number;

Line: 336


end DELETE_ROW;

Line: 378


  select count(*)
  into   h_record_exists
  from   jtf_pc_hierarchies
  where  node_id = X_Node_Id;

Line: 384


     jtf_pc_hierarchies_pkg.update_row (
	X_Node_Id			=> X_Node_Id,
    X_Node_Type         => X_Node_Type,
    X_Node_Reference    => X_Node_Reference,
	X_Top_Node_Id			=> X_Top_Node_Id,
	X_Parent_Node_Id		=> X_Parent_Node_Id,
    X_Level_Number          => X_Level_Number,
    X_Org_Id                => X_Org_Id,
    X_Dependent             => X_Dependent,
    X_Active                => X_Active,
	X_Start_Date_Effective	=> X_Start_Date_Effective,
	X_End_Date_Effective	=> X_End_Date_Effective,
	X_Attribute1			=> X_Attribute1,
	X_Attribute2			=> X_Attribute2,
	X_Attribute3			=> X_Attribute3,
	X_Attribute4			=> X_Attribute4,
	X_Attribute5			=> X_Attribute5,
	X_Attribute6			=> X_Attribute6,
	X_Attribute7			=> X_Attribute7,
	X_Attribute8			=> X_Attribute8,
	X_Attribute9			=> X_Attribute9,
	X_Attribute10			=> X_Attribute10,
	X_Attribute11			=> X_Attribute11,
	X_Attribute12			=> X_Attribute12,
	X_Attribute13			=> X_Attribute13,
	X_Attribute14			=> X_Attribute14,
	X_Attribute15			=> X_Attribute15,
	X_Attribute_Category	=> X_Attribute_Category,
    X_Object_Version_Number => X_Object_Version_Number,
	X_Last_Update_Date		=> sysdate,
	X_Last_Updated_By		=> user_id,
	X_Last_Update_Login		=> 0
     );

Line: 418


     jtf_pc_hierarchies_pkg.insert_row (
	X_Rowid				=> row_id,
	X_Node_Id			=> X_Node_Id,
    X_Node_Type         => X_Node_Type,
    X_Node_Reference    => X_Node_Reference,
	X_Top_Node_Id			=> X_Top_Node_Id,
	X_Parent_Node_Id		=> X_Parent_Node_Id,
    X_Level_Number          => X_Level_Number,
    X_Org_Id                => X_Org_Id,
    X_Dependent             => X_Dependent,
    X_Active                => X_Active,
	X_Start_Date_Effective	=> X_Start_Date_Effective,
	X_End_Date_Effective	=> X_End_Date_Effective,
	X_Attribute1			=> X_Attribute1,
	X_Attribute2			=> X_Attribute2,
	X_Attribute3			=> X_Attribute3,
	X_Attribute4			=> X_Attribute4,
	X_Attribute5			=> X_Attribute5,
	X_Attribute6			=> X_Attribute6,
	X_Attribute7			=> X_Attribute7,
	X_Attribute8			=> X_Attribute8,
	X_Attribute9			=> X_Attribute9,
	X_Attribute10			=> X_Attribute10,
	X_Attribute11			=> X_Attribute11,
	X_Attribute12			=> X_Attribute12,
	X_Attribute13			=> X_Attribute13,
	X_Attribute14			=> X_Attribute14,
	X_Attribute15			=> X_Attribute15,
	X_Attribute_Category	=> X_Attribute_Category,
	X_Creation_Date			=> sysdate,
	X_Created_By			=> user_id,
	X_Last_Update_Date		=> sysdate,
	X_Last_Updated_By		=> user_id,
	X_Last_Update_Login		=> 0
     );