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_EXPENDITURE_ITEMS_ALL

Line 360: l_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

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;
364: l_Direct_Update_Flag Boolean := False;

Line 361: l_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

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;
364: l_Direct_Update_Flag Boolean := False;
365: l_Comment_Or_Dff Varchar2(1);

Line 783: -- pa_expenditure_comments and/or pa_expenditure_items_all.

779: Else
780:
781: -- Need to find out what has changed to determine whether or not need to
782: -- insert record into pa_transaction_interface or update tables
783: -- pa_expenditure_comments and/or pa_expenditure_items_all.
784: G_Stage := 'Call Determine Direct Update 3.';
785: If G_Debug_Mode = 'Y' Then
786: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
787: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 1528: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

1524: -- quantity
1525: --
1526: -- Parameters :
1527: -- IN
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

Line 1529: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

1525: --
1526: -- Parameters :
1527: -- IN
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

Line 1531: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE

1527: -- IN
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: /*------------------------------------------------------------------------- */

Line 1538: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1534:
1535: /*------------------------------------------------------------------------- */
1536:
1537: Procedure Build_Reverse_Item(
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,

Line 1539: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1535: /*------------------------------------------------------------------------- */
1536:
1537: Procedure Build_Reverse_Item(
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 )

Line 1541: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,

1537: Procedure Build_Reverse_Item(
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

Line 1552: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;

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;
1555: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
1556: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%TYPE;

Line 1556: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%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;
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;

Line 1557: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;

1553: l_Proj_Id Pa_Projects_All.Project_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;

Line 1559: l_Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%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;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;

Line 1560: l_Attribute1 Pa_Expenditure_Items_All.Attribute1%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;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;

Line 1561: l_Attribute2 Pa_Expenditure_Items_All.Attribute2%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;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;

Line 1562: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%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;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;

Line 1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%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;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;

Line 1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%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;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;

Line 1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;

1561: l_Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE;
1562: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;

Line 1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;

1562: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE;
1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE;

Line 1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;

1563: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE;
1571: l_Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE;

Line 1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;

1564: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

Line 1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;

1565: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

Line 1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE;

1566: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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

Line 1571: l_Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE;

1567: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

Line 1572: l_Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE;

1568: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1569: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1570: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

Line 1576: l_PO_Line_Id Pa_Expenditure_Items_All.PO_Line_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;
1580: l_Dummy_Vendor_Id Number := Null;

Line 1577: l_PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%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;
1580: l_Dummy_Vendor_Id Number := Null;
1581: -- End CWK changes PA.M

Line 1874: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

1870: -- D for Dff
1871: -- B for Both
1872: --
1873: -- Parameters :
1874: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1875: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1876: -- P_Comment_Or_Dff - Varchar2(1)
1877: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
1878: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE

Line 1875: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

1871: -- B for Both
1872: --
1873: -- Parameters :
1874: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1875: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1876: -- P_Comment_Or_Dff - Varchar2(1)
1877: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
1878: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1879: --

Line 1878: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE

1874: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1875: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1876: -- P_Comment_Or_Dff - Varchar2(1)
1877: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
1878: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1879: --
1880: -- OUT NONE
1881: --
1882:

Line 1886: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1882:
1883: /*--------------------------------------------------------------------------*/
1884:
1885: Procedure UpdateChangedOrigTxn(
1886: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1887: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1888: P_Comment_Or_Dff IN Varchar2,
1889: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
1890: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)

Line 1887: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1883: /*--------------------------------------------------------------------------*/
1884:
1885: Procedure UpdateChangedOrigTxn(
1886: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1887: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1888: P_Comment_Or_Dff IN Varchar2,
1889: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
1890: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)
1891:

Line 1890: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)

1886: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1887: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1888: P_Comment_Or_Dff IN Varchar2,
1889: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
1890: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)
1891:
1892: Is
1893:
1894: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE := Null;

Line 1894: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE := Null;

1890: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)
1891:
1892: Is
1893:
1894: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE := Null;
1895: l_RowId RowId;
1896: l_Last_Update_Login Pa_Expenditure_Items_All.Last_Update_Login%TYPE := to_Number(Fnd_Profile.Value('LOGIN_ID'));
1897: --Added for bug 4105561
1898: x_request_id NUMBER(15);

Line 1896: l_Last_Update_Login Pa_Expenditure_Items_All.Last_Update_Login%TYPE := to_Number(Fnd_Profile.Value('LOGIN_ID'));

1892: Is
1893:
1894: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE := Null;
1895: l_RowId RowId;
1896: l_Last_Update_Login Pa_Expenditure_Items_All.Last_Update_Login%TYPE := to_Number(Fnd_Profile.Value('LOGIN_ID'));
1897: --Added for bug 4105561
1898: x_request_id NUMBER(15);
1899: x_program_application_id NUMBER(15);
1900: x_program_id NUMBER(15);

Line 1934: Pa_Expenditure_Items_All

1930: Into
1931: l_RowId,
1932: l_Exp_Item_Id
1933: From
1934: Pa_Expenditure_Items_All
1935: Where
1936: Transaction_Source = 'ORACLE TIME AND LABOR'
1937: And Orig_Transaction_Reference = P_Old_Orig_Txn_Ref
1938: And Net_Zero_Adjustment_Flag = 'N'; -- Bug 3480159

Line 1963: Update Pa_Expenditure_Items_All

1959: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1960: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1961: End If;
1962:
1963: Update Pa_Expenditure_Items_All
1964: Set Orig_Transaction_Reference = P_New_Orig_Txn_Ref,
1965: Last_Updated_By = P_User_Id,
1966: Last_Update_Date = SysDate,
1967: Last_Update_Login = l_Last_Update_Login,

Line 2055: Update Pa_Expenditure_Items_All

2051: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2052: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2053: End If;
2054:
2055: Update Pa_Expenditure_Items_All
2056: Set Orig_Transaction_Reference = P_New_Orig_Txn_Ref,
2057: Attribute_category = P_Timecard_Rec.Attribute_Category,
2058: Attribute1 = P_Timecard_Rec.Attribute1,
2059: Attribute2 = P_Timecard_Rec.Attribute2,

Line 2158: Update Pa_Expenditure_Items_All

2154: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2155: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2156: End If;
2157:
2158: Update Pa_Expenditure_Items_All
2159: Set Orig_Transaction_Reference = P_New_Orig_Txn_Ref,
2160: Attribute_category = P_Timecard_Rec.Attribute_Category,
2161: Attribute1 = P_Timecard_Rec.Attribute1,
2162: Attribute2 = P_Timecard_Rec.Attribute2,

Line 4446: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE:= Null;

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;
4450:

Line 5823: -- P_Exp_Item_date - Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE

5819: -- Parameters :
5820: -- IN
5821: -- P_System_Linkage - Pa_System_Linkages.Function%TYPE
5822: -- P_Expenditure_Type - Pa_Expenditure_Types.Expenditure_Type%TYPE
5823: -- P_Exp_Item_date - Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE
5824: -- OUT
5825: -- X_Error_Code - Varchar2
5826: -- X_Error_Type - Varchar2
5827:

Line 5833: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

5829:
5830: Procedure Validate_Exp_Type_Exists(
5831: P_System_Linkage IN Pa_System_Linkages.Function%TYPE,
5832: P_Expenditure_Type IN Pa_Expenditure_Types.Expenditure_Type%TYPE,
5833: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
5834: X_Error_Type OUT NOCOPY Varchar2,
5835: X_Error_Code OUT NOCOPY Varchar2) Is
5836:
5837: Cursor Cur_Etype_Slink (P_EI_Date IN Date,

Line 6015: l_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;

6011: X_Adj_in_Projects_Flag OUT NOCOPY Varchar2)
6012:
6013: Is
6014:
6015: l_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;
6016: l_Net_Zero_flag Pa_Expenditure_Items_All.Net_Zero_Adjustment_Flag%TYPE := 'N';
6017: l_Max_Version Number := 0;
6018: l_RowId RowId;
6019: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;

Line 6016: l_Net_Zero_flag Pa_Expenditure_Items_All.Net_Zero_Adjustment_Flag%TYPE := 'N';

6012:
6013: Is
6014:
6015: l_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;
6016: l_Net_Zero_flag Pa_Expenditure_Items_All.Net_Zero_Adjustment_Flag%TYPE := 'N';
6017: l_Max_Version Number := 0;
6018: l_RowId RowId;
6019: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;
6020: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;

Line 6019: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;

6015: l_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;
6016: l_Net_Zero_flag Pa_Expenditure_Items_All.Net_Zero_Adjustment_Flag%TYPE := 'N';
6017: l_Max_Version Number := 0;
6018: l_RowId RowId;
6019: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;
6020: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;
6021: l_Ovn_Check_Value Number := 0;
6022:
6023: Cursor AdjustmentRecords (P_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Is

Line 6023: Cursor AdjustmentRecords (P_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Is

6019: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;
6020: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;
6021: l_Ovn_Check_Value Number := 0;
6022:
6023: Cursor AdjustmentRecords (P_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Is
6024: Select
6025: RowId,
6026: Expenditure_Item_Id,
6027: Net_Zero_Adjustment_Flag,

Line 6030: Pa_Expenditure_Items_All

6026: Expenditure_Item_Id,
6027: Net_Zero_Adjustment_Flag,
6028: Orig_Transaction_Reference
6029: From
6030: Pa_Expenditure_Items_All
6031: Where
6032: Transaction_Source = 'ORACLE TIME AND LABOR'
6033: And Orig_Transaction_Reference like l_orig_trx_ref
6034: Order By Orig_Transaction_Reference;

Line 6040: Pa_Expenditure_Items_All ei,

6036: Cursor EiIsChanged ( P_RowId IN RowId ) Is
6037: Select
6038: 'Y'
6039: From
6040: Pa_Expenditure_Items_All ei,
6041: Pa_Expenditure_Comments c
6042: Where
6043: ei.Expenditure_Item_Id = c.Expenditure_Item_Id(+)
6044: And (ei.Task_Id <> nvl(P_Proj_Attribute_Rec.Task_Id,-99)

Line 6065: l_Orig_Transaction_Reference Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

6061: Or nvl(ei.PO_Price_Type,'-99') <> nvl(P_Proj_Attribute_Rec.PO_Price_Type,'-99') )
6062: And ei.RowId = P_RowId;
6063:
6064: AdjRec AdjustmentRecords%RowType;
6065: l_Orig_Transaction_Reference Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
6066: l_Ei_Changed_Flag Varchar2(1) := 'N';
6067:
6068: E_Exception Exception;
6069:

Line 6277: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

6273: -- has been imported into Projects can adjusted in Projects by calling the
6274: -- API Hxc_Generic_Retrieval_Utils.Time_Bld_Blk_Changed.
6275: --
6276: -- Parameters :
6277: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
6278: -- OUT X_Flag - Varchar2(1)
6279: --
6280: /*--------------------------------------------------------------------------*/
6281:

Line 6283: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

6279: --
6280: /*--------------------------------------------------------------------------*/
6281:
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;

Line 8668: -- P_Orig_Transaction_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

8664: -- projects does not recognize and doesn't want to, thus the ovn changes in OTL.)
8665: --
8666: -- Parameters :
8667: -- IN
8668: -- P_Orig_Transaction_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
8669:
8670: /*------------------------------------------------------------------------- */
8671:
8672: Function OrigTrxRefValueExists

Line 8673: ( P_Orig_Transaction_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Return Boolean

8669:
8670: /*------------------------------------------------------------------------- */
8671:
8672: Function OrigTrxRefValueExists
8673: ( P_Orig_Transaction_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Return Boolean
8674:
8675: Is
8676:
8677: l_Exists_Flag VARCHAR2(1) := 'N';

Line 8686: Pa_Expenditure_Items_All

8682: 'Y'
8683: Into
8684: l_Exists_Flag
8685: From
8686: Pa_Expenditure_Items_All
8687: Where
8688: Transaction_Source = 'ORACLE TIME AND LABOR'
8689: And Orig_Transaction_Reference = P_Orig_Transaction_Reference;
8690:

Line 8721: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

8717: -- has been imported into Projects can adjusted in Projects by calling the
8718: -- API Hxc_Generic_Retrieval_Utils.Time_Bld_Blk_Changed.
8719: --
8720: -- Parameters :
8721: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
8722: --
8723: /*--------------------------------------------------------------------------*/
8724:
8725: Function ChkAdjustAllowedToOTCItem

Line 8726: (P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Return Varchar2

8722: --
8723: /*--------------------------------------------------------------------------*/
8724:
8725: Function ChkAdjustAllowedToOTCItem
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;

Line 8954: -- X_OrigTrxRef - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

8950: -- Parameters :
8951: -- IN
8952: -- P_Building_Block_Id - Number
8953: -- OUT
8954: -- X_OrigTrxRef - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
8955: -- X_Status - Varchar2
8956: /*--------------------------------------------------------------------------*/
8957:
8958: Procedure GetOrigTrxRef (P_Building_Block_Id IN Number,

Line 8964: l_Search Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

8960: X_Status OUT NOCOPY Varchar2)
8961:
8962: Is
8963:
8964: l_Search Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
8965: l_Error_Text Varchar2(1800);
8966:
8967: Begin
8968:

Line 8993: Pa_Expenditure_Items_All

8989: Orig_Transaction_Reference
8990: Into
8991: X_OrigTrxRef
8992: From
8993: Pa_Expenditure_Items_All
8994: Where
8995: Orig_Transaction_Reference like l_Search
8996: And Transaction_Source = 'ORACLE TIME AND LABOR'
8997: And Nvl(Net_Zero_Adjustment_Flag,'N') = 'N'

Line 9003: Pa_Expenditure_Items_All

8999: And to_number(substr(Orig_Transaction_Reference,instr(Orig_Transaction_Reference,':') + 1)) = (
9000: Select
9001: Max(to_Number(Substr(Orig_Transaction_Reference,instr(Orig_Transaction_Reference,':') + 1)))
9002: From
9003: Pa_Expenditure_Items_All
9004: Where
9005: Orig_Transaction_Reference like l_Search
9006: And Transaction_Source = 'ORACLE TIME AND LABOR'
9007: And Nvl(Net_Zero_Adjustment_Flag,'N') = 'N'