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_UTILS

Line 489: If Pa_Utils.Pa_Morg_Implemented = 'Y' Then

485:
486: /* Where clause must restrict the retrieval to the current
487: * operating unit if Multi-Org is Implemented for Projects.
488: */
489: If Pa_Utils.Pa_Morg_Implemented = 'Y' Then
490:
491: G_Stage := 'Create where clause.';
492: If G_Debug_Mode = 'Y' Then
493: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 1207: G_Expenditure_End_Date_Tbl(G_Trx_Import_Index) := Pa_Utils.NewGetWeekEnding(l_New_Timecard_Rec.Expenditure_Item_Date);

1203: G_Txn_Interface_Id_Tbl(G_Trx_Import_Index) := l_txn_xface_id;
1204: G_Transaction_Source_Tbl(G_Trx_Import_Index) := 'ORACLE TIME AND LABOR';
1205: G_User_Transaction_Source_Tbl(G_Trx_Import_Index) := Null;
1206: G_Batch_Name_Tbl(G_Trx_Import_Index) := l_batch_name;
1207: G_Expenditure_End_Date_Tbl(G_Trx_Import_Index) := Pa_Utils.NewGetWeekEnding(l_New_Timecard_Rec.Expenditure_Item_Date);
1208: G_Person_Bus_Grp_Name_Tbl(G_Trx_Import_Index) := Null;
1209: G_Person_Bus_Grp_Id_Tbl(G_Trx_Import_Index) := Null;
1210: G_Employee_Number_Tbl(G_Trx_Import_Index) := Null;
1211: G_Person_Id_Tbl(G_Trx_Import_Index) := l_New_Timecard_Rec.Incurred_By_Person_Id;

Line 2915: Pa_Utils.NewGetWeekEnding(P_Timecard_Rec.Expenditure_Item_Date);

2911:
2912: If P_Timecard_Rec.Expenditure_Item_Date is not null Then
2913:
2914: P_Timecard_Rec.Expenditure_Ending_date :=
2915: Pa_Utils.NewGetWeekEnding(P_Timecard_Rec.Expenditure_Item_Date);
2916:
2917: End If;
2918:
2919: -- Begin PA.M/CWK changes

Line 3576: P_Timecard_Rec.Expenditure_Ending_date := Pa_Utils.NewGetWeekEnding(P_Timecard_Rec.Expenditure_Item_Date);

3572: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3573: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3574: End If;
3575:
3576: P_Timecard_Rec.Expenditure_Ending_date := Pa_Utils.NewGetWeekEnding(P_Timecard_Rec.Expenditure_Item_Date);
3577:
3578: G_Stage := 'Old Index check and assignment for use in loop';
3579: If G_Debug_Mode = 'Y' Then
3580: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 5472: l_Inc_By_Org_Id := Pa_Utils.GetEmpOrgId(

5468: -- Get Incurred_By_Organization_Id
5469: l_Error_Code := Null;
5470: l_Inc_By_Org_Id := Null;
5471: G_Stage := 'Get Incurred by Organization Id.';
5472: l_Inc_By_Org_Id := Pa_Utils.GetEmpOrgId(
5473: X_Person_Id => l_Proj_Attrib_Rec.Inc_By_Person_Id,
5474: X_Date => l_Proj_Attrib_Rec.Expenditure_Item_Date);
5475:
5476: If l_Inc_By_Org_Id is Null Then

Line 5510: l_Job_Id := pa_utils.getjobid(x_job_id => l_Proj_Attrib_Rec.Job_Id,

5506: -- get the job_id entered and validate it. If job is not entered then existing logic derives it.
5507: l_job_Id := l_Proj_Attrib_Rec.Job_Id;
5508:
5509: if l_Job_Id is not null then
5510: l_Job_Id := pa_utils.getjobid(x_job_id => l_Proj_Attrib_Rec.Job_Id,
5511: x_date => l_Proj_Attrib_Rec.Expenditure_Item_Date);
5512: else
5513: l_Job_Id := Pa_Utils.GetEmpJobId (
5514: X_person_id => l_Proj_Attrib_Rec.Inc_By_Person_Id,

Line 5513: l_Job_Id := Pa_Utils.GetEmpJobId (

5509: if l_Job_Id is not null then
5510: l_Job_Id := pa_utils.getjobid(x_job_id => l_Proj_Attrib_Rec.Job_Id,
5511: x_date => l_Proj_Attrib_Rec.Expenditure_Item_Date);
5512: else
5513: l_Job_Id := Pa_Utils.GetEmpJobId (
5514: X_person_id => l_Proj_Attrib_Rec.Inc_By_Person_Id,
5515: X_date => l_Proj_Attrib_Rec.Expenditure_Item_Date);
5516:
5517: end if; -- l_job_id is not null

Line 6218: Pa_Utils.GetTaskInfo (

6214:
6215: If P_Task_Id is Not Null Then
6216:
6217: G_Stage := 'Parameter P_Task_Id is not Null, get Task Info.';
6218: Pa_Utils.GetTaskInfo (
6219: X_Task_Id => P_Task_Id,
6220: X_Task_Num => l_Task_Num,
6221: X_Task_Name => l_Task_Name);
6222:

Line 7634: X_Proj_Attrib_Rec.Exp_Ending_date := Pa_Utils.NewGetWeekEnding(X_Proj_Attrib_Rec.Expenditure_Item_Date);

7630:
7631: End Loop;
7632:
7633: G_Stage := 'Get Expenditure Ending Date.';
7634: X_Proj_Attrib_Rec.Exp_Ending_date := Pa_Utils.NewGetWeekEnding(X_Proj_Attrib_Rec.Expenditure_Item_Date);
7635:
7636: G_Stage := 'Get Unit of Measure.';
7637: X_Proj_Attrib_Rec.UOM := P_Building_Block_Rec.Unit_Of_Measure;
7638:

Line 8135: X_Proj_Attrib_Rec.Exp_Ending_date := Pa_Utils.NewGetWeekEnding(X_Proj_Attrib_Rec.Expenditure_Item_Date);

8131:
8132: End Loop;
8133:
8134: G_Stage := 'Get Expenditure Ending Date.';
8135: X_Proj_Attrib_Rec.Exp_Ending_date := Pa_Utils.NewGetWeekEnding(X_Proj_Attrib_Rec.Expenditure_Item_Date);
8136:
8137: G_Stage := 'Get Unit of Measure.';
8138: X_Proj_Attrib_Rec.UOM := P_Building_Block_Rec.Unit_Of_Measure;
8139:

Line 8398: If Pa_Utils.NewGetWeekEnding(Trunc(P_Stop_Date)) <> Trunc(P_Stop_Date) Then

8394: G_Stage := 'Checking start and end dates. Check if OTL using week long timecards.';
8395: If l_Days_in_Period = 7 Then
8396:
8397: G_Stage := 'Checking end the Stop_Date passed in matches WeekEnding dates in Projects.';
8398: If Pa_Utils.NewGetWeekEnding(Trunc(P_Stop_Date)) <> Trunc(P_Stop_Date) Then
8399:
8400: G_Msg_Tokens_Table.Delete;
8401:
8402: -- Add record to error table.

Line 8430: If Pa_Utils.Pa_Morg_Implemented = 'Y' Then

8426: l_Building_Blocks_Table := l_dummy_BB_Table;
8427: l_Attribute_Table := l_dummy_Attrib_Table;
8428:
8429: G_Stage := 'Check Multi Org';
8430: If Pa_Utils.Pa_Morg_Implemented = 'Y' Then
8431:
8432: l_Org_Id := Fnd_Profile.Value('ORG_ID');
8433:
8434: End If;

Line 8807: If Pa_Utils.NewGetWeekEnding(Trunc(P_Building_Blocks_Table(i).Stop_Time)) <>

8803: if l_period_type = 'Week' then
8804:
8805: -- The default timecard period in OTL is a week.
8806:
8807: If Pa_Utils.NewGetWeekEnding(Trunc(P_Building_Blocks_Table(i).Stop_Time)) <>
8808: Trunc(P_Building_Blocks_Table(i).Stop_Time) Then
8809:
8810: /* change for bug 8528840 start here */
8811: open is_assignment_end_date(P_Building_Blocks_Table(i).resource_id,P_Building_Blocks_Table(i).Stop_Time);

Line 10000: Pa_Utils3.GetCachedOrgId( P_Inc_By_Per_Id => P_Person_Id,

9996: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
9997: pa_cc_utils.log_message('GetAdditionalTrxData: ' || Pa_Debug.G_Err_Stage,0);
9998: End If;
9999:
10000: Pa_Utils3.GetCachedOrgId( P_Inc_By_Per_Id => P_Person_Id,
10001: P_Exp_Item_Date => P_EI_Date,
10002: X_Inc_By_Org_Id => X_Org_Id);
10003:
10004: G_Stage := 'Incurred by Organization Id is ' || to_char(X_Org_Id) ;