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 15: G_Time_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;

11:
12: -- Stores the Timecard Scope BB_ID and BB_OVN and is used to populate in
13: G_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE := Null;
14:
15: G_Time_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
16:
17: -- Used to indicate what was actually happening when unexpected error occurs.
18: G_Stage Varchar2(2000);
19:

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

236: -- P_Message_Name - Fnd_New_Messages.Message_Name%TYPE
237: -- P_Message_Level - Varchar2
238: -- P_Message_Field - Varchar2
239: -- P_Msg_Tokens - Pa_Otc_Api.Messages_Tokens
240: -- P_Time_Building_Block_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
241: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
242: -- P_Message_App - Varchar2 Default 'PA'
243: --
244: -- OUT

Line 256: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

252: P_Message_Name IN Fnd_New_Messages.Message_Name%TYPE,
253: P_Message_Level IN Varchar2,
254: P_Message_Field IN Varchar2,
255: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,
256: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
257: P_Time_Attribute_Id IN Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
258: P_Message_App IN Varchar2 )
259:
260: Is

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

2629: -- IN
2630: -- P_New_Old_BB - Varchar2 Allowed Values:
2631: -- Import values: 'OLD' 'NEW'
2632: -- Validation value:
2633: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
2634: -- P_Detail_Index - Binary_Integer
2635: -- P_Old_Detl_Ind - Binary_Integer
2636: -- OUT
2637: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec

Line 2643: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

2639: /*--------------------------------------------------------------------------*/
2640:
2641: Procedure PopulateProjRec(
2642: P_New_Old_BB IN Varchar2,
2643: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
2644: P_Detail_Index IN Binary_Integer,
2645: P_Old_Detl_Ind IN Binary_Integer,
2646: P_Timecard_Rec OUT NOCOPY Pa_Otc_Api.Timecard_Rec) IS -- 2672653
2647:

Line 3932: -- P_Detail_BB_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE

3928: -- Building_Block_Id that is passed in to it.
3929: --
3930: -- Parameters :
3931: -- IN
3932: -- P_Detail_BB_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
3933: -- OUT
3934: -- X_Detail_Index - Binary_Integer
3935:
3936: /*--------------------------------------------------------------------------*/

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

3935:
3936: /*--------------------------------------------------------------------------*/
3937:
3938:
3939: Procedure GetDetailIndex( P_Detail_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
3940: X_Detail_Index OUT NOCOPY Binary_Integer)
3941:
3942: Is
3943:

Line 4487: l_Time_Building_Block_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;

4483: l_Timecard_Table_Week Pa_Otc_Api.Timecard_Table;
4484: l_Weeks_To_Process Binary_Integer := 0;
4485: l_Exp_Ending_Date_Check Pa_Expenditures_All.Expenditure_Ending_Date%TYPE := Null;
4486: l_Timecard_Table_Index Binary_Integer := 0;
4487: l_Time_Building_Block_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4488: l_Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE := Null;
4489:
4490: TYPE Exp_End_Date_Rec IS Record (
4491: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

Line 4488: l_Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE := Null;

4484: l_Weeks_To_Process Binary_Integer := 0;
4485: l_Exp_Ending_Date_Check Pa_Expenditures_All.Expenditure_Ending_Date%TYPE := Null;
4486: l_Timecard_Table_Index Binary_Integer := 0;
4487: l_Time_Building_Block_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4488: l_Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE := Null;
4489:
4490: TYPE Exp_End_Date_Rec IS Record (
4491: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
4492: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE);

Line 4497: l_Detail_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;

4493:
4494: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4495: INDEX BY Binary_Integer;
4496:
4497: l_Detail_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4498: l_Detail_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
4499:
4500: l_Exp_End_Date_Tab Exp_End_Date_Tab;
4501:

Line 4498: l_Detail_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;

4494: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4495: INDEX BY Binary_Integer;
4496:
4497: l_Detail_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4498: l_Detail_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
4499:
4500: l_Exp_End_Date_Tab Exp_End_Date_Tab;
4501:
4502: /* Stores a single record from the Building Block Table */

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

5978: -- DETAIL record being looped thru.
5979: --
5980: -- Parameters :
5981: -- IN
5982: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
5983: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
5984: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
5985: -- P_BB_Changed - VARCHAR2
5986: -- P_BB_New - VARCHAR2

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

5979: --
5980: -- Parameters :
5981: -- IN
5982: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
5983: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
5984: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
5985: -- P_BB_Changed - VARCHAR2
5986: -- P_BB_New - VARCHAR2
5987: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec

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

5980: -- Parameters :
5981: -- IN
5982: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
5983: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
5984: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
5985: -- P_BB_Changed - VARCHAR2
5986: -- P_BB_New - VARCHAR2
5987: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec
5988: -- P_Mode - VARCHAR2(10)

Line 6000: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

5996:
5997: /*--------------------------------------------------------------------------*/
5998:
5999: Procedure DetermineProcessingFlags (
6000: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
6001: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
6002: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
6003: P_BB_Changed IN Varchar2,
6004: P_BB_New IN Varchar2,

Line 6001: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,

5997: /*--------------------------------------------------------------------------*/
5998:
5999: Procedure DetermineProcessingFlags (
6000: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
6001: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
6002: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
6003: P_BB_Changed IN Varchar2,
6004: P_BB_New IN Varchar2,
6005: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,

Line 6002: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,

5998:
5999: Procedure DetermineProcessingFlags (
6000: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
6001: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
6002: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
6003: P_BB_Changed IN Varchar2,
6004: P_BB_New IN Varchar2,
6005: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,
6006: P_Mode IN Varchar2,

Line 6286: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE;

6282: Procedure AdjustAllowedToOTCItem(
6283: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
6284: X_flag OUT NOCOPY BOOLEAN) Is
6285:
6286: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE;
6287: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE;
6288: l_Changed_Flag Boolean := False;
6289:
6290: Begin

Line 6287: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE;

6283: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
6284: X_flag OUT NOCOPY BOOLEAN) Is
6285:
6286: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE;
6287: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE;
6288: l_Changed_Flag Boolean := False;
6289:
6290: Begin
6291:

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

7317: -- combinations will take place within the code before passing it to OTL. Any combo that
7318: -- is not valid for the day in question will not be pulled over.
7319: --
7320: -- Parameters :
7321: -- IN P_Resource_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
7322: -- P_Start_Date - Hxc_Time_Building_Blocks.Start_Time%TYPE
7323: -- P_Stop_Date - Hxc_Time_Building_Blocks.Stop_Time%TYPE
7324: -- OUT
7325: -- P_Attributes - Varchar2

Line 7322: -- P_Start_Date - Hxc_Time_Building_Blocks.Start_Time%TYPE

7318: -- is not valid for the day in question will not be pulled over.
7319: --
7320: -- Parameters :
7321: -- IN P_Resource_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
7322: -- P_Start_Date - Hxc_Time_Building_Blocks.Start_Time%TYPE
7323: -- P_Stop_Date - Hxc_Time_Building_Blocks.Stop_Time%TYPE
7324: -- OUT
7325: -- P_Attributes - Varchar2
7326: -- P_Timecard - Varchar2

Line 7323: -- P_Stop_Date - Hxc_Time_Building_Blocks.Stop_Time%TYPE

7319: --
7320: -- Parameters :
7321: -- IN P_Resource_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
7322: -- P_Start_Date - Hxc_Time_Building_Blocks.Start_Time%TYPE
7323: -- P_Stop_Date - Hxc_Time_Building_Blocks.Stop_Time%TYPE
7324: -- OUT
7325: -- P_Attributes - Varchar2
7326: -- P_Timecard - Varchar2
7327: -- P_Messages - Varchar2

Line 7333: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,

7329:
7330: /*--------------------------------------------------------------------------*/
7331:
7332: Procedure GetPRMAssignTemplates(
7333: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
7334: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
7335: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
7336: P_Attributes OUT NOCOPY Varchar2,
7337: P_Timecard OUT NOCOPY Varchar2,

Line 7334: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,

7330: /*--------------------------------------------------------------------------*/
7331:
7332: Procedure GetPRMAssignTemplates(
7333: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
7334: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
7335: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
7336: P_Attributes OUT NOCOPY Varchar2,
7337: P_Timecard OUT NOCOPY Varchar2,
7338: P_Messages OUT NOCOPY Varchar2)

Line 7335: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,

7331:
7332: Procedure GetPRMAssignTemplates(
7333: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
7334: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
7335: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
7336: P_Attributes OUT NOCOPY Varchar2,
7337: P_Timecard OUT NOCOPY Varchar2,
7338: P_Messages OUT NOCOPY Varchar2)
7339:

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

7832: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
7833: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7834: -- OUT
7835: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7836: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
7837: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
7838: -- X_Timecard_Ending_Date - Date
7839:
7840: /*--------------------------------------------------------------------------*/

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

7843: Procedure FindandValidateHeader(
7844: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
7845: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
7846: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
7847: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
7848: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
7849: X_Pass_Val_Flag OUT NOCOPY Varchar2,
7850: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE)
7851:

Line 7850: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE)

7846: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
7847: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
7848: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
7849: X_Pass_Val_Flag OUT NOCOPY Varchar2,
7850: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE)
7851:
7852: Is
7853:
7854: l_Error_Code Varchar2(30) := Null;

Line 8730: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;

8726: (P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Return Varchar2
8727:
8728: Is
8729:
8730: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
8731: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
8732:
8733: Begin
8734:

Line 8731: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;

8727:
8728: Is
8729:
8730: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
8731: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
8732:
8733: Begin
8734:
8735: -- Check if the original transaction reference is null or not.