DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on HXC_TIME_BUILDING_BLOCKS

Line 38: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,

34: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
35: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
36: Vendor_Id Pa_Expenditures_All.Vendor_Id%TYPE,
37: PO_Header_Id Number,
38: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
39: Action Varchar2(30),
40: -- bug 10253400: Payroll integration enhancement for 12.2..start
41: Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE,
42: Location_Id Pa_Expenditure_Items_All.Location_ID%TYPE,

Line 61: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,

57: Task_Id Pa_Tasks.Task_Id%TYPE,
58: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
59: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
60: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
61: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,
62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
63: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
64: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%TYPE,
65: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 103: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,

99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
100: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
101: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
102: PO_Header_Id Number,
103: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
104: Action Varchar2(30),
105: -- bug 10253400: Payroll integration enhancement for 12.2..start
106: Job_Id PA_Expenditure_Items_All.Job_ID%TYPE,
107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 181: -- P_Time_Building_Block_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

177: -- P_Message_Name - Fnd_New_Messages.Message_Name%TYPE
178: -- P_Message_Level - Varchar2
179: -- P_Message_Field - Varchar2
180: -- P_Msg_Tokens - Pa_Otc_Api.Message_Tokens
181: -- P_Time_Building_Block_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
182: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
183: -- P_Message_App - Varchar2 Default 'PA'
184: --
185: -- OUT

Line 197: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

193: P_Message_Name IN Fnd_New_Messages.Message_Name%TYPE,
194: P_Message_Level IN Varchar2,
195: P_Message_Field IN Varchar2,
196: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,
197: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
198: P_Time_Attribute_Id IN Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
199: P_Message_App IN Varchar2 Default 'PA');
200:
201:

Line 369: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

365: -- IN
366: -- P_New_Old_BB - Varchar2 Allowed Values:
367: -- Import values: 'OLD' 'NEW'
368: -- Validation value:
369: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
370: -- P_Detail_Index - Binary_Integer
371: -- P_Old_Detl_Ind - Binary_Integer
372: -- OUT
373: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec

Line 379: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

375: /*--------------------------------------------------------------------------*/
376:
377: Procedure PopulateProjRec(
378: P_New_Old_BB IN Varchar2,
379: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
380: P_Detail_Index IN Binary_Integer,
381: P_Old_Detl_Ind IN Binary_Integer,
382: P_Timecard_Rec OUT NOCOPY Pa_Otc_Api.Timecard_Rec); -- 2672653
383:

Line 406: Procedure GetDetailIndex( P_Detail_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

402:
403: /*--------------------------------------------------------------------------*/
404:
405:
406: Procedure GetDetailIndex( P_Detail_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
407: X_Detail_Index OUT NOCOPY Binary_Integer);
408:
409:
410:

Line 675: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

671: -- DETAIL record being looped thru.
672: --
673: -- Parameters :
674: -- IN
675: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
676: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
677: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
678: -- P_BB_Changed - Varchar2
679: -- P_BB_New - Varchar2

Line 676: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE

672: --
673: -- Parameters :
674: -- IN
675: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
676: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
677: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
678: -- P_BB_Changed - Varchar2
679: -- P_BB_New - Varchar2
680: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec

Line 677: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE

673: -- Parameters :
674: -- IN
675: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
676: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
677: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
678: -- P_BB_Changed - Varchar2
679: -- P_BB_New - Varchar2
680: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec
681: -- P_Mode - Varchar2

Line 693: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

689:
690: /*--------------------------------------------------------------------------*/
691:
692: Procedure DetermineProcessingFlags (
693: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
694: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
695: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
696: P_BB_Changed IN Varchar2,
697: P_BB_New IN Varchar2,

Line 694: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,

690: /*--------------------------------------------------------------------------*/
691:
692: Procedure DetermineProcessingFlags (
693: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
694: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
695: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
696: P_BB_Changed IN Varchar2,
697: P_BB_New IN Varchar2,
698: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,

Line 695: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,

691:
692: Procedure DetermineProcessingFlags (
693: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
694: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
695: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
696: P_BB_Changed IN Varchar2,
697: P_BB_New IN Varchar2,
698: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,
699: P_Mode IN Varchar2,

Line 854: -- IN P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE

850: -- combinations will take place within the code before passing it to OTC. Any combo that
851: -- is not valid for the day in question will not be pulled over.
852: --
853: -- Parameters :
854: -- IN P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE
855: -- P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE
856: -- P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE
857: -- OUT
858: -- P_Attributes OUT Varchar2

Line 855: -- P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE

851: -- is not valid for the day in question will not be pulled over.
852: --
853: -- Parameters :
854: -- IN P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE
855: -- P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE
856: -- P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE
857: -- OUT
858: -- P_Attributes OUT Varchar2
859: -- P_Timecard OUT Varchar2

Line 856: -- P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE

852: --
853: -- Parameters :
854: -- IN P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE
855: -- P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE
856: -- P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE
857: -- OUT
858: -- P_Attributes OUT Varchar2
859: -- P_Timecard OUT Varchar2
860: -- P_Messages OUT Varchar2

Line 866: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,

862:
863: /*--------------------------------------------------------------------------*/
864:
865: Procedure GetPRMAssignTemplates(
866: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
867: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
868: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
869: P_Attributes OUT NOCOPY Varchar2,
870: P_Timecard OUT NOCOPY Varchar2,

Line 867: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,

863: /*--------------------------------------------------------------------------*/
864:
865: Procedure GetPRMAssignTemplates(
866: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
867: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
868: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
869: P_Attributes OUT NOCOPY Varchar2,
870: P_Timecard OUT NOCOPY Varchar2,
871: P_Messages OUT NOCOPY Varchar2);

Line 868: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,

864:
865: Procedure GetPRMAssignTemplates(
866: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
867: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
868: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
869: P_Attributes OUT NOCOPY Varchar2,
870: P_Timecard OUT NOCOPY Varchar2,
871: P_Messages OUT NOCOPY Varchar2);
872:

Line 891: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

887: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
888: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
889: -- OUT
890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
891: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
892: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
893: -- X_Pass_Val_Flag - Varchar2
894: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE
895:

Line 894: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE

890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
891: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
892: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
893: -- X_Pass_Val_Flag - Varchar2
894: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE
895:
896: /*--------------------------------------------------------------------------*/
897:
898:

Line 903: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

899: Procedure FindandValidateHeader(
900: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
901: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
902: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
903: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
904: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
905: X_Pass_Val_Flag OUT NOCOPY Varchar2,
906: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);
907:

Line 906: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);

902: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
903: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
904: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
905: X_Pass_Val_Flag OUT NOCOPY Varchar2,
906: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);
907:
908: -- =======================================================================
909: -- Start of Comments
910: -- API Name : Wf_AutoApproval_BusMsg