APPS.PQH_DE_VLDLVL_API dependencies on PQH_DE_WRKPLC_VLDTN_LVLNUMS

Line 26: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_LVLNUMS.OBJECT_VERSION_NUMBER%TYPE;

22: -- Declare cursors and local variables
23: --
24:
25: l_proc varchar2(72) := g_package||'Insert_Vldtn_Lvl';
26: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_LVLNUMS.OBJECT_VERSION_NUMBER%TYPE;
27: L_Effective_Date Date;
28: l_Wrkplc_vldtn_LvlNum_id PQH_DE_WRKPLC_VLDTN_LVLNUMS.WRKPLC_VLDTN_LvlNum_ID%TYPE;
29:
30: begin

Line 28: l_Wrkplc_vldtn_LvlNum_id PQH_DE_WRKPLC_VLDTN_LVLNUMS.WRKPLC_VLDTN_LvlNum_ID%TYPE;

24:
25: l_proc varchar2(72) := g_package||'Insert_Vldtn_Lvl';
26: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_LVLNUMS.OBJECT_VERSION_NUMBER%TYPE;
27: L_Effective_Date Date;
28: l_Wrkplc_vldtn_LvlNum_id PQH_DE_WRKPLC_VLDTN_LVLNUMS.WRKPLC_VLDTN_LvlNum_ID%TYPE;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --

Line 150: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_LVLNUMS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

146: ,P_WRKPLC_VLDTN_LVLNUM_ID In Number
147: ,p_object_version_number IN out nocopy number) Is
148:
149: l_proc varchar2(72) := g_package||'Update_Vldtn_Lvl';
150: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_LVLNUMS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
151: L_Effective_Date Date;
152:
153: Begin
154: hr_utility.set_location('Entering:'|| l_proc, 10);