[Home] [Help]
27: --
28: CURSOR cur_chk_object
29: IS
30: SELECT 1
31: FROM hri_adm_dgnstc_setup
32: WHERE object_name = p_object_name
33: AND object_type = p_object_type;
34: --
35: BEGIN
431: check_message(p_null_impact_msg_name);
432: --
433: -- Insert into the diagnostic meta data table
434: --
435: INSERT INTO hri_adm_dgnstc_setup
436: (object_name,
437: object_type,
438: dynamic_sql,
439: dynamic_sql_type,
499: check_message(p_valid_status_msg_cd);
500: --
501: -- Insert into the diagnostic metadata table
502: --
503: INSERT INTO hri_adm_dgnstc_setup
504: (object_name,
505: object_type,
506: exception_status_msg_cd,
507: valid_status_msg_cd,
561: --
562: --
563: -- Insert into the diagnostic metacata table
564: --
565: INSERT INTO hri_adm_dgnstc_setup
566: (object_name,
567: object_type,
568: exception_status_msg_cd,
569: valid_status_msg_cd,
621: check_message(p_valid_status_msg_cd);
622: --
623: -- Insert into the diagnostic metadata table
624: --
625: INSERT INTO hri_adm_dgnstc_setup
626: (object_name,
627: object_type,
628: exception_status_msg_cd,
629: valid_status_msg_cd,
682: check_message(p_impact_msg_name);
683: --
684: -- Insert the data into the diagnostic metadata table
685: --
686: INSERT INTO hri_adm_dgnstc_setup
687: (object_name,
688: object_type,
689: dynamic_sql,
690: dynamic_sql_type,
756: check_message(p_impact_msg_name);
757: --
758: -- Insert the data into the diagnostic metadata table
759: --
760: INSERT INTO hri_adm_dgnstc_setup
761: (object_name,
762: object_type,
763: dynamic_sql,
764: dynamic_sql_type,
857: --
858: CURSOR cur_prev_heading
859: IS
860: SELECT object_type_msg_name
861: FROM hri_adm_dgnstc_setup
862: WHERE seq_num = (
863: SELECT max(seq_num)
864: FROM hri_adm_dgnstc_setup
865: WHERE report_type = 'DATA'
860: SELECT object_type_msg_name
861: FROM hri_adm_dgnstc_setup
862: WHERE seq_num = (
863: SELECT max(seq_num)
864: FROM hri_adm_dgnstc_setup
865: WHERE report_type = 'DATA'
866: AND seq_num < p_seq_num);
867:
868:
903: END IF;
904: --
905: END IF;
906: --
907: INSERT INTO hri_adm_dgnstc_setup
908: (object_name,
909: object_type,
910: dynamic_sql,
911: dynamic_sql_type,
1003: IS
1004: --
1005: BEGIN
1006: --
1007: DELETE FROM hri_adm_dgnstc_setup
1008: WHERE object_name = p_object_name
1009: AND object_type = p_object_type
1010: AND report_type = p_report_type
1011: AND functional_area_cd = p_functional_area_cd;