DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PA_WORK_TYPES_B

Line 6455: P_Work_Type_Id IN PA_Work_Types_B.Work_Type_Id%TYPE,

6451:
6452: /*-------------------------------------------------------------------------*/
6453:
6454: Procedure Validate_Work_Type_Exists(
6455: P_Work_Type_Id IN PA_Work_Types_B.Work_Type_Id%TYPE,
6456: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6457: X_Error_Code OUT NOCOPY Varchar2,
6458: X_Error_Type OUT NOCOPY Varchar2)
6459: Is

Line 6462: Cursor GetWorkTypeInfo(P_Work_Type_Id IN PA_Work_Types_B.Work_Type_Id%TYPE) IS

6458: X_Error_Type OUT NOCOPY Varchar2)
6459: Is
6460:
6461:
6462: Cursor GetWorkTypeInfo(P_Work_Type_Id IN PA_Work_Types_B.Work_Type_Id%TYPE) IS
6463: select
6464: name
6465: from pa_work_types_v w
6466: where w.work_type_Id = P_Work_Type_Id