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 PA_EXPENDITURES_ALL

Line 13: G_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE := Null;

9: -- Used to indicate that last index point in the pl/sql old detail attribute table that was accessed.
10: G_Old_Detail_Attr_Index Binary_Integer := 0;
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.

Line 359: l_Override_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;

355: l_Txn_Rowid RowId := Null;
356: l_Txn_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := NULL;
357: l_Where_Clause Varchar2(2000);
358: l_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE;
359: l_Override_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
360: l_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
361: l_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
362: l_Insert_Rec_Flag Boolean := False;
363: l_Org_Id Hr_All_Organization_Units.Organization_Id%TYPE := NULL;

Line 1532: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE

1528: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1529: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1530: -- P_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE
1531: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1532: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
1533: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
1534:
1535: /*------------------------------------------------------------------------- */
1536:

Line 1542: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,

1538: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1539: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1540: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
1541: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
1542: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
1543: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE )
1544:
1545: Is
1546:

Line 1550: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;

1546:
1547: l_txn_rowid RowId := Null;
1548: l_txn_xface_id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := Null;
1549:
1550: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;
1551: l_Inc_By_Org_Id Hr_Organization_Units.Organization_Id%TYPE;
1552: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;
1553: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
1554: l_Task_Id Pa_Tasks.Task_Id%TYPE;

Line 1558: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

1554: l_Task_Id Pa_Tasks.Task_Id%TYPE;
1555: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
1556: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%TYPE;
1557: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;
1558: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
1559: l_Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE;
1560: l_Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE;
1561: l_Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE;
1562: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE;

Line 1575: l_Person_Type Pa_Expenditures_All.Person_Type%TYPE;

1571: l_Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE;
1572: l_Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE;
1573: l_Exp_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;
1574: -- Begin CWK changes PA.M
1575: l_Person_Type Pa_Expenditures_All.Person_Type%TYPE;
1576: l_PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE;
1577: l_PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE;
1578: l_Vendor_Id Pa_Expenditures_All.Vendor_id%TYPE;
1579: l_PO_Header_Id Number := Null;

Line 1578: l_Vendor_Id Pa_Expenditures_All.Vendor_id%TYPE;

1574: -- Begin CWK changes PA.M
1575: l_Person_Type Pa_Expenditures_All.Person_Type%TYPE;
1576: l_PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE;
1577: l_PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE;
1578: l_Vendor_Id Pa_Expenditures_All.Vendor_id%TYPE;
1579: l_PO_Header_Id Number := Null;
1580: l_Dummy_Vendor_Id Number := Null;
1581: -- End CWK changes PA.M
1582: -- 12i changes

Line 2626: -- : BB_ID to be stored table pa_expenditures_all.orig_exp_txn_reference1.

2622: -- Pre-Reqs : None
2623: -- Type : Procedure
2624: -- Function : This procedure pulls all the data from the OTL pl/sql tables into a projects
2625: -- : oriented structure for easier processing. It will also get the TIME scope
2626: -- : BB_ID to be stored table pa_expenditures_all.orig_exp_txn_reference1.
2627: --
2628: -- Parameters :
2629: -- IN
2630: -- P_New_Old_BB - Varchar2 Allowed Values:

Line 4445: l_Inc_By_Org_Id Pa_Expenditures_All.Incurred_By_Organization_Id%TYPE := Null;

4441:
4442: l_Detail_Attr_Changed Varchar2(1) := 'N';
4443: l_Logical_Rec_Changed Varchar2(1) := 'N';
4444:
4445: l_Inc_By_Org_Id Pa_Expenditures_All.Incurred_By_Organization_Id%TYPE := Null;
4446: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE:= Null;
4447: l_Ovr_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
4448:
4449: l_Bill_Flag_Meaning Fnd_Lookups.Meaning%TYPE := Null;

Line 4447: l_Ovr_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;

4443: l_Logical_Rec_Changed Varchar2(1) := 'N';
4444:
4445: l_Inc_By_Org_Id Pa_Expenditures_All.Incurred_By_Organization_Id%TYPE := Null;
4446: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE:= Null;
4447: l_Ovr_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
4448:
4449: l_Bill_Flag_Meaning Fnd_Lookups.Meaning%TYPE := Null;
4450:
4451: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;

Line 4485: l_Exp_Ending_Date_Check Pa_Expenditures_All.Expenditure_Ending_Date%TYPE := Null;

4481: /* Variables needed for running of the summary-validation and Business Message APIs */
4482: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
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:

Line 4491: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

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);
4493:
4494: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4495: INDEX BY Binary_Integer;

Line 4492: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE);

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);
4493:
4494: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4495: INDEX BY Binary_Integer;
4496:

Line 7837: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE

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: /*--------------------------------------------------------------------------*/
7841:

Line 7848: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,

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:
7852: Is

Line 8094: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

8090:
8091: Is
8092:
8093: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
8094: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
8095: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
8096:
8097: /* Stores a single record from the Building Block Table */
8098: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;

Line 8095: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;

8091: Is
8092:
8093: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
8094: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
8095: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
8096:
8097: /* Stores a single record from the Building Block Table */
8098: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;
8099:

Line 8270: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

8266:
8267: Is
8268:
8269: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
8270: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
8271: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
8272:
8273: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
8274: l_Message_Name Varchar2(30);

Line 8271: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;

8267: Is
8268:
8269: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
8270: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
8271: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
8272:
8273: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
8274: l_Message_Name Varchar2(30);
8275:

Line 8522: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE

8518: -- project friendly format.
8519: --
8520: -- Parameters :
8521: -- OUT
8522: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
8523: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
8524: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
8525:
8526: /*------------------------------------------------------------------------- */

Line 8524: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE

8520: -- Parameters :
8521: -- OUT
8522: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
8523: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
8524: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
8525:
8526: /*------------------------------------------------------------------------- */
8527:
8528: Procedure CreateProjTimecardTable(

Line 8529: X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,

8525:
8526: /*------------------------------------------------------------------------- */
8527:
8528: Procedure CreateProjTimecardTable(
8529: X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
8530: X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table, --2672653
8531: X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE)
8532:
8533: Is

Line 8531: X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE)

8527:
8528: Procedure CreateProjTimecardTable(
8529: X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
8530: X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table, --2672653
8531: X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE)
8532:
8533: Is
8534:
8535: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;

Line 9491: X_Person_Type Pa_Expenditures_All.Person_Type%TYPE := Null;

9487: Function GetPersonType ( P_Person_Id IN Number, P_Ei_Date IN Date) Return Varchar2
9488:
9489: Is
9490:
9491: X_Person_Type Pa_Expenditures_All.Person_Type%TYPE := Null;
9492:
9493: Begin
9494:
9495: Select