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.HR_CONTRACT_API dependencies on PER_CONTRACTS_F

Line 83: l_contract_id per_contracts_f.contract_id%TYPE;

79: ) is
80: --
81: -- Declare cursors and local variables
82: --
83: l_contract_id per_contracts_f.contract_id%TYPE;
84: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
85: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
86: l_effective_date date;
87: l_proc varchar2(72) := g_package||'create_contract';

Line 84: l_effective_start_date per_contracts_f.effective_start_date%TYPE;

80: --
81: -- Declare cursors and local variables
82: --
83: l_contract_id per_contracts_f.contract_id%TYPE;
84: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
85: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
86: l_effective_date date;
87: l_proc varchar2(72) := g_package||'create_contract';
88: l_object_version_number per_contracts_f.object_version_number%TYPE;

Line 85: l_effective_end_date per_contracts_f.effective_end_date%TYPE;

81: -- Declare cursors and local variables
82: --
83: l_contract_id per_contracts_f.contract_id%TYPE;
84: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
85: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
86: l_effective_date date;
87: l_proc varchar2(72) := g_package||'create_contract';
88: l_object_version_number per_contracts_f.object_version_number%TYPE;
89: l_business_group_id per_contracts_f.business_group_id%TYPE;

Line 88: l_object_version_number per_contracts_f.object_version_number%TYPE;

84: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
85: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
86: l_effective_date date;
87: l_proc varchar2(72) := g_package||'create_contract';
88: l_object_version_number per_contracts_f.object_version_number%TYPE;
89: l_business_group_id per_contracts_f.business_group_id%TYPE;
90: --
91: cursor csr_get_derived_details is
92: select per.business_group_id

Line 89: l_business_group_id per_contracts_f.business_group_id%TYPE;

85: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
86: l_effective_date date;
87: l_proc varchar2(72) := g_package||'create_contract';
88: l_object_version_number per_contracts_f.object_version_number%TYPE;
89: l_business_group_id per_contracts_f.business_group_id%TYPE;
90: --
91: cursor csr_get_derived_details is
92: select per.business_group_id
93: from per_all_people_f per

Line 509: l_object_version_number per_contracts_f.object_version_number%TYPE;

505: --
506: -- Declare cursors and local variables
507: --
508: l_proc varchar2(72) := g_package||'update_contract';
509: l_object_version_number per_contracts_f.object_version_number%TYPE;
510: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
511: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
512: l_business_group_id per_contracts_f.business_group_id%TYPE;
513:

Line 510: l_effective_start_date per_contracts_f.effective_start_date%TYPE;

506: -- Declare cursors and local variables
507: --
508: l_proc varchar2(72) := g_package||'update_contract';
509: l_object_version_number per_contracts_f.object_version_number%TYPE;
510: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
511: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
512: l_business_group_id per_contracts_f.business_group_id%TYPE;
513:
514: l_temp_ovn number := p_object_version_number;

Line 511: l_effective_end_date per_contracts_f.effective_end_date%TYPE;

507: --
508: l_proc varchar2(72) := g_package||'update_contract';
509: l_object_version_number per_contracts_f.object_version_number%TYPE;
510: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
511: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
512: l_business_group_id per_contracts_f.business_group_id%TYPE;
513:
514: l_temp_ovn number := p_object_version_number;
515: --

Line 512: l_business_group_id per_contracts_f.business_group_id%TYPE;

508: l_proc varchar2(72) := g_package||'update_contract';
509: l_object_version_number per_contracts_f.object_version_number%TYPE;
510: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
511: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
512: l_business_group_id per_contracts_f.business_group_id%TYPE;
513:
514: l_temp_ovn number := p_object_version_number;
515: --
516: cursor csr_get_derived_details is

Line 867: l_object_version_number per_contracts_f.object_version_number%TYPE;

863: --
864: -- Declare cursors and local variables
865: --
866: l_proc varchar2(72) := g_package||'update_contract';
867: l_object_version_number per_contracts_f.object_version_number%TYPE;
868: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
869: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
870:
871: l_temp_ovn number := p_object_version_number;

Line 868: l_effective_start_date per_contracts_f.effective_start_date%TYPE;

864: -- Declare cursors and local variables
865: --
866: l_proc varchar2(72) := g_package||'update_contract';
867: l_object_version_number per_contracts_f.object_version_number%TYPE;
868: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
869: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
870:
871: l_temp_ovn number := p_object_version_number;
872: --

Line 869: l_effective_end_date per_contracts_f.effective_end_date%TYPE;

865: --
866: l_proc varchar2(72) := g_package||'update_contract';
867: l_object_version_number per_contracts_f.object_version_number%TYPE;
868: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
869: l_effective_end_date per_contracts_f.effective_end_date%TYPE;
870:
871: l_temp_ovn number := p_object_version_number;
872: --
873: begin

Line 1038: FROM per_contracts_f pcf

1034: -- This procedure is called to mantain contracts when person's start-date changes
1035: --
1036: cursor csr_ctr_before IS
1037: SELECT contract_id, effective_start_date, effective_end_date, object_version_number
1038: FROM per_contracts_f pcf
1039: WHERE pcf.person_id = p_person_id
1040: AND pcf.effective_start_date < p_new_start_date
1041: ORDER BY 1,2; -- 'Order by' Added for bug#8670853
1042: --

Line 1061: FROM per_contracts_f

1057: -- and which reference a contract
1058: --
1059: cursor csr_ctr_min (p_contract_id in number) IS
1060: SELECT min(effective_start_date)
1061: FROM per_contracts_f
1062: WHERE contract_id = p_contract_id;
1063: --
1064: cursor csr_ctr_ovn (p_contract_id in number, p_start_date in date) IS
1065: SELECT object_version_number

Line 1066: FROM per_contracts_f

1062: WHERE contract_id = p_contract_id;
1063: --
1064: cursor csr_ctr_ovn (p_contract_id in number, p_start_date in date) IS
1065: SELECT object_version_number
1066: FROM per_contracts_f
1067: WHERE contract_id = p_contract_id and
1068: effective_start_date = p_start_date;
1069: --
1070: -- cursor for finding orphaned contracts

Line 1074: from per_contracts_f

1070: -- cursor for finding orphaned contracts
1071: --
1072: cursor csr_ctr_orphaned (p_person_id in number) is
1073: select contract_id, effective_start_date, object_version_number
1074: from per_contracts_f
1075: where person_id = p_person_id
1076: and not exists(select 1 from per_all_people_f
1077: where person_id = p_person_id);
1078: --

Line 1079: l_contract_id per_contracts_f.contract_id%TYPE;

1075: where person_id = p_person_id
1076: and not exists(select 1 from per_all_people_f
1077: where person_id = p_person_id);
1078: --
1079: l_contract_id per_contracts_f.contract_id%TYPE;
1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1081: l_start_date per_contracts_f.effective_start_date%TYPE;
1082: l_end_date per_contracts_f.effective_end_date%TYPE;
1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;

Line 1081: l_start_date per_contracts_f.effective_start_date%TYPE;

1077: where person_id = p_person_id);
1078: --
1079: l_contract_id per_contracts_f.contract_id%TYPE;
1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1081: l_start_date per_contracts_f.effective_start_date%TYPE;
1082: l_end_date per_contracts_f.effective_end_date%TYPE;
1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
1084: l_object_version_number per_contracts_f.object_version_number%TYPE;
1085: l_proc varchar2(72) := g_package||'maintain_contracts';

Line 1082: l_end_date per_contracts_f.effective_end_date%TYPE;

1078: --
1079: l_contract_id per_contracts_f.contract_id%TYPE;
1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1081: l_start_date per_contracts_f.effective_start_date%TYPE;
1082: l_end_date per_contracts_f.effective_end_date%TYPE;
1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
1084: l_object_version_number per_contracts_f.object_version_number%TYPE;
1085: l_proc varchar2(72) := g_package||'maintain_contracts';
1086: --Added below variables for bug#8670853

Line 1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;

1079: l_contract_id per_contracts_f.contract_id%TYPE;
1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1081: l_start_date per_contracts_f.effective_start_date%TYPE;
1082: l_end_date per_contracts_f.effective_end_date%TYPE;
1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
1084: l_object_version_number per_contracts_f.object_version_number%TYPE;
1085: l_proc varchar2(72) := g_package||'maintain_contracts';
1086: --Added below variables for bug#8670853
1087: l_contract_start_date per_contracts_f.effective_start_date%TYPE;

Line 1084: l_object_version_number per_contracts_f.object_version_number%TYPE;

1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1081: l_start_date per_contracts_f.effective_start_date%TYPE;
1082: l_end_date per_contracts_f.effective_end_date%TYPE;
1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
1084: l_object_version_number per_contracts_f.object_version_number%TYPE;
1085: l_proc varchar2(72) := g_package||'maintain_contracts';
1086: --Added below variables for bug#8670853
1087: l_contract_start_date per_contracts_f.effective_start_date%TYPE;
1088: l_temp varchar2(1);

Line 1087: l_contract_start_date per_contracts_f.effective_start_date%TYPE;

1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
1084: l_object_version_number per_contracts_f.object_version_number%TYPE;
1085: l_proc varchar2(72) := g_package||'maintain_contracts';
1086: --Added below variables for bug#8670853
1087: l_contract_start_date per_contracts_f.effective_start_date%TYPE;
1088: l_temp varchar2(1);
1089: l_prev_con_num per_contracts_f.contract_id%TYPE;
1090: --
1091: BEGIN

Line 1089: l_prev_con_num per_contracts_f.contract_id%TYPE;

1085: l_proc varchar2(72) := g_package||'maintain_contracts';
1086: --Added below variables for bug#8670853
1087: l_contract_start_date per_contracts_f.effective_start_date%TYPE;
1088: l_temp varchar2(1);
1089: l_prev_con_num per_contracts_f.contract_id%TYPE;
1090: --
1091: BEGIN
1092: --
1093: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1298: from per_contracts_f pcf1

1294: p_effective_date in date,
1295: p_status in varchar2) return date is
1296:
1297: cursor csr_date_active is select min(pcf1.effective_start_date)
1298: from per_contracts_f pcf1
1299: where p_contract_id=pcf1.contract_id
1300: and p_effective_date >= pcf1.effective_start_date
1301: and pcf1.status like 'A-%';
1302:

Line 1304: from per_contracts_f pcf1

1300: and p_effective_date >= pcf1.effective_start_date
1301: and pcf1.status like 'A-%';
1302:
1303: cursor csr_date_other is select max(pcf1.effective_end_date) + 1
1304: from per_contracts_f pcf1
1305: where p_contract_id=pcf1.contract_id
1306: and p_effective_date >= pcf1.effective_end_date
1307: and pcf1.status not like 'A-%';
1308:

Line 1311: from per_contracts_f pcf1

1307: and pcf1.status not like 'A-%';
1308:
1309:
1310: cursor csr_prev_date_active is select max(pcf1.effective_start_date)
1311: from per_contracts_f pcf1
1312: where p_contract_id=pcf1.contract_id
1313: and p_effective_date > pcf1.effective_start_date
1314: and pcf1.status like 'A-%';
1315:

Line 1318: l_other_start_date per_contracts_f.EFFECTIVE_END_DATE%type;

1314: and pcf1.status like 'A-%';
1315:
1316: -- set up the variables
1317:
1318: l_other_start_date per_contracts_f.EFFECTIVE_END_DATE%type;
1319: l_active_start_date per_contracts_f.EFFECTIVE_START_DATE%type;
1320: l_prev_start_date per_contracts_f.EFFECTIVE_START_DATE%type;
1321:
1322:

Line 1319: l_active_start_date per_contracts_f.EFFECTIVE_START_DATE%type;

1315:
1316: -- set up the variables
1317:
1318: l_other_start_date per_contracts_f.EFFECTIVE_END_DATE%type;
1319: l_active_start_date per_contracts_f.EFFECTIVE_START_DATE%type;
1320: l_prev_start_date per_contracts_f.EFFECTIVE_START_DATE%type;
1321:
1322:
1323: begin

Line 1320: l_prev_start_date per_contracts_f.EFFECTIVE_START_DATE%type;

1316: -- set up the variables
1317:
1318: l_other_start_date per_contracts_f.EFFECTIVE_END_DATE%type;
1319: l_active_start_date per_contracts_f.EFFECTIVE_START_DATE%type;
1320: l_prev_start_date per_contracts_f.EFFECTIVE_START_DATE%type;
1321:
1322:
1323: begin
1324:

Line 1360: from per_contracts_f pcf1

1356: p_effective_date in date,
1357: p_status in varchar2) return date is
1358:
1359: cursor csr_date_active is select max(pcf1.effective_end_date)
1360: from per_contracts_f pcf1
1361: where p_contract_id = pcf1.contract_id
1362: and p_effective_date <= pcf1.effective_end_date
1363: and pcf1.status like 'A-%';
1364:

Line 1366: from per_contracts_f pcf1

1362: and p_effective_date <= pcf1.effective_end_date
1363: and pcf1.status like 'A-%';
1364:
1365: cursor csr_date_other is select min(pcf1.effective_start_date) - 1
1366: from per_contracts_f pcf1
1367: where p_contract_id=pcf1.contract_id
1368: and p_effective_date <=pcf1.effective_start_date
1369: and pcf1.status not like 'A-%';
1370:

Line 1372: from per_contracts_f pcf1

1368: and p_effective_date <=pcf1.effective_start_date
1369: and pcf1.status not like 'A-%';
1370:
1371: cursor csr_prev_date_active is select max(pcf1.effective_end_date)
1372: from per_contracts_f pcf1
1373: where p_contract_id = pcf1.contract_id
1374: and p_effective_date > pcf1.effective_end_date
1375: and pcf1.status like 'A-%';
1376:

Line 1380: l_other_end_date per_contracts_f.EFFECTIVE_END_DATE%type;

1376:
1377:
1378: -- set up the variables
1379:
1380: l_other_end_date per_contracts_f.EFFECTIVE_END_DATE%type;
1381: l_active_end_date per_contracts_f.EFFECTIVE_START_DATE%type;
1382: l_prev_end_date per_contracts_f.EFFECTIVE_START_DATE%type;
1383:
1384:

Line 1381: l_active_end_date per_contracts_f.EFFECTIVE_START_DATE%type;

1377:
1378: -- set up the variables
1379:
1380: l_other_end_date per_contracts_f.EFFECTIVE_END_DATE%type;
1381: l_active_end_date per_contracts_f.EFFECTIVE_START_DATE%type;
1382: l_prev_end_date per_contracts_f.EFFECTIVE_START_DATE%type;
1383:
1384:
1385: begin

Line 1382: l_prev_end_date per_contracts_f.EFFECTIVE_START_DATE%type;

1378: -- set up the variables
1379:
1380: l_other_end_date per_contracts_f.EFFECTIVE_END_DATE%type;
1381: l_active_end_date per_contracts_f.EFFECTIVE_START_DATE%type;
1382: l_prev_end_date per_contracts_f.EFFECTIVE_START_DATE%type;
1383:
1384:
1385: begin
1386: