APPS.PQH_DE_OPERATION dependencies on PER_GEN_HIERARCHY_NODES_S

Line 18: l_seq Per_gen_Hierarchy_Nodes.Seq%TYPE;

14: l_Hierarchy_Version_Id Per_gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
15: l_Hierarchy_Node_Id Per_gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
16: l_Parent_Hierarchy_Node_Id Per_gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
17: l_Node_type Per_gen_Hierarchy_Nodes.Node_Type%TYPE;
18: l_seq Per_gen_Hierarchy_Nodes.Seq%TYPE;
19: l_proc Varchar2(100) := 'Pqh_De_Operation.Insert_Rec';
20:
21: Cursor Entity is
22: Select Hierarchy_Node_id

Line 62: Select Per_Gen_Hierarchy_Nodes_s.nextval

58: From Per_gen_Hierarchy_Nodes
59: Where Hierarchy_Version_Id = l_Hierarchy_Version_Id
60: and Node_type = l_Node_Type;
61:
62: Select Per_Gen_Hierarchy_Nodes_s.nextval
63: into l_Hierarchy_Node_Id from Dual;
64:
65: Insert into
66: Per_Gen_Hierarchy_Nodes

Line 249: l_seq Per_Gen_Hierarchy_nodes.Seq%TYPE;

245: l_oprHierarchy_Node_Id Per_gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
246: l_oprHierarchy_Version_Id Per_Gen_Hierarchy_Nodes.Hierarchy_Version_Id%TYPE;
247: l_oprParent_Hierarchy_Node_Id Per_Gen_Hierarchy_nodes.Parent_Hierarchy_Node_Id%TYPE;
248: l_oprNode_type Per_Gen_Hierarchy_nodes.Node_Type%TYPE;
249: l_seq Per_Gen_Hierarchy_nodes.Seq%TYPE;
250:
251: Cursor Operations is
252: Select WRKPLC_VLDTN_OP_ID, OPERATION_NUMBER, WRKPLC_OPERATION_ID
253: From Pqh_de_operations a, Pqh_De_Wrkplc_Vldtn_Ops b

Line 311: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_JHierarchy_Node_Id from Dual;

307: Open Hierarchy_Data(Jobrec.TATIGKEIT_NUMBER, 'OPR_JOB_DTLS');
308: Fetch Hierarchy_Data into l_Hierarchy_Node_Id, l_Hierarchy_Version_Id, l_Parent_Hierarchy_Node_Id, l_Node_type;
309: If Hierarchy_Data%NotFound Then
310: Close Hierarchy_Data;
311: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_JHierarchy_Node_Id from Dual;
312: l_Seq := Null;
313: Open Seq(l_OprParent_Hierarchy_Node_Id,'OPR_JOB_DTLS');
314: Fetch Seq into l_Seq;
315: Close Seq;

Line 335: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;

331: Open Hierarchy_Data(Jobftrrec.JOB_FEATURE_CODE, 'OPR_JOB_FTR');
332: Fetch Hierarchy_Data into l_Hierarchy_Node_Id, l_Hierarchy_Version_Id, l_Parent_Hierarchy_Node_Id, l_Node_type;
333: If Hierarchy_Data%NotFound Then
334: Close HIerarchy_data;
335: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;
336: Open Seq(l_OprParent_Hierarchy_Node_Id,'OPR_JOB_DTLS');
337: Fetch Seq into l_Seq;
338: Close Seq;
339: Insert into

Line 365: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;

361: Open Hierarchy_Data(Jobftrrec.JOB_FEATURE_CODE, 'OPR_JOB_FTR');
362: Fetch Hierarchy_Data into l_Hierarchy_Node_Id, l_Hierarchy_Version_Id, l_Parent_Hierarchy_Node_Id, l_Node_type;
363: If Hierarchy_Data%NotFound Then
364: Close HIerarchy_data;
365: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;
366: Open Seq(l_OprParent_Hierarchy_Node_Id,'OPR_JOB_DTLS');
367: Fetch Seq into l_Seq;
368: Close Seq;
369: Insert Into