APPS.PQH_DE_VLDDEF_API dependencies on PQH_DE_WRKPLC_VLDTNS

Line 26: l_object_Version_Number PQH_DE_WRKPLC_VLDTNs.OBJECT_VERSION_NUMBER%TYPE;

22: -- Declare cursors and local variables
23: --
24:
25: l_proc varchar2(72) := g_package||'Insert_Vldtn_Defn';
26: l_object_Version_Number PQH_DE_WRKPLC_VLDTNs.OBJECT_VERSION_NUMBER%TYPE;
27: L_Effective_Date Date;
28: l_Wrkplc_vldtn_id PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID%TYPE;
29:
30: begin

Line 28: l_Wrkplc_vldtn_id PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID%TYPE;

24:
25: l_proc varchar2(72) := g_package||'Insert_Vldtn_Defn';
26: l_object_Version_Number PQH_DE_WRKPLC_VLDTNs.OBJECT_VERSION_NUMBER%TYPE;
27: L_Effective_Date Date;
28: l_Wrkplc_vldtn_id PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID%TYPE;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --

Line 148: l_object_Version_Number PQH_DE_WRKPLC_VLDTNs.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

144: ,p_WRKPLC_VLDTN_ID In number
145: ,p_object_version_number In out nocopy number) Is
146:
147: l_proc varchar2(72) := g_package||'Update_Vldtn_Defn';
148: l_object_Version_Number PQH_DE_WRKPLC_VLDTNs.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
149: L_Effective_Date Date;
150:
151: Begin
152: hr_utility.set_location('Entering:'|| l_proc, 10);