APPS.PQH_DE_VLDOPR_API dependencies on PQH_DE_WRKPLC_VLDTN_OPS

Line 27: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_OPS.OBJECT_VERSION_NUMBER%TYPE;

23: -- Declare cursors and local variables
24: --
25:
26: l_proc varchar2(72) := g_package||'Insert_Vldtn_Oprn';
27: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_OPS.OBJECT_VERSION_NUMBER%TYPE;
28: L_Effective_Date Date;
29: l_Wrkplc_vldtn_Op_id PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID%TYPE;
30:
31: begin

Line 29: l_Wrkplc_vldtn_Op_id PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID%TYPE;

25:
26: l_proc varchar2(72) := g_package||'Insert_Vldtn_Oprn';
27: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_OPS.OBJECT_VERSION_NUMBER%TYPE;
28: L_Effective_Date Date;
29: l_Wrkplc_vldtn_Op_id PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID%TYPE;
30:
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --

Line 155: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_OPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

151: ,P_WRKPLC_VLDTN_OP_ID In Number
152: ,p_object_version_number In out nocopy number) Is
153:
154: l_proc varchar2(72) := g_package||'Update_Vldtn_Oprn';
155: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_OPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
156: L_Effective_Date Date;
157:
158: Begin
159: hr_utility.set_location('Entering:'|| l_proc, 10);