eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:
41: TYPE Timecard_Table IS Table OF Timecard_Rec
42: INDEX BY Binary_Integer;

Line 54: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,

50: Task_Id Pa_Tasks.Task_Id%TYPE,
51: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
52: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
53: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
54: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,
55: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
56: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
57: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%TYPE,
58: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 96: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,

92: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
93: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
94: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
95: PO_Header_Id Number,
96: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
97: Action Varchar2(30));
98:
99: G_timecard_table Timecard_Table;
100:

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

160: -- P_Message_Name - Fnd_New_Messages.Message_Name%TYPE
161: -- P_Message_Level - Varchar2
162: -- P_Message_Field - Varchar2
163: -- P_Msg_Tokens - Pa_Otc_Api.Message_Tokens
164: -- P_Time_Building_Block_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
165: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
166: -- P_Message_App - Varchar2 Default 'PA'
167: --
168: -- OUT

Line 180: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

176: P_Message_Name IN Fnd_New_Messages.Message_Name%TYPE,
177: P_Message_Level IN Varchar2,
178: P_Message_Field IN Varchar2,
179: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,
180: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
181: P_Time_Attribute_Id IN Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
182: P_Message_App IN Varchar2 Default 'PA');
183:
184:

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

348: -- IN
349: -- P_New_Old_BB - Varchar2 Allowed Values:
350: -- Import values: 'OLD' 'NEW'
351: -- Validation value:
352: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
353: -- P_Detail_Index - Binary_Integer
354: -- P_Old_Detl_Ind - Binary_Integer
355: -- OUT
356: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec

Line 362: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

358: /*--------------------------------------------------------------------------*/
359:
360: Procedure PopulateProjRec(
361: P_New_Old_BB IN Varchar2,
362: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
363: P_Detail_Index IN Binary_Integer,
364: P_Old_Detl_Ind IN Binary_Integer,
365: P_Timecard_Rec OUT NOCOPY Pa_Otc_Api.Timecard_Rec); -- 2672653
366:

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

385:
386: /*--------------------------------------------------------------------------*/
387:
388:
389: Procedure GetDetailIndex( P_Detail_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
390: X_Detail_Index OUT NOCOPY Binary_Integer);
391:
392:
393:

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

636: -- DETAIL record being looped thru.
637: --
638: -- Parameters :
639: -- IN
640: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
641: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
642: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
643: -- P_BB_Changed - Varchar2
644: -- P_BB_New - Varchar2

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

637: --
638: -- Parameters :
639: -- IN
640: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
641: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
642: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
643: -- P_BB_Changed - Varchar2
644: -- P_BB_New - Varchar2
645: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec

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

638: -- Parameters :
639: -- IN
640: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
641: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
642: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
643: -- P_BB_Changed - Varchar2
644: -- P_BB_New - Varchar2
645: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec
646: -- P_Mode - Varchar2

Line 658: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

654:
655: /*--------------------------------------------------------------------------*/
656:
657: Procedure DetermineProcessingFlags (
658: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
659: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
660: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
661: P_BB_Changed IN Varchar2,
662: P_BB_New IN Varchar2,

Line 659: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,

655: /*--------------------------------------------------------------------------*/
656:
657: Procedure DetermineProcessingFlags (
658: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
659: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
660: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
661: P_BB_Changed IN Varchar2,
662: P_BB_New IN Varchar2,
663: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,

Line 660: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,

656:
657: Procedure DetermineProcessingFlags (
658: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
659: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
660: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
661: P_BB_Changed IN Varchar2,
662: P_BB_New IN Varchar2,
663: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,
664: P_Mode IN Varchar2,

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

815: -- combinations will take place within the code before passing it to OTC. Any combo that
816: -- is not valid for the day in question will not be pulled over.
817: --
818: -- Parameters :
819: -- IN P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE
820: -- P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE
821: -- P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE
822: -- OUT
823: -- P_Attributes OUT Varchar2

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

816: -- is not valid for the day in question will not be pulled over.
817: --
818: -- Parameters :
819: -- IN P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE
820: -- P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE
821: -- P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE
822: -- OUT
823: -- P_Attributes OUT Varchar2
824: -- P_Timecard OUT Varchar2

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

817: --
818: -- Parameters :
819: -- IN P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE
820: -- P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE
821: -- P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE
822: -- OUT
823: -- P_Attributes OUT Varchar2
824: -- P_Timecard OUT Varchar2
825: -- P_Messages OUT Varchar2

Line 831: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,

827:
828: /*--------------------------------------------------------------------------*/
829:
830: Procedure GetPRMAssignTemplates(
831: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
832: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
833: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
834: P_Attributes OUT NOCOPY Varchar2,
835: P_Timecard OUT NOCOPY Varchar2,

Line 832: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,

828: /*--------------------------------------------------------------------------*/
829:
830: Procedure GetPRMAssignTemplates(
831: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
832: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
833: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
834: P_Attributes OUT NOCOPY Varchar2,
835: P_Timecard OUT NOCOPY Varchar2,
836: P_Messages OUT NOCOPY Varchar2);

Line 833: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,

829:
830: Procedure GetPRMAssignTemplates(
831: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
832: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
833: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
834: P_Attributes OUT NOCOPY Varchar2,
835: P_Timecard OUT NOCOPY Varchar2,
836: P_Messages OUT NOCOPY Varchar2);
837:

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

852: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
853: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
854: -- OUT
855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
856: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
857: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
858: -- X_Pass_Val_Flag - Varchar2
859: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE
860:

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

855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
856: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
857: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
858: -- X_Pass_Val_Flag - Varchar2
859: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE
860:
861: /*--------------------------------------------------------------------------*/
862:
863:

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

864: Procedure FindandValidateHeader(
865: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
866: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
867: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
868: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
869: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
870: X_Pass_Val_Flag OUT NOCOPY Varchar2,
871: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);
872:

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

867: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
868: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
869: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
870: X_Pass_Val_Flag OUT NOCOPY Varchar2,
871: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);
872:
873: -- =======================================================================
874: -- Start of Comments
875: -- API Name : Wf_AutoApproval_BusMsg