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.PAY_FI_GENERAL dependencies on FND_DATE

Line 158: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

154: close csr_get_formula_id;
155: l_inputs(1).name := 'ASSIGNMENT_ID';
156: l_inputs(1).value := p_assignment_id;
157: l_inputs(2).name := 'DATE_EARNED';
158: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
159: l_inputs(3).name := 'BUSINESS_GROUP_ID';
160: l_inputs(3).value := p_business_group_id;
161: l_inputs(4).name := 'PAYROLL_ID';
162: l_inputs(4).value := p_payroll_id;

Line 176: l_inputs(11).value := fnd_date.date_to_canonical(p_balance_date);

172: l_inputs(9).value := p_element_type_id;
173: l_inputs(10).name := 'ORIGINAL_ENTRY_ID';
174: l_inputs(10).value := p_original_entry_id;
175: l_inputs(11).name := 'BALANCE_DATE';
176: l_inputs(11).value := fnd_date.date_to_canonical(p_balance_date);
177:
178: l_outputs(1).name := 'HOLIDAY_DAYS';
179: l_outputs(2).name := 'HOLIDAY_COMPENSATION';
180: l_outputs(3).name := 'HOLIDAY_PAY_RESERVE';

Line 371: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

367: close csr_get_formula_id;
368: l_inputs(1).name := 'ASSIGNMENT_ID';
369: l_inputs(1).value := p_assignment_id;
370: l_inputs(2).name := 'DATE_EARNED';
371: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
372: l_inputs(3).name := 'BUSINESS_GROUP_ID';
373: l_inputs(3).value := p_business_group_id;
374: l_inputs(4).name := 'PAYROLL_ID';
375: l_inputs(4).value := p_payroll_id;

Line 389: l_inputs(11).value := fnd_date.date_to_canonical(p_balance_date);

385: l_inputs(9).value := p_element_type_id;
386: l_inputs(10).name := 'ORIGINAL_ENTRY_ID';
387: l_inputs(10).value := p_original_entry_id;
388: l_inputs(11).name := 'BALANCE_DATE';
389: l_inputs(11).value := fnd_date.date_to_canonical(p_balance_date);
390:
391: l_outputs(1).name := 'SUMMER_HOLIDAY_DAYS';
392: l_outputs(2).name := 'WINTER_HOLIDAY_DAYS';
393: l_outputs(3).name := 'HOLIDAY_PAY';

Line 862: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

858: close csr_get_formula_id;
859: l_inputs(1).name := 'ASSIGNMENT_ID';
860: l_inputs(1).value := p_assignment_id;
861: l_inputs(2).name := 'DATE_EARNED';
862: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
863: l_inputs(3).name := 'BUSINESS_GROUP_ID';
864: l_inputs(3).value := p_business_group_id;
865: l_inputs(4).name := 'PAYROLL_ID';
866: l_inputs(4).value := p_payroll_id;

Line 1044: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND

1040: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1041: AND hoi1.org_information_context = 'CLASS'
1042: AND o1.organization_id =hoi2.organization_id
1043: AND hoi2.ORG_INFORMATION_CONTEXT='FI_ACCIDENT_PROVIDERS'
1044: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1045: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1046:
1047:
1048: BEGIN

Line 1045: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;

1041: AND hoi1.org_information_context = 'CLASS'
1042: AND o1.organization_id =hoi2.organization_id
1043: AND hoi2.ORG_INFORMATION_CONTEXT='FI_ACCIDENT_PROVIDERS'
1044: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1045: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1046:
1047:
1048: BEGIN
1049:

Line 1098: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND

1094: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1095: AND hoi1.org_information_context = 'CLASS'
1096: AND o1.organization_id =hoi2.organization_id
1097: AND hoi2.ORG_INFORMATION_CONTEXT='FI_ACCIDENT_PROVIDERS'
1098: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1099: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1100:
1101:
1102: CURSOR c_lc_accident_insurance_info( p_business_group_id NUMBER , p_local_unit_id NUMBER , p_effective_date DATE ) IS

Line 1099: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;

1095: AND hoi1.org_information_context = 'CLASS'
1096: AND o1.organization_id =hoi2.organization_id
1097: AND hoi2.ORG_INFORMATION_CONTEXT='FI_ACCIDENT_PROVIDERS'
1098: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1099: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1100:
1101:
1102: CURSOR c_lc_accident_insurance_info( p_business_group_id NUMBER , p_local_unit_id NUMBER , p_effective_date DATE ) IS
1103: SELECT hoi2.org_information4 org_information4

Line 1114: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND

1110: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'
1111: AND hoi1.org_information_context = 'CLASS'
1112: AND o1.organization_id =hoi2.organization_id
1113: AND hoi2.ORG_INFORMATION_CONTEXT='FI_LU_ACCIDENT_PROVIDERS'
1114: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1115: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1116:
1117: BEGIN
1118: l_local_unit := get_local_unit( p_assignment_id , p_effective_date) ;

Line 1115: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;

1111: AND hoi1.org_information_context = 'CLASS'
1112: AND o1.organization_id =hoi2.organization_id
1113: AND hoi2.ORG_INFORMATION_CONTEXT='FI_LU_ACCIDENT_PROVIDERS'
1114: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1115: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1116:
1117: BEGIN
1118: l_local_unit := get_local_unit( p_assignment_id , p_effective_date) ;
1119:

Line 1189: AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(per.per_information14),to_date('01/01/0001','DD/MM/YYYY'))

1185: WHERE asg1.assignment_id = p_assignment_id
1186: AND per.person_id = asg1.person_id
1187: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1188: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
1189: AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(per.per_information14),to_date('01/01/0001','DD/MM/YYYY'))
1190: AND nvl(fnd_date.canonical_to_date(per.per_information20),to_date('31/12/4712','DD/MM/YYYY'));
1191:
1192: CURSOR c_pension_provider_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_pension_num VARCHAR2 , p_effective_date DATE) IS
1193: SELECT NVL(hoi2.org_information4,0 ) org_information4 , NVL(hoi2.org_information7,0 ) org_information7

Line 1190: AND nvl(fnd_date.canonical_to_date(per.per_information20),to_date('31/12/4712','DD/MM/YYYY'));

1186: AND per.person_id = asg1.person_id
1187: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1188: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
1189: AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(per.per_information14),to_date('01/01/0001','DD/MM/YYYY'))
1190: AND nvl(fnd_date.canonical_to_date(per.per_information20),to_date('31/12/4712','DD/MM/YYYY'));
1191:
1192: CURSOR c_pension_provider_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_pension_num VARCHAR2 , p_effective_date DATE) IS
1193: SELECT NVL(hoi2.org_information4,0 ) org_information4 , NVL(hoi2.org_information7,0 ) org_information7
1194: FROM hr_organization_units o1

Line 1205: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND

1201: AND hoi1.org_information_context = 'CLASS'
1202: AND o1.organization_id =hoi2.organization_id
1203: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
1204: AND hoi2.org_information6 = p_pension_num
1205: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1206: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))
1207: AND hoi2.org_information6 IN
1208: (
1209: SELECT NVL(hoi2.org_information1,0 )

Line 1206: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))

1202: AND o1.organization_id =hoi2.organization_id
1203: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
1204: AND hoi2.org_information6 = p_pension_num
1205: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
1206: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))
1207: AND hoi2.org_information6 IN
1208: (
1209: SELECT NVL(hoi2.org_information1,0 )
1210: FROM hr_organization_units o1

Line 1288: l_return_value :=fnd_date.canonical_to_date('4712/12/31 00:00:00');

1284: OPEN c_retire_date ;
1285: FETCH c_retire_date INTO l_retire_date;
1286: CLOSE c_retire_date;
1287: IF l_retire_date IS NULL THEN
1288: l_return_value :=fnd_date.canonical_to_date('4712/12/31 00:00:00');
1289: ELSE
1290: l_return_value :=fnd_date.canonical_to_date(l_retire_date);
1291: END IF;
1292: RETURN l_return_value;

Line 1290: l_return_value :=fnd_date.canonical_to_date(l_retire_date);

1286: CLOSE c_retire_date;
1287: IF l_retire_date IS NULL THEN
1288: l_return_value :=fnd_date.canonical_to_date('4712/12/31 00:00:00');
1289: ELSE
1290: l_return_value :=fnd_date.canonical_to_date(l_retire_date);
1291: END IF;
1292: RETURN l_return_value;
1293: EXCEPTION
1294: WHEN OTHERS THEN

Line 1295: l_return_value :=fnd_date.canonical_to_date('4712/12/31 00:00:00');

1291: END IF;
1292: RETURN l_return_value;
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: l_return_value :=fnd_date.canonical_to_date('4712/12/31 00:00:00');
1296: RETURN l_return_value;
1297:
1298: END ;
1299:

Line 1375: ,p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(p_Session_Date)

1371: ,p_pei_information3 =>p_COLUMN_NAME
1372: ,p_pei_information4 => p_new_value
1373: ,p_pei_information5 =>'N'
1374: ,p_pei_information6 =>'I'
1375: ,p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(p_Session_Date)
1376: ,p_person_extra_info_id =>L_person_extra_info_id
1377: ,p_object_version_number =>L_OVN
1378: ) ;
1379: hr_utility.trace('p_person_extra_info_id Created ==> ' ||L_person_extra_info_id );

Line 1411: p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(p_Session_Date)

1407: -- p_pei_information3 => lr_PERSON_EIT.pei_information3,
1408: p_pei_information4 => p_new_value,
1409: p_pei_information5 => 'N',
1410: p_pei_information6 => l_Action,
1411: p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(p_Session_Date)
1412: );
1413:
1414: ELSE
1415:

Line 1429: p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(p_Session_Date)

1425: -- p_pei_information3 => lr_PERSON_EIT.pei_information3,
1426: -- p_pei_information4 => p_new_value,
1427: p_pei_information5 => 'N',
1428: p_pei_information6 => l_Action,
1429: p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(p_Session_Date)
1430: );
1431: ELSE
1432: hr_person_extra_info_api.update_person_extra_info
1433: (

Line 1513: IF(FND_DATE.CANONICAL_to_date(p_new_PENSION_JOINING_DATE)=

1509: THEN
1510: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_JOINING_DATE,p_Session_Date,'Pension Joining Date','INSERT');
1511: ELSIF (p_new_PENSION_JOINING_DATE IS NOT null or p_old_PENSION_JOINING_DATE IS NOT null )
1512: THEN
1513: IF(FND_DATE.CANONICAL_to_date(p_new_PENSION_JOINING_DATE)=
1514: FND_DATE.CANONICAL_to_date(p_old_PENSION_JOINING_DATE))
1515: THEN
1516: hr_utility.trace('In Equals for Pension Date');
1517: ELSE

Line 1514: FND_DATE.CANONICAL_to_date(p_old_PENSION_JOINING_DATE))

1510: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_JOINING_DATE,p_Session_Date,'Pension Joining Date','INSERT');
1511: ELSIF (p_new_PENSION_JOINING_DATE IS NOT null or p_old_PENSION_JOINING_DATE IS NOT null )
1512: THEN
1513: IF(FND_DATE.CANONICAL_to_date(p_new_PENSION_JOINING_DATE)=
1514: FND_DATE.CANONICAL_to_date(p_old_PENSION_JOINING_DATE))
1515: THEN
1516: hr_utility.trace('In Equals for Pension Date');
1517: ELSE
1518: hr_utility.trace('Calling the Column update ');