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 377: l_Override_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;

373: l_Txn_Rowid RowId := Null;
374: l_Txn_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := NULL;
375: l_Where_Clause Varchar2(2000);
376: l_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE;
377: l_Override_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
378: l_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
379: l_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
380: l_Insert_Rec_Flag Boolean := False;
381: l_Org_Id Hr_All_Organization_Units.Organization_Id%TYPE := NULL;

Line 1562: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE

1558: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1559: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1560: -- P_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE
1561: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1562: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
1563: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
1564:
1565: /*------------------------------------------------------------------------- */
1566:

Line 1572: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,

1568: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1569: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1570: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
1571: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
1572: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
1573: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE )
1574:
1575: Is
1576:

Line 1580: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;

1576:
1577: l_txn_rowid RowId := Null;
1578: l_txn_xface_id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := Null;
1579:
1580: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;
1581: l_Inc_By_Org_Id Hr_Organization_Units.Organization_Id%TYPE;
1582: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;
1583: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
1584: l_Task_Id Pa_Tasks.Task_Id%TYPE;

Line 1588: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

1584: l_Task_Id Pa_Tasks.Task_Id%TYPE;
1585: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
1586: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%TYPE;
1587: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;
1588: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
1589: l_Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE;
1590: l_Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE;
1591: l_Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE;
1592: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE;

Line 1605: l_Person_Type Pa_Expenditures_All.Person_Type%TYPE;

1601: l_Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE;
1602: l_Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE;
1603: l_Exp_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;
1604: -- Begin CWK changes PA.M
1605: l_Person_Type Pa_Expenditures_All.Person_Type%TYPE;
1606: l_PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE;
1607: l_PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE;
1608: l_Vendor_Id Pa_Expenditures_All.Vendor_id%TYPE;
1609: l_PO_Header_Id Number := Null;

Line 1608: l_Vendor_Id Pa_Expenditures_All.Vendor_id%TYPE;

1604: -- Begin CWK changes PA.M
1605: l_Person_Type Pa_Expenditures_All.Person_Type%TYPE;
1606: l_PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE;
1607: l_PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE;
1608: l_Vendor_Id Pa_Expenditures_All.Vendor_id%TYPE;
1609: l_PO_Header_Id Number := Null;
1610: l_Dummy_Vendor_Id Number := Null;
1611: -- End CWK changes PA.M
1612: -- 12i changes

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

2682: -- Pre-Reqs : None
2683: -- Type : Procedure
2684: -- Function : This procedure pulls all the data from the OTL pl/sql tables into a projects
2685: -- : oriented structure for easier processing. It will also get the TIME scope
2686: -- : BB_ID to be stored table pa_expenditures_all.orig_exp_txn_reference1.
2687: --
2688: -- Parameters :
2689: -- IN
2690: -- P_New_Old_BB - Varchar2 Allowed Values:

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

4742:
4743: l_Detail_Attr_Changed Varchar2(1) := 'N';
4744: l_Logical_Rec_Changed Varchar2(1) := 'N';
4745:
4746: l_Inc_By_Org_Id Pa_Expenditures_All.Incurred_By_Organization_Id%TYPE := Null;
4747: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE:= Null;
4748: l_Ovr_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
4749:
4750: l_Bill_Flag_Meaning Fnd_Lookups.Meaning%TYPE := Null;

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

4744: l_Logical_Rec_Changed Varchar2(1) := 'N';
4745:
4746: l_Inc_By_Org_Id Pa_Expenditures_All.Incurred_By_Organization_Id%TYPE := Null;
4747: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE:= Null;
4748: l_Ovr_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
4749:
4750: l_Bill_Flag_Meaning Fnd_Lookups.Meaning%TYPE := Null;
4751:
4752: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;

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

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

Line 4792: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

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);
4794:
4795: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4796: INDEX BY Binary_Integer;

Line 4793: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE);

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);
4794:
4795: TYPE Exp_End_Date_Tab IS Table OF Exp_End_Date_Rec
4796: INDEX BY Binary_Integer;
4797:

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

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

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

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

Line 9003: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

8999:
9000: Is
9001:
9002: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
9003: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
9004: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
9005:
9006: /* Stores a single record from the Building Block Table */
9007: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;

Line 9004: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;

9000: Is
9001:
9002: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
9003: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
9004: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
9005:
9006: /* Stores a single record from the Building Block Table */
9007: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;
9008:

Line 9179: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

9175:
9176: Is
9177:
9178: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
9179: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
9180: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
9181:
9182: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
9183: l_Message_Name Varchar2(30);

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

9176: Is
9177:
9178: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
9179: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
9180: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
9181:
9182: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
9183: l_Message_Name Varchar2(30);
9184:

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

9427: -- project friendly format.
9428: --
9429: -- Parameters :
9430: -- OUT
9431: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
9432: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
9433: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
9434:
9435: /*------------------------------------------------------------------------- */

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

9429: -- Parameters :
9430: -- OUT
9431: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
9432: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
9433: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
9434:
9435: /*------------------------------------------------------------------------- */
9436:
9437: Procedure CreateProjTimecardTable(

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

9434:
9435: /*------------------------------------------------------------------------- */
9436:
9437: Procedure CreateProjTimecardTable(
9438: X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
9439: X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table, --2672653
9440: X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE)
9441:
9442: Is

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

9436:
9437: Procedure CreateProjTimecardTable(
9438: X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
9439: X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table, --2672653
9440: X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE)
9441:
9442: Is
9443:
9444: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;

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

10426: Function GetPersonType ( P_Person_Id IN Number, P_Ei_Date IN Date) Return Varchar2
10427:
10428: Is
10429:
10430: X_Person_Type Pa_Expenditures_All.Person_Type%TYPE := Null;
10431:
10432: Begin
10433:
10434: Select