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.GHR_BREAKDOWN_RPT dependencies on GHR_BREAKDOWN_RESULTS

Line 468: DELETE FROM GHR_BREAKDOWN_RESULTS WHERE session_id = USERENV('SESSIONID');

464: END;
465:
466: PROCEDURE Delete_Temp_Data IS
467: BEGIN
468: DELETE FROM GHR_BREAKDOWN_RESULTS WHERE session_id = USERENV('SESSIONID');
469: END;
470:
471: PROCEDURE process(p_breakdown_criteria_id IN NUMBER := NULL) IS
472: CURSOR c_emp IS

Line 490: -- Information to be inserted in GHR_BREAKDOWN_RESULTS

486: r_GRP1 per_people_extra_info%rowtype;
487: r_ASG per_all_assignments_f%rowtype;
488: l_result VARCHAR2(80);
489:
490: -- Information to be inserted in GHR_BREAKDOWN_RESULTS
491: l_rslt_session_id ghr_breakdown_results.session_id%TYPE := USERENV('SESSIONID');
492: l_rslt_id ghr_breakdown_results.breakdown_result_id%TYPE;
493: l_rslt_for_clause ghr_breakdown_results.for_clause%TYPE;
494: l_rslt_within_clause ghr_breakdown_results.within_clause%TYPE;

Line 491: l_rslt_session_id ghr_breakdown_results.session_id%TYPE := USERENV('SESSIONID');

487: r_ASG per_all_assignments_f%rowtype;
488: l_result VARCHAR2(80);
489:
490: -- Information to be inserted in GHR_BREAKDOWN_RESULTS
491: l_rslt_session_id ghr_breakdown_results.session_id%TYPE := USERENV('SESSIONID');
492: l_rslt_id ghr_breakdown_results.breakdown_result_id%TYPE;
493: l_rslt_for_clause ghr_breakdown_results.for_clause%TYPE;
494: l_rslt_within_clause ghr_breakdown_results.within_clause%TYPE;
495: l_rslt_by_clause ghr_breakdown_results.by_clause%TYPE;

Line 492: l_rslt_id ghr_breakdown_results.breakdown_result_id%TYPE;

488: l_result VARCHAR2(80);
489:
490: -- Information to be inserted in GHR_BREAKDOWN_RESULTS
491: l_rslt_session_id ghr_breakdown_results.session_id%TYPE := USERENV('SESSIONID');
492: l_rslt_id ghr_breakdown_results.breakdown_result_id%TYPE;
493: l_rslt_for_clause ghr_breakdown_results.for_clause%TYPE;
494: l_rslt_within_clause ghr_breakdown_results.within_clause%TYPE;
495: l_rslt_by_clause ghr_breakdown_results.by_clause%TYPE;
496:

Line 493: l_rslt_for_clause ghr_breakdown_results.for_clause%TYPE;

489:
490: -- Information to be inserted in GHR_BREAKDOWN_RESULTS
491: l_rslt_session_id ghr_breakdown_results.session_id%TYPE := USERENV('SESSIONID');
492: l_rslt_id ghr_breakdown_results.breakdown_result_id%TYPE;
493: l_rslt_for_clause ghr_breakdown_results.for_clause%TYPE;
494: l_rslt_within_clause ghr_breakdown_results.within_clause%TYPE;
495: l_rslt_by_clause ghr_breakdown_results.by_clause%TYPE;
496:
497: BEGIN

Line 494: l_rslt_within_clause ghr_breakdown_results.within_clause%TYPE;

490: -- Information to be inserted in GHR_BREAKDOWN_RESULTS
491: l_rslt_session_id ghr_breakdown_results.session_id%TYPE := USERENV('SESSIONID');
492: l_rslt_id ghr_breakdown_results.breakdown_result_id%TYPE;
493: l_rslt_for_clause ghr_breakdown_results.for_clause%TYPE;
494: l_rslt_within_clause ghr_breakdown_results.within_clause%TYPE;
495: l_rslt_by_clause ghr_breakdown_results.by_clause%TYPE;
496:
497: BEGIN
498: IF p_breakdown_criteria_id IS NOT NULL THEN

Line 495: l_rslt_by_clause ghr_breakdown_results.by_clause%TYPE;

491: l_rslt_session_id ghr_breakdown_results.session_id%TYPE := USERENV('SESSIONID');
492: l_rslt_id ghr_breakdown_results.breakdown_result_id%TYPE;
493: l_rslt_for_clause ghr_breakdown_results.for_clause%TYPE;
494: l_rslt_within_clause ghr_breakdown_results.within_clause%TYPE;
495: l_rslt_by_clause ghr_breakdown_results.by_clause%TYPE;
496:
497: BEGIN
498: IF p_breakdown_criteria_id IS NOT NULL THEN
499: DELETE FROM GHR_BREAKDOWN_RESULTS

Line 499: DELETE FROM GHR_BREAKDOWN_RESULTS

495: l_rslt_by_clause ghr_breakdown_results.by_clause%TYPE;
496:
497: BEGIN
498: IF p_breakdown_criteria_id IS NOT NULL THEN
499: DELETE FROM GHR_BREAKDOWN_RESULTS
500: WHERE session_id = l_rslt_session_id
501: AND breakdown_criteria_id = p_breakdown_criteria_id;
502: ELSE
503: DELETE FROM GHR_BREAKDOWN_RESULTS

Line 503: DELETE FROM GHR_BREAKDOWN_RESULTS

499: DELETE FROM GHR_BREAKDOWN_RESULTS
500: WHERE session_id = l_rslt_session_id
501: AND breakdown_criteria_id = p_breakdown_criteria_id;
502: ELSE
503: DELETE FROM GHR_BREAKDOWN_RESULTS
504: WHERE session_id = l_rslt_session_id;
505: END IF;
506: l_rslt_id := 0;
507: FOR r_emp IN c_emp LOOP

Line 520: INSERT INTO ghr_breakdown_results

516: l_rslt_for_clause := get_hierarchy_codes(r_emp.ASG_rowid, l_effective_date, 'PARENTS');
517: END IF;
518: l_rslt_within_clause := Any_Clause(l_within_clause, r_emp.PER_rowid, r_GRP1, r_ASG);
519: l_rslt_by_clause := Any_Clause(l_by_clause, r_emp.PER_rowid, r_GRP1, r_ASG);
520: INSERT INTO ghr_breakdown_results
521: (session_id, breakdown_result_id, breakdown_criteria_id, for_clause, within_clause,
522: by_clause, sex, ethnic_origin)
523: VALUES
524: (l_rslt_session_id, l_rslt_id, p_breakdown_criteria_id, l_rslt_for_clause,