DBA Data[Home] [Help]

APPS.HRI_OPL_DATA_SETUP_DGNSTC dependencies on HRI_BPL_DATA_SETUP_DGNSTC

Line 400: (p_results_tab IN hri_bpl_data_setup_dgnstc.data_results_tab_type) IS

396: -- PROCEDURE debug_sup_loops prints out the person details for every person
397: -- in a supervisor loop
398: -- ----------------------------------------------------------------------------
399: PROCEDURE debug_sup_loops
400: (p_results_tab IN hri_bpl_data_setup_dgnstc.data_results_tab_type) IS
401:
402: l_loop_tab hri_bpl_data_setup_dgnstc.loop_results_tab_type;
403: l_text VARCHAR2(2000);
404:

Line 402: l_loop_tab hri_bpl_data_setup_dgnstc.loop_results_tab_type;

398: -- ----------------------------------------------------------------------------
399: PROCEDURE debug_sup_loops
400: (p_results_tab IN hri_bpl_data_setup_dgnstc.data_results_tab_type) IS
401:
402: l_loop_tab hri_bpl_data_setup_dgnstc.loop_results_tab_type;
403: l_text VARCHAR2(2000);
404:
405: BEGIN
406:

Line 419: hri_bpl_data_setup_dgnstc.debug_sup_loop

415: -- Loop through instances of supervisor loops
416: FOR i IN p_results_tab.FIRST..p_results_tab.LAST LOOP
417:
418: -- Get details of supervisor loop
419: hri_bpl_data_setup_dgnstc.debug_sup_loop
420: (p_person_id => p_results_tab(i)(5),
421: p_effective_date => p_results_tab(i)(4),
422: p_loop_tab => l_loop_tab);
423:

Line 589: l_results_tab hri_bpl_data_setup_dgnstc.data_results_tab_type;

585: l_row_limit PLS_INTEGER;
586: l_count PLS_INTEGER;
587: l_previous_section VARCHAR2(240);
588: l_sql_list g_sql_tab_type;
589: l_results_tab hri_bpl_data_setup_dgnstc.data_results_tab_type;
590: l_impact BOOLEAN;
591: l_impact_msg VARCHAR2(32000);
592: l_doc_links_url VARCHAR2(32000);
593: l_subsection_code VARCHAR2(240);

Line 784: hri_bpl_data_setup_dgnstc.run_diagnostic

780: p_line_type => 'TABLE_HEADER',
781: p_col_list => l_col_list);
782:
783: -- Get the diagnostic results
784: hri_bpl_data_setup_dgnstc.run_diagnostic
785: (p_object_name => diag_rec.subsection_code,
786: p_object_type => diag_rec.section_code,
787: p_mode => p_mode,
788: p_start_date => fnd_date.canonical_to_date(p_start_date),