APPS.JTF_PC_HIERARCHIES_PKG dependencies on JTF_PC_HIERARCHIES

Line 1: Package Body JTF_PC_HIERARCHIES_PKG AS

1: Package Body JTF_PC_HIERARCHIES_PKG AS
2: /*$Header: jtfpjphb.pls 120.2 2005/08/18 22:54:58 stopiwal ship $*/
3:
4: procedure INSERT_ROW (
5: X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 40: CURSOR C is SELECT rowid FROM JTF_PC_HIERARCHIES

36: X_LAST_UPDATED_BY in NUMBER,
37: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
38: ) is
39:
40: CURSOR C is SELECT rowid FROM JTF_PC_HIERARCHIES
41: WHERE NODE_ID = X_Node_Id;
42: begin
43:
44: INSERT INTO jtf_pc_hierarchies (

Line 44: INSERT INTO jtf_pc_hierarchies (

40: CURSOR C is SELECT rowid FROM JTF_PC_HIERARCHIES
41: WHERE NODE_ID = X_Node_Id;
42: begin
43:
44: INSERT INTO jtf_pc_hierarchies (
45: NODE_ID,
46: NODE_TYPE,
47: NODE_REFERENCE,
48: TOP_NODE_ID,

Line 121: select count(node_id) into X_Rowid from jtf_pc_hierarchies;

117: CLOSE C;
118: Raise NO_DATA_FOUND;
119: end if;
120: CLOSE C;
121: select count(node_id) into X_Rowid from jtf_pc_hierarchies;
122:
123: end INSERT_ROW;
124:
125: procedure LOCK_ROW (

Line 156: FROM jtf_pc_hierarchies

152: X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL
153: ) is
154:
155: CURSOR C is SELECT *
156: FROM jtf_pc_hierarchies
157: WHERE node_id = X_Node_Id
158: FOR UPDATE of node_id NOWAIT;
159: Recinfo C%ROWTYPE;
160:

Line 281: UPDATE jtf_pc_hierarchies

277: ) is
278:
279: begin
280:
281: UPDATE jtf_pc_hierarchies
282: SET node_type = X_Node_Type,
283: node_reference = X_Node_Reference,
284: top_node_id = X_Top_Node_Id,
285: parent_node_id = X_Parent_Node_Id,

Line 328: DELETE FROM jtf_pc_hierarchies

324: ) is
325:
326: begin
327:
328: DELETE FROM jtf_pc_hierarchies
329: WHERE node_id = X_Node_Id
330: AND object_version_number = X_Object_Version_Number;
331:
332: if (SQL%NOTFOUND) then

Line 380: from jtf_pc_hierarchies

376: user_id := 1;
377:
378: select count(*)
379: into h_record_exists
380: from jtf_pc_hierarchies
381: where node_id = X_Node_Id;
382:
383: if (h_record_exists > 0) then
384: jtf_pc_hierarchies_pkg.update_row (

Line 384: jtf_pc_hierarchies_pkg.update_row (

380: from jtf_pc_hierarchies
381: where node_id = X_Node_Id;
382:
383: if (h_record_exists > 0) then
384: jtf_pc_hierarchies_pkg.update_row (
385: X_Node_Id => X_Node_Id,
386: X_Node_Type => X_Node_Type,
387: X_Node_Reference => X_Node_Reference,
388: X_Top_Node_Id => X_Top_Node_Id,

Line 418: jtf_pc_hierarchies_pkg.insert_row (

414: X_Last_Updated_By => user_id,
415: X_Last_Update_Login => 0
416: );
417: else
418: jtf_pc_hierarchies_pkg.insert_row (
419: X_Rowid => row_id,
420: X_Node_Id => X_Node_Id,
421: X_Node_Type => X_Node_Type,
422: X_Node_Reference => X_Node_Reference,

Line 457: END JTF_PC_HIERARCHIES_PKG;

453: end if;
454:
455: end LOAD_ROW;*/
456:
457: END JTF_PC_HIERARCHIES_PKG;