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.PQH_DE_VLD_NEWVER_DEL dependencies on PQH_DE_WRKPLC_VLDTN_VERS

Line 7: L_Wrkplc_Vldtn_Ver_Id Pqh_De_Wrkplc_Vldtn_Vers.Wrkplc_Vldtn_Ver_Id%TYPE;

3: Procedure PQH_DE_CREATE_VERSION
4: (p_WRKPLC_VLDTN_VER_ID In Number,
5: P_Business_Group_Id In Number) is
6:
7: L_Wrkplc_Vldtn_Ver_Id Pqh_De_Wrkplc_Vldtn_Vers.Wrkplc_Vldtn_Ver_Id%TYPE;
8: l_object_Version_Number Pqh_De_Wrkplc_Vldtn_Vers.object_Version_Number%TYPE;
9: l_Opr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Ops.object_Version_Number%TYPE;
10: l_Wrkplc_Vldtn_Op_Id Pqh_De_Wrkplc_Vldtn_Ops.Wrkplc_Vldtn_Op_Id%TYPE;
11: l_Job_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Jobs.object_Version_Number%TYPE;

Line 8: l_object_Version_Number Pqh_De_Wrkplc_Vldtn_Vers.object_Version_Number%TYPE;

4: (p_WRKPLC_VLDTN_VER_ID In Number,
5: P_Business_Group_Id In Number) is
6:
7: L_Wrkplc_Vldtn_Ver_Id Pqh_De_Wrkplc_Vldtn_Vers.Wrkplc_Vldtn_Ver_Id%TYPE;
8: l_object_Version_Number Pqh_De_Wrkplc_Vldtn_Vers.object_Version_Number%TYPE;
9: l_Opr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Ops.object_Version_Number%TYPE;
10: l_Wrkplc_Vldtn_Op_Id Pqh_De_Wrkplc_Vldtn_Ops.Wrkplc_Vldtn_Op_Id%TYPE;
11: l_Job_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Jobs.object_Version_Number%TYPE;
12: l_Wrkplc_Vldtn_Job_Id Pqh_De_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_JOb_Id%TYPE;

Line 24: From Pqh_De_Wrkplc_Vldtns b, Pqh_De_Wrkplc_Vldtn_Vers a

20: Select b.Wrkplc_Vldtn_Id,VALIDATION_NAME, EMPLOYMENT_TYPE, REMUNERATION_REGULATION, WRKPLC_VLDTN_VER_ID, VERSION_NUMBER,
21: REMUNERATION_JOB_DESCRIPTION, JOB_GROUP_ID, REMUNERATION_JOB_ID, DERIVED_GRADE_ID, DERIVED_CASE_GROUP_ID,
22: DERIVED_SUBCASGRP_ID, USER_ENTERABLE_GRADE_ID, USER_ENTERABLE_CASE_GROUP_ID, USER_ENTERABLE_SUBCASGRP_ID,
23: Tariff_contract_code, Tariff_Group_Code
24: From Pqh_De_Wrkplc_Vldtns b, Pqh_De_Wrkplc_Vldtn_Vers a
25: Where a.WRKPLC_VLDTN_VER_ID = p_WRKPLC_VLDTN_VER_ID and
26: a.Business_Group_Id = P_Business_Group_Id and
27: b.Wrkplc_Vldtn_Id = a.Wrkplc_Vldtn_Id and
28: b.Business_Group_Id = a.Business_Group_Id;

Line 159: From Pqh_De_Wrkplc_Vldtns b, Pqh_De_Wrkplc_Vldtn_Vers a

155: Select b.Wrkplc_Vldtn_Id,VALIDATION_NAME, EMPLOYMENT_TYPE, REMUNERATION_REGULATION, WRKPLC_VLDTN_VER_ID, VERSION_NUMBER,
156: REMUNERATION_JOB_DESCRIPTION, JOB_GROUP_ID, REMUNERATION_JOB_ID, DERIVED_GRADE_ID, DERIVED_CASE_GROUP_ID,
157: DERIVED_SUBCASGRP_ID, USER_ENTERABLE_GRADE_ID, USER_ENTERABLE_CASE_GROUP_ID, USER_ENTERABLE_SUBCASGRP_ID, Freeze,
158: a.Object_Version_Number Vers_ovn_Num, b.Object_Version_Number Def_ovn_Num
159: From Pqh_De_Wrkplc_Vldtns b, Pqh_De_Wrkplc_Vldtn_Vers a
160: Where a.WRKPLC_VLDTN_VER_ID = p_WRKPLC_VLDTN_VER_ID and
161: a.Business_Group_Id = P_Business_Group_Id and
162: b.Wrkplc_Vldtn_Id = a.Wrkplc_Vldtn_Id and
163: b.Business_Group_Id = a.Business_Group_Id;

Line 256: from Pqh_De_Wrkplc_Vldtn_vers

252: (p_WRKPLC_VLDTN_VER_ID => Defrec.WRKPLC_VLDTN_VER_ID
253: ,p_object_version_number => Defrec.Vers_ovn_Num);
254:
255: Select Count(*) into l_vldcnt
256: from Pqh_De_Wrkplc_Vldtn_vers
257: Where WRKPLC_VLDTN_ID = Defrec.WRKPLC_VLDTN_ID;
258:
259: If Nvl(l_vldcnt,0) = 0 Then
260: PQH_DE_VLDDEF_API.Delete_Vldtn_Defn