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.PER_CAGR_EVALUATION_PKG dependencies on PER_CAGR_ENTITLEMENT_RESULTS

Line 37: TYPE results_table IS TABLE OF PER_CAGR_ENTITLEMENT_RESULTS%ROWTYPE

33:
34: TYPE eligibility_table IS TABLE OF eligibility_rec
35: INDEX BY BINARY_INTEGER;
36:
37: TYPE results_table IS TABLE OF PER_CAGR_ENTITLEMENT_RESULTS%ROWTYPE
38: INDEX BY BINARY_INTEGER;
39:
40: TYPE cagr_asg_table IS TABLE OF cagr_asg_rec
41: INDEX BY BINARY_INTEGER;

Line 150: FROM per_all_assignments_f asg, per_cagr_entitlement_results res

146: ,res.FROM_STEP_ID
147: ,res.TO_STEP_ID
148: ,res.CHOSEN_FLAG
149: ,res.BENEFICIAL_FLAG
150: FROM per_all_assignments_f asg, per_cagr_entitlement_results res
151: WHERE asg.assignment_id = res.assignment_id
152: AND asg.primary_flag = 'Y'
153: AND p_process_date between asg.effective_start_date and asg.effective_end_date
154: AND res.cagr_entitlement_item_id = p_entitlement_item_id

Line 618: FROM per_cagr_entitlement_results res

614: value,
615: grade_spine_id,
616: parent_spine_id,
617: step_id
618: FROM per_cagr_entitlement_results res
619: WHERE res.assignment_id = p_assignment_id
620: AND p_effective_date between res.START_DATE and nvl(res.END_DATE, hr_general.end_of_time)
621: AND chosen_flag = 'Y';
622:

Line 742: FROM per_cagr_entitlement_results erl

738: ,erl.STEP_ID
739: ,erl.FROM_STEP_ID
740: ,erl.TO_STEP_ID
741: ,erl.BENEFICIAL_FLAG
742: FROM per_cagr_entitlement_results erl
743: WHERE erl.ASSIGNMENT_ID = p_assignment_id
744: AND erl.COLLECTIVE_AGREEMENT_ID = p_cagr_id
745: AND erl.CAGR_ENTITLEMENT_ITEM_ID = p_entitlement_item_id
746: AND p_effective_date BETWEEN erl.START_DATE

Line 750: l_beneficial_flag per_cagr_entitlement_results.beneficial_flag%TYPE;

746: AND p_effective_date BETWEEN erl.START_DATE
747: AND nvl(erl.END_DATE,hr_general.end_of_time);
748:
749: l_rec cagr_SE_record;
750: l_beneficial_flag per_cagr_entitlement_results.beneficial_flag%TYPE;
751: l_no_results BOOLEAN := TRUE;
752: l_proc constant VARCHAR2(61) := g_pkg || '.check_cache';
753:
754: BEGIN

Line 837: -- loop through it writing each record to the PER_CAGR_ENTITLEMENT_RESULTS table

833: ,p_effective_date IN DATE
834: ,p_end_date IN DATE) IS
835:
836: -- Accept a structure containing processed entitlement results and
837: -- loop through it writing each record to the PER_CAGR_ENTITLEMENT_RESULTS table
838: -- inserting a new key value for each record from sequence.
839: -- (could use bulk binding of index-by table of records in 9i, to aid performance).
840: -- NOTE: called from insert_result_set, update_result_set
841:

Line 852: INSERT INTO per_cagr_entitlement_results(CAGR_ENTITLEMENT_RESULT_ID

848: hr_utility.set_location('Entering:'||l_proc, 10);
849:
850: FOR i in p_structure.FIRST..p_structure.LAST LOOP
851: -- write detail records to table
852: INSERT INTO per_cagr_entitlement_results(CAGR_ENTITLEMENT_RESULT_ID
853: ,CAGR_REQUEST_ID
854: ,START_DATE
855: ,END_DATE
856: ,COLLECTIVE_AGREEMENT_ID

Line 887: VALUES (PER_CAGR_ENTITLEMENT_RESULTS_S.nextval

883: ,BUSINESS_GROUP_ID
884: ,FLEX_VALUE_SET_ID
885: ,RETAINED_ENT_RESULT_ID
886: ,OBJECT_VERSION_NUMBER)
887: VALUES (PER_CAGR_ENTITLEMENT_RESULTS_S.nextval
888: ,p_cagr_request_id
889: ,p_effective_date
890: ,p_end_date
891: ,p_structure(i).COLLECTIVE_AGREEMENT_ID

Line 954: FROM per_cagr_entitlement_results er

950: -- test if any future result(s) exists for the item
951: -- and return the start_date of earliest future result set
952: CURSOR csr_future_results IS
953: SELECT min(er.start_date)
954: FROM per_cagr_entitlement_results er
955: WHERE er.cagr_entitlement_item_id = p_params.entitlement_item_id
956: AND er.assignment_id = p_params.assignment_id
957: AND p_params.effective_date < er.START_DATE;
958:

Line 1012: FROM pay_element_entries_f ee,per_cagr_entitlement_results cer

1008:
1009: -- Bug 14096456
1010: CURSOR csr_invalid_element_entries(p_assignment_id NUMBER, p_element_type_id NUMBER) IS
1011: SELECT ee.element_entry_id,ee.object_version_number
1012: FROM pay_element_entries_f ee,per_cagr_entitlement_results cer
1013: WHERE ee.assignment_id = p_assignment_id
1014: AND ee.assignment_id = cer.assignment_id
1015: AND ee.element_type_id = cer.element_type_id
1016: AND ee.effective_start_date = p_params.effective_date

Line 1024: FROM per_cagr_entitlement_results er

1020: -- taking exclusive lock out, with nowait, will hang until rows is freed,
1021: -- but this is NOT used by 'SE' mode
1022: CURSOR csr_all_results (v_assignment_id in number) IS
1023: SELECT er.start_date, er.cagr_request_id, er.element_type_id
1024: FROM per_cagr_entitlement_results er
1025: WHERE er.assignment_id = v_assignment_id
1026: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)
1027: ORDER BY er.cagr_request_id
1028: FOR UPDATE OF END_DATE NOWAIT;

Line 1034: FROM per_cagr_entitlement_results er

1030: -- update all results for a specific item found in cache
1031: -- taking exclusive lock out - used by SE mode only, so uses param and nowait option
1032: CURSOR csr_item_results IS
1033: SELECT er.start_date, er.cagr_request_id
1034: FROM per_cagr_entitlement_results er
1035: WHERE er.assignment_id = p_params.assignment_id
1036: AND er.cagr_entitlement_item_id = p_params.entitlement_item_id
1037: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)
1038: FOR UPDATE OF END_DATE NOWAIT;

Line 1045: FROM per_cagr_entitlement_results er

1041: -- and return the start_date of earliest future result set
1042: CURSOR csr_future_results (v_entitlement_item_id in NUMBER
1043: ,v_assignment_id in NUMBER) IS
1044: SELECT min(er.start_date)
1045: FROM per_cagr_entitlement_results er
1046: WHERE er.cagr_entitlement_item_id = v_entitlement_item_id
1047: AND er.assignment_id = v_assignment_id
1048: AND p_params.effective_date < er.START_DATE;
1049:

Line 1050: TYPE request_table IS TABLE OF per_cagr_entitlement_results.cagr_request_id%TYPE INDEX BY BINARY_INTEGER;

1046: WHERE er.cagr_entitlement_item_id = v_entitlement_item_id
1047: AND er.assignment_id = v_assignment_id
1048: AND p_params.effective_date < er.START_DATE;
1049:
1050: TYPE request_table IS TABLE OF per_cagr_entitlement_results.cagr_request_id%TYPE INDEX BY BINARY_INTEGER;
1051:
1052: e_resource_busy exception;
1053: pragma exception_init(e_resource_busy,-00054);
1054:

Line 1084: update per_cagr_entitlement_results set end_date = p_params.effective_date -1

1080: open csr_item_results;
1081: fetch csr_item_results into v_start_date, v_delete_cagr_request_id;
1082: if v_start_date < p_params.effective_date then
1083: -- end date the record, and all others
1084: update per_cagr_entitlement_results set end_date = p_params.effective_date -1
1085: where current of csr_item_results;
1086: loop
1087: fetch csr_item_results into v_start_date, v_cagr_request_id;
1088: exit when csr_item_results%notfound;

Line 1089: update per_cagr_entitlement_results set end_date = p_params.effective_date -1

1085: where current of csr_item_results;
1086: loop
1087: fetch csr_item_results into v_start_date, v_cagr_request_id;
1088: exit when csr_item_results%notfound;
1089: update per_cagr_entitlement_results set end_date = p_params.effective_date -1
1090: where current of csr_item_results;
1091: end loop;
1092: elsif v_start_date = p_params.effective_date then
1093: -- delete records which started today

Line 1094: delete from per_cagr_entitlement_results

1090: where current of csr_item_results;
1091: end loop;
1092: elsif v_start_date = p_params.effective_date then
1093: -- delete records which started today
1094: delete from per_cagr_entitlement_results
1095: where current of csr_item_results;
1096: loop
1097: fetch csr_item_results into v_start_date, v_cagr_request_id;
1098: exit when csr_item_results%notfound;

Line 1100: delete from per_cagr_entitlement_results

1096: loop
1097: fetch csr_item_results into v_start_date, v_cagr_request_id;
1098: exit when csr_item_results%notfound;
1099:
1100: delete from per_cagr_entitlement_results
1101: where current of csr_item_results;
1102: end loop;
1103: -- as we have deleted an entitlement result, also delete any
1104: -- log entries, for the results request_id.

Line 1144: update per_cagr_entitlement_results set end_date = p_params.effective_date -1

1140: fetch csr_all_results into v_start_date, v_cagr_request_id, v_element_type_id;
1141: exit when csr_all_results%notfound;
1142: if v_start_date < p_params.effective_date then
1143: -- end date the record, and all others
1144: update per_cagr_entitlement_results set end_date = p_params.effective_date -1
1145: where current of csr_all_results;
1146: elsif v_start_date = p_params.effective_date then
1147:
1148: -- Bug 12621959

Line 1164: delete from per_cagr_entitlement_results

1160: end if;
1161: close csr_invalid_element_entries;
1162:
1163: -- delete records which started today, and store the request_id
1164: delete from per_cagr_entitlement_results
1165: where current of csr_all_results;
1166: if v_delete_cagr_request_id is null then
1167: v_delete_cagr_request_id := v_cagr_request_id;
1168: i := i + 1;

Line 1197: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_results');

1193: -- raise resource busy message.
1194: per_cagr_utility_pkg.put_log(' ERROR: Another user is updating the entitlement results for the assignment.',1);
1195: per_cagr_utility_pkg.put_log(' Unable to lock result records exclusively. Please try again later.',1);
1196: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1197: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_results');
1198: fnd_message.raise_error;
1199:
1200: END update_result_set;
1201:

Line 3039: per_cagr_utility_pkg.put_log(' WARNING: unable to obtain exclusive lock on per_cagr_entitlement_results');

3035: p_SE_rec.ERROR := NULL; -- do not return this error
3036: end if;
3037: EXCEPTION
3038: when resource_busy then
3039: per_cagr_utility_pkg.put_log(' WARNING: unable to obtain exclusive lock on per_cagr_entitlement_results');
3040: per_cagr_utility_pkg.put_log(' Cache was not updated with results, continuing...');
3041: -- but this is not fatal in this mode, so continue and pass out results
3042: END;
3043: else -- not updating the cache, but we have regenerated data so nullify this error now