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 258: -- P_Time_Building_Block_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

254: -- P_Message_Name - Fnd_New_Messages.Message_Name%TYPE
255: -- P_Message_Level - Varchar2
256: -- P_Message_Field - Varchar2
257: -- P_Msg_Tokens - Pa_Otc_Api.Messages_Tokens
258: -- P_Time_Building_Block_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
259: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
260: -- P_Message_App - Varchar2 Default 'PA'
261: --
262: -- OUT

Line 274: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

270: P_Message_Name IN Fnd_New_Messages.Message_Name%TYPE,
271: P_Message_Level IN Varchar2,
272: P_Message_Field IN Varchar2,
273: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,
274: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
275: P_Time_Attribute_Id IN Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
276: P_Message_App IN Varchar2 )
277:
278: Is

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

2689: -- IN
2690: -- P_New_Old_BB - Varchar2 Allowed Values:
2691: -- Import values: 'OLD' 'NEW'
2692: -- Validation value:
2693: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
2694: -- P_Detail_Index - Binary_Integer
2695: -- P_Old_Detl_Ind - Binary_Integer
2696: -- OUT
2697: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec

Line 2703: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

2699: /*--------------------------------------------------------------------------*/
2700:
2701: Procedure PopulateProjRec(
2702: P_New_Old_BB IN Varchar2,
2703: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
2704: P_Detail_Index IN Binary_Integer,
2705: P_Old_Detl_Ind IN Binary_Integer,
2706: P_Timecard_Rec OUT NOCOPY Pa_Otc_Api.Timecard_Rec) IS -- 2672653
2707:

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

4202: -- Building_Block_Id that is passed in to it.
4203: --
4204: -- Parameters :
4205: -- IN
4206: -- P_Detail_BB_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
4207: -- OUT
4208: -- X_Detail_Index - Binary_Integer
4209:
4210: /*--------------------------------------------------------------------------*/

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

4209:
4210: /*--------------------------------------------------------------------------*/
4211:
4212:
4213: Procedure GetDetailIndex( P_Detail_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
4214: X_Detail_Index OUT NOCOPY Binary_Integer)
4215:
4216: Is
4217:

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

4784: l_Timecard_Table_Week Pa_Otc_Api.Timecard_Table;
4785: l_Weeks_To_Process Binary_Integer := 0;
4786: l_Exp_Ending_Date_Check Pa_Expenditures_All.Expenditure_Ending_Date%TYPE := Null;
4787: l_Timecard_Table_Index Binary_Integer := 0;
4788: l_Time_Building_Block_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4789: l_Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE := Null;
4790:
4791: TYPE Exp_End_Date_Rec IS Record (
4792: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

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

4785: l_Weeks_To_Process Binary_Integer := 0;
4786: l_Exp_Ending_Date_Check Pa_Expenditures_All.Expenditure_Ending_Date%TYPE := Null;
4787: l_Timecard_Table_Index Binary_Integer := 0;
4788: l_Time_Building_Block_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4789: l_Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE := Null;
4790:
4791: TYPE Exp_End_Date_Rec IS Record (
4792: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
4793: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE);

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

4794:
4795: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4796: INDEX BY Binary_Integer;
4797:
4798: l_Detail_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4799: l_Detail_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
4800:
4801: l_Exp_End_Date_Tab Exp_End_Date_Tab;
4802:

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

4795: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4796: INDEX BY Binary_Integer;
4797:
4798: l_Detail_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
4799: l_Detail_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
4800:
4801: l_Exp_End_Date_Tab Exp_End_Date_Tab;
4802:
4803: /* Stores a single record from the Building Block Table */

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

6681: -- DETAIL record being looped thru.
6682: --
6683: -- Parameters :
6684: -- IN
6685: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
6686: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
6687: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
6688: -- P_BB_Changed - VARCHAR2
6689: -- P_BB_New - VARCHAR2

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

6682: --
6683: -- Parameters :
6684: -- IN
6685: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
6686: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
6687: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
6688: -- P_BB_Changed - VARCHAR2
6689: -- P_BB_New - VARCHAR2
6690: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec

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

6683: -- Parameters :
6684: -- IN
6685: -- P_BB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
6686: -- P_BB_Ovn - Hxc_Time_Building_Blocks.Object_Version_Number%TYPE
6687: -- P_BB_Date_To - Hxc_Time_Building_Blocks.Date_To%TYPE
6688: -- P_BB_Changed - VARCHAR2
6689: -- P_BB_New - VARCHAR2
6690: -- P_Proj_Attribute_Rec - Pa_Otc_Api.Project_Attribution_Rec
6691: -- P_Mode - VARCHAR2(10)

Line 6703: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,

6699:
6700: /*--------------------------------------------------------------------------*/
6701:
6702: Procedure DetermineProcessingFlags (
6703: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
6704: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
6705: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
6706: P_BB_Changed IN Varchar2,
6707: P_BB_New IN Varchar2,

Line 6704: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,

6700: /*--------------------------------------------------------------------------*/
6701:
6702: Procedure DetermineProcessingFlags (
6703: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
6704: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
6705: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
6706: P_BB_Changed IN Varchar2,
6707: P_BB_New IN Varchar2,
6708: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,

Line 6705: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,

6701:
6702: Procedure DetermineProcessingFlags (
6703: P_BB_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
6704: P_BB_Ovn IN Hxc_Time_Building_Blocks.Object_Version_Number%TYPE,
6705: P_BB_Date_To IN Hxc_Time_Building_Blocks.Date_To%TYPE,
6706: P_BB_Changed IN Varchar2,
6707: P_BB_New IN Varchar2,
6708: P_Proj_Attribute_Rec IN Pa_Otc_Api.Project_Attribution_Rec,
6709: P_Mode IN Varchar2,

Line 7030: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE;

7026: Procedure AdjustAllowedToOTCItem(
7027: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
7028: X_flag OUT NOCOPY BOOLEAN) Is
7029:
7030: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE;
7031: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE;
7032: l_Changed_Flag Boolean := False;
7033:
7034: Begin

Line 7031: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE;

7027: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
7028: X_flag OUT NOCOPY BOOLEAN) Is
7029:
7030: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE;
7031: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE;
7032: l_Changed_Flag Boolean := False;
7033:
7034: Begin
7035:

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

8200: -- combinations will take place within the code before passing it to OTL. Any combo that
8201: -- is not valid for the day in question will not be pulled over.
8202: --
8203: -- Parameters :
8204: -- IN P_Resource_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
8205: -- P_Start_Date - Hxc_Time_Building_Blocks.Start_Time%TYPE
8206: -- P_Stop_Date - Hxc_Time_Building_Blocks.Stop_Time%TYPE
8207: -- OUT
8208: -- P_Attributes - Varchar2

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

8201: -- is not valid for the day in question will not be pulled over.
8202: --
8203: -- Parameters :
8204: -- IN P_Resource_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
8205: -- P_Start_Date - Hxc_Time_Building_Blocks.Start_Time%TYPE
8206: -- P_Stop_Date - Hxc_Time_Building_Blocks.Stop_Time%TYPE
8207: -- OUT
8208: -- P_Attributes - Varchar2
8209: -- P_Timecard - Varchar2

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

8202: --
8203: -- Parameters :
8204: -- IN P_Resource_Id - Hxc_Time_Building_Blocks.Resource_Id%TYPE
8205: -- P_Start_Date - Hxc_Time_Building_Blocks.Start_Time%TYPE
8206: -- P_Stop_Date - Hxc_Time_Building_Blocks.Stop_Time%TYPE
8207: -- OUT
8208: -- P_Attributes - Varchar2
8209: -- P_Timecard - Varchar2
8210: -- P_Messages - Varchar2

Line 8216: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,

8212:
8213: /*--------------------------------------------------------------------------*/
8214:
8215: Procedure GetPRMAssignTemplates(
8216: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
8217: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
8218: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
8219: P_Attributes OUT NOCOPY Varchar2,
8220: P_Timecard OUT NOCOPY Varchar2,

Line 8217: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,

8213: /*--------------------------------------------------------------------------*/
8214:
8215: Procedure GetPRMAssignTemplates(
8216: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
8217: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
8218: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
8219: P_Attributes OUT NOCOPY Varchar2,
8220: P_Timecard OUT NOCOPY Varchar2,
8221: P_Messages OUT NOCOPY Varchar2)

Line 8218: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,

8214:
8215: Procedure GetPRMAssignTemplates(
8216: P_Resource_Id IN Hxc_Time_Building_Blocks.Resource_Id%TYPE,
8217: P_Start_Date IN Hxc_Time_Building_Blocks.Start_Time%TYPE,
8218: P_Stop_Date IN Hxc_Time_Building_Blocks.Stop_Time%TYPE,
8219: P_Attributes OUT NOCOPY Varchar2,
8220: P_Timecard OUT NOCOPY Varchar2,
8221: P_Messages OUT NOCOPY Varchar2)
8222:

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

8715: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
8716: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
8717: -- OUT
8718: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
8719: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
8720: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
8721: -- X_Timecard_Ending_Date - Date
8722:
8723: /*--------------------------------------------------------------------------*/

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

8726: Procedure FindandValidateHeader(
8727: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
8728: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
8729: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
8730: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
8731: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
8732: X_Pass_Val_Flag OUT NOCOPY Varchar2,
8733: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE)
8734:

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

8729: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
8730: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
8731: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
8732: X_Pass_Val_Flag OUT NOCOPY Varchar2,
8733: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE)
8734:
8735: Is
8736:
8737: l_Error_Code Varchar2(30) := Null;

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

9641: (P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Return Varchar2
9642:
9643: Is
9644:
9645: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
9646: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
9647:
9648: Begin
9649:

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

9642:
9643: Is
9644:
9645: l_BB_Id Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE := Null;
9646: l_BB_Ovn Hxc_Time_Building_Blocks.Object_Version_Number%TYPE := Null;
9647:
9648: Begin
9649:
9650: -- Check if the original transaction reference is null or not.