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_COMMENTS

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 1573: l_Exp_Comment Pa_Expenditure_Comments.Expenditure_Comment%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;
1577: l_PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE;

Line 1674: Pa_Expenditure_Comments EC,

1670: -- 12i changes
1671: l_org_id
1672: From
1673: Pa_Expenditure_Items EI,
1674: Pa_Expenditure_Comments EC,
1675: Pa_Expenditures E
1676: -- 3457943 S.N.
1677: --Pa_Tasks T
1678: -- 3457943 E.N.

Line 1906: Pa_Expenditure_Comments

1902: Cursor CheckExpComment (P_Ei_Id IN Number) Is
1903: Select
1904: Count(*)
1905: From
1906: Pa_Expenditure_Comments
1907: Where
1908: Expenditure_Item_Id = P_Ei_Id;
1909:
1910: l_Comment_Count Number := 0;

Line 1986: Insert into Pa_Expenditure_Comments

1982: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1983: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1984: End If;
1985:
1986: Insert into Pa_Expenditure_Comments
1987: ( Expenditure_Item_Id,
1988: Line_Number,
1989: Last_Update_Date,
1990: Last_Updated_By,

Line 2021: Update Pa_Expenditure_Comments

2017: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2018: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2019: End If;
2020:
2021: Update Pa_Expenditure_Comments
2022: Set Expenditure_Comment = P_Timecard_Rec.Expenditure_Item_Comment,
2023: Last_Updated_By = P_User_Id,
2024: Last_Update_Date = SysDate,
2025: Last_Update_Login = l_Last_Update_Login,

Line 2041: Delete From Pa_Expenditure_Comments

2037: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2038: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2039: End If;
2040:
2041: Delete From Pa_Expenditure_Comments
2042: Where Expenditure_Item_Id = l_Exp_Item_Id ;
2043:
2044: -- End bug 3496762
2045: End If;

Line 2091: Insert into Pa_Expenditure_Comments

2087: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2088: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2089: End If;
2090:
2091: Insert into Pa_Expenditure_Comments
2092: ( Expenditure_Item_Id,
2093: Line_Number,
2094: Last_Update_Date,
2095: Last_Updated_By,

Line 2126: Update Pa_Expenditure_Comments

2122: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2123: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2124: End If;
2125:
2126: Update Pa_Expenditure_Comments
2127: Set Expenditure_Comment = P_Timecard_Rec.Expenditure_Item_Comment,
2128: Last_Updated_By = P_User_Id,
2129: Last_Update_Date = SysDate,
2130: Last_Update_Login = l_Last_Update_Login,

Line 2146: Delete From Pa_Expenditure_Comments

2142: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2143: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2144: End If;
2145:
2146: Delete From Pa_Expenditure_Comments
2147: Where Expenditure_Item_Id = l_Exp_Item_Id ;
2148:
2149: -- End bug 3496762
2150: End If;

Line 6020: l_Exp_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE;

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
6024: Select

Line 6041: Pa_Expenditure_Comments c

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)
6045: Or ei.Expenditure_Type <> nvl(P_Proj_Attribute_Rec.Expenditure_Type,'-999999999')