APPS.PQH_DE_OPERATION dependencies on PQH_DE_OPERATION

Line 1: Package Body Pqh_De_Operation As

1: Package Body Pqh_De_Operation As
2: /* $Header: pqoprpln.pkb 115.9 2002/12/12 05:23:23 vevenkat noship $ */
3: Procedure Insert_Rec
4: (p_BUSINESS_GROUP_ID IN NUMBER
5: ,p_effective_Date IN Date

Line 19: l_proc Varchar2(100) := 'Pqh_De_Operation.Insert_Rec';

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
23: from Per_gen_Hierarchy_Nodes a, Pqh_de_operations b

Line 23: from Per_gen_Hierarchy_Nodes a, Pqh_de_operations b

19: l_proc Varchar2(100) := 'Pqh_De_Operation.Insert_Rec';
20:
21: Cursor Entity is
22: Select Hierarchy_Node_id
23: from Per_gen_Hierarchy_Nodes a, Pqh_de_operations b
24: Where Parent_hierarchy_Node_id = p_Operation_Group
25: and Node_type = 'OPR_OPTS'
26: and Entity_Id = b.Operation_Number
27: and b.Operation_Id = P_Parent_Entity_Id;

Line 92: l_desc Pqh_De_Operations.Description%TYPE;

88: ,p_Operation_Job_Number IN Varchar2
89: ,p_Operation_Job_Id IN Number) is
90:
91: l_Hierarchy_Node_Id Per_Gen_Hierarchy_nodes.Hierarchy_node_Id%TYPE;
92: l_desc Pqh_De_Operations.Description%TYPE;
93: l_Job_Id Pqh_de_Tatigkeit_details.TATIGKEIT_DETAIL_ID%TYPE;
94: l_Wrkplc_Vldtn_Op_Id Pqh_de_Wrkplc_Vldtn_ops.Wrkplc_Vldtn_Op_Id%TYPE;
95: l_WRKPLC_VLDTN_JObFTR_ID Pqh_de_Wrkplc_Vldtn_JobFtrs.WRKPLC_VLDTN_JObFTR_ID%TYPE;
96: l_Object_Version_Number Pqh_de_Wrkplc_Vldtn_ops.Object_Version_Number%TYPE;

Line 109: From Pqh_De_Operations

105: Connect By Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_Id; */
106:
107: Cursor op_desc Is
108: Select Description
109: From Pqh_De_Operations
110: Where OPERATION_NUMBER = p_Operation_Job_Number;
111:
112: Cursor Job_desc(p_Job_Number In Varchar2) is
113: Select TATIGKEIT_DETAIL_ID, Description

Line 253: From Pqh_de_operations a, Pqh_De_Wrkplc_Vldtn_Ops b

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
254: Where WRKPLC_VLDTN_VER_ID = p_WRKPLC_VLDTN_VER_ID
255: and a.Operation_Id = WRKPLC_OPERATION_ID;
256:
257: Cursor Jobs(p_WRKPLC_VLDTN_OP_ID in Number) is