APPS.PQH_DE_VLDVER_API dependencies on PQH_DE_WRKPLC_VLDTN_VERS

Line 41: l_Wrkplc_vldtn_Ver_id PQH_DE_WRKPLC_VLDTN_VERS.WRKPLC_VLDTN_VER_ID%TYPE;

37:
38: l_proc varchar2(500) := g_package||'Insert_Vldtn_Vern';
39: l_object_Version_Number PQH_DE_WRKPLC_VLDTNS.OBJECT_VERSION_NUMBER%TYPE;
40: L_Effective_Date Date;
41: l_Wrkplc_vldtn_Ver_id PQH_DE_WRKPLC_VLDTN_VERS.WRKPLC_VLDTN_VER_ID%TYPE;
42: l_version_Number PQH_DE_WRKPLC_VLDTN_VERS.VERSION_NUMBER%TYPE;
43: begin
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --

Line 42: l_version_Number PQH_DE_WRKPLC_VLDTN_VERS.VERSION_NUMBER%TYPE;

38: l_proc varchar2(500) := g_package||'Insert_Vldtn_Vern';
39: l_object_Version_Number PQH_DE_WRKPLC_VLDTNS.OBJECT_VERSION_NUMBER%TYPE;
40: L_Effective_Date Date;
41: l_Wrkplc_vldtn_Ver_id PQH_DE_WRKPLC_VLDTN_VERS.WRKPLC_VLDTN_VER_ID%TYPE;
42: l_version_Number PQH_DE_WRKPLC_VLDTN_VERS.VERSION_NUMBER%TYPE;
43: begin
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Issue a savepoint

Line 57: from Pqh_De_Wrkplc_Vldtn_vers

53: --
54: -- Call Before Process User Hook
55: --
56: Select Nvl(Max(Version_number),0) + 1 into l_Version_Number
57: from Pqh_De_Wrkplc_Vldtn_vers
58: where Wrkplc_Vldtn_Id = p_WRKPLC_VLDTN_ID;
59: begin
60: PQH_DE_VLDVER_BK1.Insert_Vldtn_Vern_b
61: (p_effective_date => l_Effective_Date

Line 213: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_VERS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

209: ,p_WRKPLC_VLDTN_VER_ID In Number
210: ,p_object_version_number in out nocopy number) Is
211:
212: l_proc varchar2(72) := g_package||'Update_Vldtn_Vern';
213: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_VERS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
214: L_Effective_Date Date;
215:
216: Begin
217: hr_utility.set_location('Entering:'|| l_proc, 10);