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 378: l_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

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;
382: l_Direct_Update_Flag Boolean := True; /* changed for bug 13831042 */

Line 379: l_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

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;
382: l_Direct_Update_Flag Boolean := True; /* changed for bug 13831042 */
383: l_Comment_Or_Dff Varchar2(3); -- bug 12650576. increased to 3.

Line 801: -- pa_expenditure_comments and/or pa_expenditure_items_all.

797: Else
798:
799: -- Need to find out what has changed to determine whether or not need to
800: -- insert record into pa_transaction_interface or update tables
801: -- pa_expenditure_comments and/or pa_expenditure_items_all.
802: G_Stage := 'Call Determine Direct Update 3.';
803: If G_Debug_Mode = 'Y' Then
804: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
805: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 1558: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

1554: -- quantity
1555: --
1556: -- Parameters :
1557: -- IN
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

Line 1559: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

1555: --
1556: -- Parameters :
1557: -- IN
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

Line 1561: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE

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

Line 1568: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1564:
1565: /*------------------------------------------------------------------------- */
1566:
1567: Procedure Build_Reverse_Item(
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,

Line 1569: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1565: /*------------------------------------------------------------------------- */
1566:
1567: Procedure Build_Reverse_Item(
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 )

Line 1571: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,

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

Line 1582: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;

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

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

Line 1587: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;

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

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

Line 1590: l_Attribute1 Pa_Expenditure_Items_All.Attribute1%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;
1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;

Line 1591: l_Attribute2 Pa_Expenditure_Items_All.Attribute2%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;
1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;

Line 1592: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%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;
1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;

Line 1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%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;
1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;

Line 1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%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;
1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;

Line 1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;

1591: l_Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE;
1592: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE;
1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;

Line 1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;

1592: l_Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE;
1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE;

Line 1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;

1593: l_Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE;
1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE;
1601: l_Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE;

Line 1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;

1594: l_Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE;
1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

Line 1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;

1595: l_Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE;
1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

Line 1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE;

1596: l_Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE;
1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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

Line 1601: l_Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE;

1597: l_Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE;
1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

Line 1602: l_Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE;

1598: l_Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE;
1599: l_Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE;
1600: l_Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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;

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

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

Line 1615: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE;

1611: -- End CWK changes PA.M
1612: -- 12i changes
1613: l_Org_Id Number := Null;
1614: -- bug 10253400: Payroll integration enhancement for 12.2..start
1615: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE;
1616: l_Location_Id Pa_Expenditure_Items_All.Location_Id%TYPE;
1617: l_Pay_Element_Type_Id Pa_Expenditure_Items_All.Pay_Element_Type_Id%TYPE;
1618: -- bug 10253400: Payroll integration enhancement for 12.2..end
1619: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146

Line 1616: l_Location_Id Pa_Expenditure_Items_All.Location_Id%TYPE;

1612: -- 12i changes
1613: l_Org_Id Number := Null;
1614: -- bug 10253400: Payroll integration enhancement for 12.2..start
1615: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE;
1616: l_Location_Id Pa_Expenditure_Items_All.Location_Id%TYPE;
1617: l_Pay_Element_Type_Id Pa_Expenditure_Items_All.Pay_Element_Type_Id%TYPE;
1618: -- bug 10253400: Payroll integration enhancement for 12.2..end
1619: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146
1620:

Line 1617: l_Pay_Element_Type_Id Pa_Expenditure_Items_All.Pay_Element_Type_Id%TYPE;

1613: l_Org_Id Number := Null;
1614: -- bug 10253400: Payroll integration enhancement for 12.2..start
1615: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE;
1616: l_Location_Id Pa_Expenditure_Items_All.Location_Id%TYPE;
1617: l_Pay_Element_Type_Id Pa_Expenditure_Items_All.Pay_Element_Type_Id%TYPE;
1618: -- bug 10253400: Payroll integration enhancement for 12.2..end
1619: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146
1620:
1621: Begin

Line 1619: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146

1615: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE;
1616: l_Location_Id Pa_Expenditure_Items_All.Location_Id%TYPE;
1617: l_Pay_Element_Type_Id Pa_Expenditure_Items_All.Pay_Element_Type_Id%TYPE;
1618: -- bug 10253400: Payroll integration enhancement for 12.2..end
1619: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146
1620:
1621: Begin
1622:
1623: G_Stage := 'Enter Build_Reverse_Item().';

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

1935: -- DP for DFFs and Payroll Element
1936: -- CDP for Comments, DFFs and Payroll Elements
1937: --
1938: -- Parameters :
1939: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1940: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1941: -- P_Comment_Or_Dff - Varchar2(1)
1942: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
1943: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE

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

1936: -- CDP for Comments, DFFs and Payroll Elements
1937: --
1938: -- Parameters :
1939: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1940: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1941: -- P_Comment_Or_Dff - Varchar2(1)
1942: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
1943: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1944: --

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

1939: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1940: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1941: -- P_Comment_Or_Dff - Varchar2(1)
1942: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
1943: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1944: --
1945: -- OUT NONE
1946: --
1947:

Line 1951: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1947:
1948: /*--------------------------------------------------------------------------*/
1949:
1950: Procedure UpdateChangedOrigTxn(
1951: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1952: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1953: P_Comment_Or_Dff IN Varchar2,
1954: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
1955: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)

Line 1952: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

1948: /*--------------------------------------------------------------------------*/
1949:
1950: Procedure UpdateChangedOrigTxn(
1951: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1952: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1953: P_Comment_Or_Dff IN Varchar2,
1954: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
1955: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)
1956:

Line 1955: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)

1951: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1952: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1953: P_Comment_Or_Dff IN Varchar2,
1954: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
1955: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)
1956:
1957: Is
1958:
1959: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE := Null;

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

1955: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE)
1956:
1957: Is
1958:
1959: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE := Null;
1960: l_RowId RowId;
1961: l_Last_Update_Login Pa_Expenditure_Items_All.Last_Update_Login%TYPE := to_Number(Fnd_Profile.Value('LOGIN_ID'));
1962: --Added for bug 4105561
1963: x_request_id NUMBER(15);

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

1957: Is
1958:
1959: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE := Null;
1960: l_RowId RowId;
1961: l_Last_Update_Login Pa_Expenditure_Items_All.Last_Update_Login%TYPE := to_Number(Fnd_Profile.Value('LOGIN_ID'));
1962: --Added for bug 4105561
1963: x_request_id NUMBER(15);
1964: x_program_application_id NUMBER(15);
1965: x_program_id NUMBER(15);

Line 1999: Pa_Expenditure_Items_All

1995: Into
1996: l_RowId,
1997: l_Exp_Item_Id
1998: From
1999: Pa_Expenditure_Items_All
2000: Where
2001: Transaction_Source = 'ORACLE TIME AND LABOR'
2002: And Orig_Transaction_Reference = P_Old_Orig_Txn_Ref
2003: And Net_Zero_Adjustment_Flag = 'N'; -- Bug 3480159

Line 2031: Update Pa_Expenditure_Items_All

2027: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2028: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2029: End If;
2030:
2031: Update Pa_Expenditure_Items_All
2032: Set Orig_Transaction_Reference = P_New_Orig_Txn_Ref,
2033: Last_Updated_By = P_User_Id,
2034: Last_Update_Date = SysDate,
2035: Last_Update_Login = l_Last_Update_Login,

Line 2124: Update Pa_Expenditure_Items_All

2120: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2121: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2122: End If;
2123:
2124: Update Pa_Expenditure_Items_All
2125: Set Orig_Transaction_Reference = P_New_Orig_Txn_Ref,
2126: Attribute_category = P_Timecard_Rec.Attribute_Category,
2127: Attribute1 = P_Timecard_Rec.Attribute1,
2128: Attribute2 = P_Timecard_Rec.Attribute2,

Line 2156: Update Pa_Expenditure_Items_All

2152: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2153: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2154: End If;
2155:
2156: Update Pa_Expenditure_Items_All
2157: Set pay_element_type_id = P_Timecard_Rec.Pay_Element_Type_Id,
2158: Orig_Transaction_Reference = P_New_Orig_Txn_Ref,
2159: Last_Updated_By = P_User_Id,
2160: Last_Update_Date = SysDate,

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

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

Line 4832: l_bbid Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;

4828: l_Header_Pass_Val_Flag Varchar2(1) := Null;
4829: i Binary_Integer := Null;
4830: -- Added for bug 8345301
4831: l_closed_proj_flag Varchar2(1) := 'N';
4832: l_bbid Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;
4833: l_calling_module VARCHAR2(20); /*Added for bug#13803367 */
4834:
4835: Begin
4836: l_calling_module :='PAXVOTCB'; /*Added for bug#13803367 */

Line 4977: Pa_Expenditure_Items_All ei,

4973: 'Y'
4974: into l_closed_proj_flag from dual
4975: where exists (select 1
4976: From
4977: Pa_Expenditure_Items_All ei,
4978: pa_projects_all ppa
4979: Where
4980: ei.project_id <> l_Proj_Attrib_Rec.PROJECT_ID and
4981: ei.project_id = ppa.project_id and

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

6286: -- Parameters :
6287: -- IN
6288: -- P_System_Linkage - Pa_System_Linkages.Function%TYPE
6289: -- P_Expenditure_Type - Pa_Expenditure_Types.Expenditure_Type%TYPE
6290: -- P_Exp_Item_date - Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE
6291: -- OUT
6292: -- X_Error_Code - Varchar2
6293: -- X_Error_Type - Varchar2
6294:

Line 6300: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

6296:
6297: Procedure Validate_Exp_Type_Exists(
6298: P_System_Linkage IN Pa_System_Linkages.Function%TYPE,
6299: P_Expenditure_Type IN Pa_Expenditure_Types.Expenditure_Type%TYPE,
6300: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6301: X_Error_Type OUT NOCOPY Varchar2,
6302: X_Error_Code OUT NOCOPY Varchar2) Is
6303:
6304: Cursor Cur_Etype_Slink (P_EI_Date IN Date,

Line 6456: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

6452: /*-------------------------------------------------------------------------*/
6453:
6454: Procedure Validate_Work_Type_Exists(
6455: P_Work_Type_Id IN PA_Work_Types_B.Work_Type_Id%TYPE,
6456: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6457: X_Error_Code OUT NOCOPY Varchar2,
6458: X_Error_Type OUT NOCOPY Varchar2)
6459: Is
6460:

Line 6526: -- P_Job_Id - Pa_Expenditure_items_All.Job_Id%TYPE

6522: -- This procedure does not perform any extensive validations.
6523: -- If the job exists, X_Error_Code will be null.
6524: -- Parameters :
6525: -- IN
6526: -- P_Job_Id - Pa_Expenditure_items_All.Job_Id%TYPE
6527: -- OUT
6528: -- X_Error_Code - Varchar2
6529: -- X_Error_Type - Varchar2
6530:

Line 6534: P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE,

6530:
6531: /*-------------------------------------------------------------------------*/
6532:
6533: Procedure Validate_Job_Exists(
6534: P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE,
6535: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6536: X_Error_Code OUT NOCOPY Varchar2,
6537: X_Error_Type OUT NOCOPY Varchar2)
6538: Is

Line 6535: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

6531: /*-------------------------------------------------------------------------*/
6532:
6533: Procedure Validate_Job_Exists(
6534: P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE,
6535: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6536: X_Error_Code OUT NOCOPY Varchar2,
6537: X_Error_Type OUT NOCOPY Varchar2)
6538: Is
6539:

Line 6541: Cursor GetJobInfo(P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE) IS

6537: X_Error_Type OUT NOCOPY Varchar2)
6538: Is
6539:
6540:
6541: Cursor GetJobInfo(P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE) IS
6542: select
6543: name
6544: from per_jobs_v w
6545: where w.job_Id = P_job_Id

Line 6610: -- P_Location_ID - Pa_Expenditure_Items_All.Location_ID%TYPE

6606: -- extensive project related validations. If the work type
6607: -- exists in Oracle Projects, X_Error_Code will be null.
6608: -- Parameters :
6609: -- IN
6610: -- P_Location_ID - Pa_Expenditure_Items_All.Location_ID%TYPE
6611: -- OUT
6612: -- X_Error_Code - Varchar2
6613: -- X_Error_Type - Varchar2
6614:

Line 6618: p_location_id IN PA_Expenditure_Items_all.Location_ID%TYPE,

6614:
6615: /*-------------------------------------------------------------------------*/
6616:
6617: Procedure Validate_Location_Exists(
6618: p_location_id IN PA_Expenditure_Items_all.Location_ID%TYPE,
6619: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6620: X_Error_Code OUT NOCOPY Varchar2,
6621: X_Error_Type OUT NOCOPY Varchar2)
6622: Is

Line 6619: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

6615: /*-------------------------------------------------------------------------*/
6616:
6617: Procedure Validate_Location_Exists(
6618: p_location_id IN PA_Expenditure_Items_all.Location_ID%TYPE,
6619: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6620: X_Error_Code OUT NOCOPY Varchar2,
6621: X_Error_Type OUT NOCOPY Varchar2)
6622: Is
6623:

Line 6625: Cursor GetLocationInfo(P_Location_Id IN Pa_Expenditure_Items_All.Location_Id%TYPE) IS

6621: X_Error_Type OUT NOCOPY Varchar2)
6622: Is
6623:
6624:
6625: Cursor GetLocationInfo(P_Location_Id IN Pa_Expenditure_Items_All.Location_Id%TYPE) IS
6626: select l.location_code
6627: from hr_locations l
6628: where location_id = P_Location_Id
6629: and p_exp_item_date <= nvl(l.inactive_date, p_exp_item_date)

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

6714: X_Adj_in_Projects_Flag OUT NOCOPY Varchar2)
6715:
6716: Is
6717:
6718: l_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;
6719: l_Net_Zero_flag Pa_Expenditure_Items_All.Net_Zero_Adjustment_Flag%TYPE := 'N';
6720: l_Max_Version Number := 0;
6721: l_RowId RowId;
6722: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;

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

6715:
6716: Is
6717:
6718: l_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;
6719: l_Net_Zero_flag Pa_Expenditure_Items_All.Net_Zero_Adjustment_Flag%TYPE := 'N';
6720: l_Max_Version Number := 0;
6721: l_RowId RowId;
6722: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;
6723: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;

Line 6722: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;

6718: l_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE := Null;
6719: l_Net_Zero_flag Pa_Expenditure_Items_All.Net_Zero_Adjustment_Flag%TYPE := 'N';
6720: l_Max_Version Number := 0;
6721: l_RowId RowId;
6722: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;
6723: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;
6724: l_Ovn_Check_Value Number := 0;
6725: -- Bug 10253400.. 12.2 payroll intg .. start
6726: l_job_id Pa_Expenditure_Items_All.Job_id%TYPE;

Line 6726: l_job_id Pa_Expenditure_Items_All.Job_id%TYPE;

6722: l_Exp_Item_Id Pa_Expenditure_Items_All.Expenditure_Item_Id%TYPE;
6723: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;
6724: l_Ovn_Check_Value Number := 0;
6725: -- Bug 10253400.. 12.2 payroll intg .. start
6726: l_job_id Pa_Expenditure_Items_All.Job_id%TYPE;
6727: l_location_id Pa_Expenditure_Items_All.Location_id%TYPE;
6728: l_pay_element_type_id Pa_Expenditure_Items_All.pay_element_type_id%TYPE;
6729: -- Bug 10253400.. 12.2 payroll intg .. end
6730:

Line 6727: l_location_id Pa_Expenditure_Items_All.Location_id%TYPE;

6723: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;
6724: l_Ovn_Check_Value Number := 0;
6725: -- Bug 10253400.. 12.2 payroll intg .. start
6726: l_job_id Pa_Expenditure_Items_All.Job_id%TYPE;
6727: l_location_id Pa_Expenditure_Items_All.Location_id%TYPE;
6728: l_pay_element_type_id Pa_Expenditure_Items_All.pay_element_type_id%TYPE;
6729: -- Bug 10253400.. 12.2 payroll intg .. end
6730:
6731: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146

Line 6728: l_pay_element_type_id Pa_Expenditure_Items_All.pay_element_type_id%TYPE;

6724: l_Ovn_Check_Value Number := 0;
6725: -- Bug 10253400.. 12.2 payroll intg .. start
6726: l_job_id Pa_Expenditure_Items_All.Job_id%TYPE;
6727: l_location_id Pa_Expenditure_Items_All.Location_id%TYPE;
6728: l_pay_element_type_id Pa_Expenditure_Items_All.pay_element_type_id%TYPE;
6729: -- Bug 10253400.. 12.2 payroll intg .. end
6730:
6731: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146
6732:

Line 6731: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146

6727: l_location_id Pa_Expenditure_Items_All.Location_id%TYPE;
6728: l_pay_element_type_id Pa_Expenditure_Items_All.pay_element_type_id%TYPE;
6729: -- Bug 10253400.. 12.2 payroll intg .. end
6730:
6731: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146
6732:
6733: /*Start -changes for bug:7604482 */
6734: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
6735: l_Task_Id Pa_Tasks.Task_Id%TYPE;

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

6735: l_Task_Id Pa_Tasks.Task_Id%TYPE;
6736: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
6737: /*End -changes for bug:7604482 */
6738:
6739: Cursor AdjustmentRecords (P_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Is
6740: Select
6741: RowId,
6742: Expenditure_Item_Id,
6743: Net_Zero_Adjustment_Flag,

Line 6746: Pa_Expenditure_Items_All

6742: Expenditure_Item_Id,
6743: Net_Zero_Adjustment_Flag,
6744: Orig_Transaction_Reference
6745: From
6746: Pa_Expenditure_Items_All
6747: Where
6748: Transaction_Source = 'ORACLE TIME AND LABOR'
6749: And Orig_Transaction_Reference like l_orig_trx_ref
6750: Order By Orig_Transaction_Reference;

Line 6756: Pa_Expenditure_Items_All ei,

6752: Cursor EiIsChanged ( P_RowId IN RowId ) Is
6753: Select
6754: 'Y'
6755: From
6756: Pa_Expenditure_Items_All ei,
6757: Pa_Expenditure_Comments c
6758: Where
6759: ei.Expenditure_Item_Id = c.Expenditure_Item_Id(+)
6760: And (ei.Task_Id <> nvl(P_Proj_Attribute_Rec.Task_Id,-99)

Line 6787: l_Orig_Transaction_Reference Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

6783: Or nvl(ei.Cbs_Element_Id, -99) <> nvl(P_Proj_Attribute_Rec.Cbs_Element_Id, nvl(ei.Cbs_Element_Id, -99))) -- Added for CBS Enhancement Bug 16220146
6784: And ei.RowId = P_RowId;
6785: --Bug 14796976
6786: AdjRec AdjustmentRecords%RowType;
6787: l_Orig_Transaction_Reference Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
6788: l_Ei_Changed_Flag Varchar2(1) := 'N';
6789:
6790: E_Exception Exception;
6791:

Line 6928: Update Pa_Expenditure_Items_all --for Bug# 13519235

6924: ( P_BB_Changed = 'Y' or P_Process_Flag = 'Y' ) and
6925: X_BB_Detail_Deleted = 'N' Then
6926:
6927: G_Stage := 'Only Ovn has changed. Update the orig_transaction_reference of the ei.';
6928: Update Pa_Expenditure_Items_all --for Bug# 13519235
6929: Set
6930: Orig_Transaction_Reference = To_Char(P_BB_Id) || ':' || To_Char(l_Ovn_Check_Value),
6931: last_update_date = sysdate,
6932: last_updated_by = to_Number(Fnd_Profile.Value('USER_ID')),

Line 6943: from Pa_Expenditure_Items_all --for Bug# 13519235

6939: select project_id , task_id, expenditure_type,
6940: job_id, location_id, pay_element_type_id, cbs_element_id
6941: into l_Proj_Id , l_task_id , l_Exp_Type,
6942: l_job_id, l_location_id, l_pay_element_type_id, l_Cbs_Element_Id
6943: from Pa_Expenditure_Items_all --for Bug# 13519235
6944: where RowId = l_RowId;
6945:
6946: -- Bug 10253400.. 12.2 payroll intg .. extend the check to include job, location and pay element
6947: -- Bug 16220146: extended the check for cbs_element_id

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

7017: -- has been imported into Projects can adjusted in Projects by calling the
7018: -- API Hxc_Generic_Retrieval_Utils.Time_Bld_Blk_Changed.
7019: --
7020: -- Parameters :
7021: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
7022: -- OUT X_Flag - Varchar2(1)
7023: --
7024: /*--------------------------------------------------------------------------*/
7025:

Line 7027: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

7023: --
7024: /*--------------------------------------------------------------------------*/
7025:
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;

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

9579: -- projects does not recognize and doesn't want to, thus the ovn changes in OTL.)
9580: --
9581: -- Parameters :
9582: -- IN
9583: -- P_Orig_Transaction_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
9584:
9585: /*------------------------------------------------------------------------- */
9586:
9587: Function OrigTrxRefValueExists

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

9584:
9585: /*------------------------------------------------------------------------- */
9586:
9587: Function OrigTrxRefValueExists
9588: ( P_Orig_Transaction_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Return Boolean
9589:
9590: Is
9591:
9592: l_Exists_Flag VARCHAR2(1) := 'N';

Line 9601: Pa_Expenditure_Items_All

9597: distinct 'Y' -- Bug#9374217: Added distinct clause to avoid the ORA-1422 error.
9598: Into
9599: l_Exists_Flag
9600: From
9601: Pa_Expenditure_Items_All
9602: Where
9603: Transaction_Source = 'ORACLE TIME AND LABOR'
9604: And Orig_Transaction_Reference = P_Orig_Transaction_Reference;
9605:

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

9632: -- has been imported into Projects can adjusted in Projects by calling the
9633: -- API Hxc_Generic_Retrieval_Utils.Time_Bld_Blk_Changed.
9634: --
9635: -- Parameters :
9636: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
9637: --
9638: /*--------------------------------------------------------------------------*/
9639:
9640: Function ChkAdjustAllowedToOTCItem

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

9637: --
9638: /*--------------------------------------------------------------------------*/
9639:
9640: Function ChkAdjustAllowedToOTCItem
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;

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

9865: -- Parameters :
9866: -- IN
9867: -- P_Building_Block_Id - Number
9868: -- OUT
9869: -- X_OrigTrxRef - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
9870: -- X_Status - Varchar2
9871: /*--------------------------------------------------------------------------*/
9872:
9873: Procedure GetOrigTrxRef (P_Building_Block_Id IN Number,

Line 9879: l_Search Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

9875: X_Status OUT NOCOPY Varchar2)
9876:
9877: Is
9878:
9879: l_Search Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
9880: l_Error_Text Varchar2(1800);
9881:
9882: Begin
9883:

Line 9908: Pa_Expenditure_Items_All

9904: Orig_Transaction_Reference
9905: Into
9906: X_OrigTrxRef
9907: From
9908: Pa_Expenditure_Items_All
9909: Where
9910: Orig_Transaction_Reference like l_Search
9911: And Transaction_Source = 'ORACLE TIME AND LABOR'
9912: And Nvl(Net_Zero_Adjustment_Flag,'N') = 'N'

Line 9918: Pa_Expenditure_Items_All

9914: And to_number(substr(Orig_Transaction_Reference,instr(Orig_Transaction_Reference,':') + 1)) = (
9915: Select
9916: Max(to_Number(Substr(Orig_Transaction_Reference,instr(Orig_Transaction_Reference,':') + 1)))
9917: From
9918: Pa_Expenditure_Items_All
9919: Where
9920: Orig_Transaction_Reference like l_Search
9921: And Transaction_Source = 'ORACLE TIME AND LABOR'
9922: And Nvl(Net_Zero_Adjustment_Flag,'N') = 'N'