DBA Data[Home] [Help]

APPS.PATC dependencies on PA_UTILS

Line 524: l_return_number := pa_utils.GetEmpOrgId( l_emp_number, p_ei_date );

520: End If;
521:
522: If l_emp_number is NOT NULL then
523:
524: l_return_number := pa_utils.GetEmpOrgId( l_emp_number, p_ei_date );
525: If l_return_number is NULL then
526: l_return_string := 'N';
527: End If;
528: End If;

Line 846: If not pa_utils.IsCrossChargeable(X_Project_Id) then

842: If (x_calling_module = 'APXIIMPT') Then
843:
844: print_message('Calling module = APXIIMPT');
845:
846: If not pa_utils.IsCrossChargeable(X_Project_Id) then
847: print_message('Project not chargeable');
848: return_error('PA_PROJECT_NOT_VALID');
849: End If ;
850:

Line 951: l_pa_date := pa_utils2.get_pa_date( p_ei_date => X_ei_date

947: */
948: l_prvdr_org_id := pa_moac_utils.get_current_org_id;
949: /* End bug 5214766
950:
951: l_pa_date := pa_utils2.get_pa_date( p_ei_date => X_ei_date
952: ,p_gl_date => SYSDATE
953: ,p_org_id => l_prvdr_org_id);
954:
955: IF l_pa_date is null THEN

Line 1227: temp_assignment_id := PA_UTILS4.get_assignment_id

1223: Temp_allow_unscheduled_exp := nvl(tc.SCHEDULED_EXP_ONLY,'N') ;
1224: IF ( p_assignment_id is NULL and x_person_id is NOT NULL and l_check_pjrm_tc_flag = 'Y') Then
1225:
1226: print_message('Stage:PATC:10.12.003.6');
1227: temp_assignment_id := PA_UTILS4.get_assignment_id
1228: (p_person_id => x_person_id
1229: ,p_project_id => x_project_id
1230: ,p_task_id => x_task_id
1231: ,p_ei_date => x_ei_date );

Line 1530: l_job_id := pa_utils.GetEmpJobId(

1526:
1527: -- Bug 4044057 To add validation for active assignment for entered Purchase Order for CWK
1528: IF x_calling_module = 'PAXVOTCB' and p_po_header_id is not null THEN
1529:
1530: l_job_id := pa_utils.GetEmpJobId(
1531: X_person_id => x_person_id,
1532: X_date => X_ei_date ,
1533: X_po_header_id => p_po_header_id,
1534: X_po_line_id => p_po_line_id);

Line 1552: IF pa_utils2.CheckExporg(X_incurred_by_org_id,X_ei_date) = 'N' then

1548: IF X_incurred_by_org_id is NOT NULL THEN
1549:
1550: IF pa_trx_import.g_skip_tc_flag <> 'Y' then /* Added for Bug # 2170237 */
1551:
1552: IF pa_utils2.CheckExporg(X_incurred_by_org_id,X_ei_date) = 'N' then
1553:
1554: print_message('Stage:PATC:10.12.011');
1555: return_error( 'PA_EXP_ORG_NOT_ACTIVE');
1556: END IF;

Line 1575: X_org_id := pa_utils.GetEmpOrgId( X_person_id, l_ac_termination_date);

1571: -- Bug 6156072: Base Bug 6045051: end
1572: end if;
1573:
1574: IF ( l_ac_termination_date is not null ) then
1575: X_org_id := pa_utils.GetEmpOrgId( X_person_id, l_ac_termination_date);
1576: ELSE
1577: X_org_id := pa_utils.GetEmpOrgId( X_person_id, X_ei_date );
1578: END IF;
1579: /* Added for Bug#4604614 (BaseBug#4118885) -- End */

Line 1577: X_org_id := pa_utils.GetEmpOrgId( X_person_id, X_ei_date );

1573:
1574: IF ( l_ac_termination_date is not null ) then
1575: X_org_id := pa_utils.GetEmpOrgId( X_person_id, l_ac_termination_date);
1576: ELSE
1577: X_org_id := pa_utils.GetEmpOrgId( X_person_id, X_ei_date );
1578: END IF;
1579: /* Added for Bug#4604614 (BaseBug#4118885) -- End */
1580:
1581: IF ( X_org_id IS NULL ) THEN

Line 1588: IF pa_utils2.CheckExporg(X_org_id,X_ei_date) = 'N' then

1584: END IF;
1585:
1586: IF pa_trx_import.g_skip_tc_flag <> 'Y' then /* Added for Bug # 2170237 */
1587:
1588: IF pa_utils2.CheckExporg(X_org_id,X_ei_date) = 'N' then
1589: print_message('Stage:PATC:10.12.013');
1590: return_error( 'PA_EXP_ORG_NOT_ACTIVE');
1591: END IF;
1592: END IF; /* Added for Bug # 2170237 */

Line 1742: PATC.G_OVERIDE_WORK_TYPE_ID := PA_UTILS4.get_work_type_id (

1738: If ( (nvl(PATC.G_OVERIDE_ASSIGNMENT_ID,0) <> nvl(L_BeforeCE_AsgnId,0)) and
1739: (proj.p_assign_precedes_task = 'Y') and
1740: (X_Calling_Module <> 'PAXTREPE') ) Then
1741:
1742: PATC.G_OVERIDE_WORK_TYPE_ID := PA_UTILS4.get_work_type_id (
1743: p_project_id =>X_project_id
1744: , p_task_id =>X_task_id
1745: , p_assignment_id=>nvl(PATC.G_OVERIDE_ASSIGNMENT_ID,0) );
1746:

Line 1747: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(

1743: p_project_id =>X_project_id
1744: , p_task_id =>X_task_id
1745: , p_assignment_id=>nvl(PATC.G_OVERIDE_ASSIGNMENT_ID,0) );
1746:
1747: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
1748: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID );
1749:
1750: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
1751: p_assignment_id =>PATC.G_OVERIDE_ASSIGNMENT_ID);

Line 1750: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(

1746:
1747: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
1748: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID );
1749:
1750: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
1751: p_assignment_id =>PATC.G_OVERIDE_ASSIGNMENT_ID);
1752:
1753: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
1754: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID);

Line 1753: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(

1749:
1750: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
1751: p_assignment_id =>PATC.G_OVERIDE_ASSIGNMENT_ID);
1752:
1753: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
1754: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID);
1755:
1756: -- start of projcurrency and EI attrib changes
1757: -- Override the Billable flag if the work type biilability is enabled

Line 1760: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty

1756: -- start of projcurrency and EI attrib changes
1757: -- Override the Billable flag if the work type biilability is enabled
1758: print_message('Stage:PATC:10.13.003');
1759:
1760: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty
1761: /* (p_work_type_id => p_work_type_id commented for bug 2648550 */
1762: /* Bug 2648550 used global variable in work_type_id parameter */
1763: (p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID
1764: ,p_tc_extn_bill_flag => X_billable_flag);

Line 1770: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(

1766:
1767: Else
1768:
1769: PATC.G_OVERIDE_WORK_TYPE_ID := p_work_type_id;
1770: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
1771: p_work_type_id => p_work_type_id);
1772: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
1773: p_assignment_id =>p_assignment_id);
1774: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(

Line 1772: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(

1768:
1769: PATC.G_OVERIDE_WORK_TYPE_ID := p_work_type_id;
1770: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
1771: p_work_type_id => p_work_type_id);
1772: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
1773: p_assignment_id =>p_assignment_id);
1774: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
1775: p_work_type_id => p_work_type_id);
1776:

Line 1774: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(

1770: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
1771: p_work_type_id => p_work_type_id);
1772: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
1773: p_assignment_id =>p_assignment_id);
1774: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
1775: p_work_type_id => p_work_type_id);
1776:
1777: -- start of projcurrency and EI attrib changes
1778: -- Override the Billable flag if the work type biilability is enabled

Line 1780: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty

1776:
1777: -- start of projcurrency and EI attrib changes
1778: -- Override the Billable flag if the work type biilability is enabled
1779: print_message('Stage:PATC:10.13.004');
1780: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty
1781: (p_work_type_id => p_work_type_id
1782: ,p_tc_extn_bill_flag => X_billable_flag);
1783:
1784: