DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PA_UTILS

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

467:
468: /* Where clause must restrict the retrieval to the current
469: * operating unit if Multi-Org is Implemented for Projects.
470: */
471: If Pa_Utils.Pa_Morg_Implemented = 'Y' Then
472:
473: G_Stage := 'Create where clause.';
474: If G_Debug_Mode = 'Y' Then
475: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

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

1185: G_Txn_Interface_Id_Tbl(G_Trx_Import_Index) := l_txn_xface_id;
1186: G_Transaction_Source_Tbl(G_Trx_Import_Index) := 'ORACLE TIME AND LABOR';
1187: G_User_Transaction_Source_Tbl(G_Trx_Import_Index) := Null;
1188: G_Batch_Name_Tbl(G_Trx_Import_Index) := l_batch_name;
1189: G_Expenditure_End_Date_Tbl(G_Trx_Import_Index) := Pa_Utils.NewGetWeekEnding(l_New_Timecard_Rec.Expenditure_Item_Date);
1190: G_Person_Bus_Grp_Name_Tbl(G_Trx_Import_Index) := Null;
1191: G_Person_Bus_Grp_Id_Tbl(G_Trx_Import_Index) := Null;
1192: G_Employee_Number_Tbl(G_Trx_Import_Index) := Null;
1193: G_Person_Id_Tbl(G_Trx_Import_Index) := l_New_Timecard_Rec.Incurred_By_Person_Id;

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

2847:
2848: If P_Timecard_Rec.Expenditure_Item_Date is not null Then
2849:
2850: P_Timecard_Rec.Expenditure_Ending_date :=
2851: Pa_Utils.NewGetWeekEnding(P_Timecard_Rec.Expenditure_Item_Date);
2852:
2853: End If;
2854:
2855: -- Begin PA.M/CWK changes

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

3400: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3401: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3402: End If;
3403:
3404: P_Timecard_Rec.Expenditure_Ending_date := Pa_Utils.NewGetWeekEnding(P_Timecard_Rec.Expenditure_Item_Date);
3405:
3406: G_Stage := 'Old Index check and assignment for use in loop';
3407: If G_Debug_Mode = 'Y' Then
3408: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 5025: l_Inc_By_Org_Id := Pa_Utils.GetEmpOrgId(

5021: -- Get Incurred_By_Organization_Id
5022: l_Error_Code := Null;
5023: l_Inc_By_Org_Id := Null;
5024: G_Stage := 'Get Incurred by Organization Id.';
5025: l_Inc_By_Org_Id := Pa_Utils.GetEmpOrgId(
5026: X_Person_Id => l_Proj_Attrib_Rec.Inc_By_Person_Id,
5027: X_Date => l_Proj_Attrib_Rec.Expenditure_Item_Date);
5028:
5029: If l_Inc_By_Org_Id is Null Then

Line 5058: l_Job_Id := Pa_Utils.GetEmpJobId (

5054:
5055: -- Check Job_Id
5056: G_Stage := 'Check for Job Id.';
5057: l_Job_Id := Null;
5058: l_Job_Id := Pa_Utils.GetEmpJobId (
5059: X_person_id => l_Proj_Attrib_Rec.Inc_By_Person_Id,
5060: X_date => l_Proj_Attrib_Rec.Expenditure_Item_Date);
5061:
5062: If l_Job_Id is Null Then

Line 5751: Pa_Utils.GetTaskInfo (

5747:
5748: If P_Task_Id is Not Null Then
5749:
5750: G_Stage := 'Parameter P_Task_Id is not Null, get Task Info.';
5751: Pa_Utils.GetTaskInfo (
5752: X_Task_Id => P_Task_Id,
5753: X_Task_Num => l_Task_Num,
5754: X_Task_Name => l_Task_Name);
5755:

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

6816:
6817: End Loop;
6818:
6819: G_Stage := 'Get Expenditure Ending Date.';
6820: X_Proj_Attrib_Rec.Exp_Ending_date := Pa_Utils.NewGetWeekEnding(X_Proj_Attrib_Rec.Expenditure_Item_Date);
6821:
6822: G_Stage := 'Get Unit of Measure.';
6823: X_Proj_Attrib_Rec.UOM := P_Building_Block_Rec.Unit_Of_Measure;
6824:

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

7248:
7249: End Loop;
7250:
7251: G_Stage := 'Get Expenditure Ending Date.';
7252: X_Proj_Attrib_Rec.Exp_Ending_date := Pa_Utils.NewGetWeekEnding(X_Proj_Attrib_Rec.Expenditure_Item_Date);
7253:
7254: G_Stage := 'Get Unit of Measure.';
7255: X_Proj_Attrib_Rec.UOM := P_Building_Block_Rec.Unit_Of_Measure;
7256:

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

7511: G_Stage := 'Checking start and end dates. Check if OTL using week long timecards.';
7512: If l_Days_in_Period = 7 Then
7513:
7514: G_Stage := 'Checking end the Stop_Date passed in matches WeekEnding dates in Projects.';
7515: If Pa_Utils.NewGetWeekEnding(Trunc(P_Stop_Date)) <> Trunc(P_Stop_Date) Then
7516:
7517: G_Msg_Tokens_Table.Delete;
7518:
7519: -- Add record to error table.

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

7543: l_Building_Blocks_Table := l_dummy_BB_Table;
7544: l_Attribute_Table := l_dummy_Attrib_Table;
7545:
7546: G_Stage := 'Check Multi Org';
7547: If Pa_Utils.Pa_Morg_Implemented = 'Y' Then
7548:
7549: l_Org_Id := Fnd_Profile.Value('ORG_ID');
7550:
7551: End If;

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

7911: if l_period_type = 'Week' then
7912:
7913: -- The default timecard period in OTL is a week.
7914:
7915: If Pa_Utils.NewGetWeekEnding(Trunc(P_Building_Blocks_Table(i).Stop_Time)) <>
7916: Trunc(P_Building_Blocks_Table(i).Stop_Time) Then
7917:
7918: -- The the week ending dates don't match. This is not allowed.
7919: /* change for bug 7584432 start here */

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

9081: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
9082: pa_cc_utils.log_message('GetAdditionalTrxData: ' || Pa_Debug.G_Err_Stage,0);
9083: End If;
9084:
9085: Pa_Utils3.GetCachedOrgId( P_Inc_By_Per_Id => P_Person_Id,
9086: P_Exp_Item_Date => P_EI_Date,
9087: X_Inc_By_Org_Id => X_Org_Id);
9088:
9089: G_Stage := 'Incurred by Organization Id is ' || to_char(X_Org_Id) ;