APPS.PER_CAGR_EVALUATION_PKG dependencies on PER_CAGR_ENTITLEMENT_RESULTS_S

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 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 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