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 1065: update per_cagr_entitlement_results set end_date = p_params.effective_date -1

1061: open csr_item_results;
1062: fetch csr_item_results into v_start_date, v_delete_cagr_request_id;
1063: if v_start_date < p_params.effective_date then
1064: -- end date the record, and all others
1065: update per_cagr_entitlement_results set end_date = p_params.effective_date -1
1066: where current of csr_item_results;
1067: loop
1068: fetch csr_item_results into v_start_date, v_cagr_request_id;
1069: exit when csr_item_results%notfound;

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

1066: where current of csr_item_results;
1067: loop
1068: fetch csr_item_results into v_start_date, v_cagr_request_id;
1069: exit when csr_item_results%notfound;
1070: update per_cagr_entitlement_results set end_date = p_params.effective_date -1
1071: where current of csr_item_results;
1072: end loop;
1073: elsif v_start_date = p_params.effective_date then
1074: -- delete records which started today

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

1121: fetch csr_all_results into v_start_date, v_cagr_request_id;
1122: exit when csr_all_results%notfound;
1123: if v_start_date < p_params.effective_date then
1124: -- end date the record, and all others
1125: update per_cagr_entitlement_results set end_date = p_params.effective_date -1
1126: where current of csr_all_results;
1127: elsif v_start_date = p_params.effective_date then
1128: -- delete records which started today, and store the request_id
1129: delete from per_cagr_entitlement_results