DBA Data[Home] [Help]

APPS.PATC dependencies on PA_UTILS

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

573: End If;
574:
575: If l_emp_number is NOT NULL then
576:
577: l_return_number := pa_utils.GetEmpOrgId( l_emp_number, p_ei_date );
578: If l_return_number is NULL then
579: l_return_string := 'N';
580: End If;
581: End If;

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

1036: If (x_calling_module = 'APXIIMPT') Then
1037:
1038: print_message('Calling module = APXIIMPT');
1039:
1040: If not pa_utils.IsCrossChargeable(X_Project_Id) then
1041: print_message('Project not chargeable');
1042: return_error('PA_PROJECT_NOT_VALID');
1043: End If ;
1044:

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

1156:
1157: END IF;
1158: /* Added for bug 15953273 */
1159:
1160: l_pa_date := pa_utils2.get_pa_date( p_ei_date => X_ei_date
1161: ,p_gl_date => SYSDATE
1162: ,p_org_id => l_prvdr_org_id);
1163:
1164: IF l_pa_date is null THEN

Line 1574: temp_assignment_id := PA_UTILS4.get_assignment_id

1570: Temp_allow_unscheduled_exp := nvl(tc.SCHEDULED_EXP_ONLY,'N') ;
1571: IF ( p_assignment_id is NULL and x_person_id is NOT NULL and l_check_pjrm_tc_flag = 'Y') Then
1572:
1573: print_message('Stage:PATC:10.12.003.6');
1574: temp_assignment_id := PA_UTILS4.get_assignment_id
1575: (p_person_id => x_person_id
1576: ,p_project_id => x_project_id
1577: ,p_task_id => l_task_id -- Replaced X_task_id with l_task_id for bug 16220146
1578: ,p_ei_date => x_ei_date );

Line 1894: l_job_id := pa_utils.GetEmpJobId(

1890:
1891: -- Bug 4044057 To add validation for active assignment for entered Purchase Order for CWK
1892: IF x_calling_module = 'PAXVOTCB' and p_po_header_id is not null THEN
1893:
1894: l_job_id := pa_utils.GetEmpJobId(
1895: X_person_id => x_person_id,
1896: X_date => X_ei_date ,
1897: X_po_header_id => p_po_header_id,
1898: X_po_line_id => p_po_line_id);

Line 1917: /*IF pa_utils2.CheckExporg(X_incurred_by_org_id,X_ei_date) = 'N' then

1913:
1914: IF pa_trx_import.g_skip_tc_flag <> 'Y' then /* Added for Bug # 2170237 */
1915:
1916: /* Enhancement request BUG12801896 changes STARTS here */
1917: /*IF pa_utils2.CheckExporg(X_incurred_by_org_id,X_ei_date) = 'N' then
1918:
1919: print_message('Stage:PATC:10.12.011');
1920: return_error( 'PA_EXP_ORG_NOT_ACTIVE');
1921: END IF; */ --commented the condition for BUG12801896

Line 1923: IF (pa_utils2.CheckExporg(X_incurred_by_org_id,X_ei_date) = 'N' AND x_calling_module <> 'PAXPRRPE') THEN

1919: print_message('Stage:PATC:10.12.011');
1920: return_error( 'PA_EXP_ORG_NOT_ACTIVE');
1921: END IF; */ --commented the condition for BUG12801896
1922:
1923: IF (pa_utils2.CheckExporg(X_incurred_by_org_id,X_ei_date) = 'N' AND x_calling_module <> 'PAXPRRPE') THEN
1924: print_message('Stage:PATC:10.12.011');
1925: return_error( 'PA_EXP_ORG_NOT_ACTIVE');
1926: else
1927: print_message('Stage:PATC:10.12.011.01');

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

1944: -- Bug 6156072: Base Bug 6045051: end
1945: end if;
1946:
1947: IF ( l_ac_termination_date is not null ) then
1948: X_org_id := pa_utils.GetEmpOrgId( X_person_id, l_ac_termination_date);
1949: ELSE
1950: X_org_id := pa_utils.GetEmpOrgId( X_person_id, X_ei_date );
1951: END IF;
1952: /* Added for Bug#4604614 (BaseBug#4118885) -- End */

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

1946:
1947: IF ( l_ac_termination_date is not null ) then
1948: X_org_id := pa_utils.GetEmpOrgId( X_person_id, l_ac_termination_date);
1949: ELSE
1950: X_org_id := pa_utils.GetEmpOrgId( X_person_id, X_ei_date );
1951: END IF;
1952: /* Added for Bug#4604614 (BaseBug#4118885) -- End */
1953:
1954: IF ( X_org_id IS NULL ) THEN

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

1957: END IF;
1958:
1959: IF pa_trx_import.g_skip_tc_flag <> 'Y' then /* Added for Bug # 2170237 */
1960:
1961: IF pa_utils2.CheckExporg(X_org_id,X_ei_date) = 'N' then
1962: print_message('Stage:PATC:10.12.013');
1963: return_error( 'PA_EXP_ORG_NOT_ACTIVE');
1964: END IF;
1965: END IF; /* Added for Bug # 2170237 */

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

2128: If ( (nvl(PATC.G_OVERIDE_ASSIGNMENT_ID,0) <> nvl(L_BeforeCE_AsgnId,0)) and
2129: (proj.p_assign_precedes_task = 'Y') and
2130: (X_Calling_Module <> 'PAXTREPE') ) Then
2131:
2132: PATC.G_OVERIDE_WORK_TYPE_ID := PA_UTILS4.get_work_type_id (
2133: p_project_id =>X_project_id
2134: , p_task_id =>l_task_id -- Replaced X_task_id with l_task_id for bug 16220146
2135: , p_assignment_id=>nvl(PATC.G_OVERIDE_ASSIGNMENT_ID,0) );
2136:

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

2133: p_project_id =>X_project_id
2134: , p_task_id =>l_task_id -- Replaced X_task_id with l_task_id for bug 16220146
2135: , p_assignment_id=>nvl(PATC.G_OVERIDE_ASSIGNMENT_ID,0) );
2136:
2137: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
2138: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID );
2139:
2140: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
2141: p_assignment_id =>PATC.G_OVERIDE_ASSIGNMENT_ID);

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

2136:
2137: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
2138: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID );
2139:
2140: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
2141: p_assignment_id =>PATC.G_OVERIDE_ASSIGNMENT_ID);
2142:
2143: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
2144: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID);

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

2139:
2140: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
2141: p_assignment_id =>PATC.G_OVERIDE_ASSIGNMENT_ID);
2142:
2143: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
2144: p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID);
2145:
2146: -- start of projcurrency and EI attrib changes
2147: -- Override the Billable flag if the work type biilability is enabled

Line 2154: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty

2150: /* IF Condition commented for bug#12597910 */
2151: -- IF ( nvl(P_payroll_accrual_flag,'N') <> 'Y') THEN --- Condition Added for payroll billable_flag changes for 12.2 start bug#12344689
2152: --{
2153:
2154: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty
2155: /* (p_work_type_id => p_work_type_id commented for bug 2648550 */
2156: /* Bug 2648550 used global variable in work_type_id parameter */
2157: (p_work_type_id => PATC.G_OVERIDE_WORK_TYPE_ID
2158: ,p_tc_extn_bill_flag => X_billable_flag);

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

2199:
2200: Else
2201:
2202: PATC.G_OVERIDE_WORK_TYPE_ID := p_work_type_id;
2203: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
2204: p_work_type_id => p_work_type_id);
2205: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
2206: p_assignment_id =>p_assignment_id);
2207: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(

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

2201:
2202: PATC.G_OVERIDE_WORK_TYPE_ID := p_work_type_id;
2203: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
2204: p_work_type_id => p_work_type_id);
2205: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
2206: p_assignment_id =>p_assignment_id);
2207: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
2208: p_work_type_id => p_work_type_id);
2209:

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

2203: PATC.G_OVERIDE_TP_AMT_TYPE_CODE := pa_utils4.get_tp_amt_type_code(
2204: p_work_type_id => p_work_type_id);
2205: PATC.G_OVERIDE_ASSIGNMENT_NAME := pa_utils4.get_assignment_name(
2206: p_assignment_id =>p_assignment_id);
2207: PATC.G_OVERIDE_WORK_TYPE_NAME := pa_utils4.get_work_type_name(
2208: p_work_type_id => p_work_type_id);
2209:
2210: -- start of projcurrency and EI attrib changes
2211: -- Override the Billable flag if the work type biilability is enabled

Line 2217: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty

2213:
2214: /* IF Condition commented for bug#12597910 */
2215: --IF ( nvl(P_payroll_accrual_flag,'N') <> 'Y') THEN --- Condition Added for payroll billable_flag changes for 12.2 start bug#12344689
2216: --{
2217: X_billable_flag := PA_UTILS4.get_trxn_work_billabilty
2218: (p_work_type_id => p_work_type_id
2219: ,p_tc_extn_bill_flag => X_billable_flag);
2220: --}
2221: --END IF; /* End of bug#12344689 changes */