APPS.PQH_DE_VLDJOBFTR_API dependencies on PQH_DE_WRKPLC_VLDTN_JOBFTRS

Line 26: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_JOBFTRS.OBJECT_VERSION_NUMBER%TYPE;

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

Line 28: l_Wrkplc_vldtn_JOBFTR_id PQH_DE_WRKPLC_VLDTN_JOBFTRS.WRKPLC_VLDTN_JOBFTR_ID%TYPE;

24:
25: l_proc varchar2(72) := g_package||'Insert_Vldtn_Jobftr';
26: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_JOBFTRS.OBJECT_VERSION_NUMBER%TYPE;
27: L_Effective_Date Date;
28: l_Wrkplc_vldtn_JOBFTR_id PQH_DE_WRKPLC_VLDTN_JOBFTRS.WRKPLC_VLDTN_JOBFTR_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_Jobftrs.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

146: ,P_WRKPLC_VLDTN_JOBFTR_ID In Number
147: ,p_object_version_number In out nocopy number) Is
148:
149: l_proc varchar2(72) := g_package||'Update_Vldtn_Jobftr';
150: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_Jobftrs.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);