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.

[Home] [Help]

APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_EX_RN_DAT_FD

Line 798: l_oss_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;

794: l_hesa_study_location igs_he_code_map_val.map1%TYPE ;
795: l_dummy VARCHAR2(50);
796:
797: --smaddali added these variable declarations for bug 2483523
798: l_oss_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
799: l_hesa_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
800: l_oss_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
801: l_hesa_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
802: l_oss_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;

Line 799: l_hesa_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;

795: l_dummy VARCHAR2(50);
796:
797: --smaddali added these variable declarations for bug 2483523
798: l_oss_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
799: l_hesa_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
800: l_oss_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
801: l_hesa_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
802: l_oss_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
803: l_hesa_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;

Line 800: l_oss_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;

796:
797: --smaddali added these variable declarations for bug 2483523
798: l_oss_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
799: l_hesa_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
800: l_oss_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
801: l_hesa_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
802: l_oss_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
803: l_hesa_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
804: -- smaddali added these parameters for bug#3166126

Line 801: l_hesa_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;

797: --smaddali added these variable declarations for bug 2483523
798: l_oss_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
799: l_hesa_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
800: l_oss_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
801: l_hesa_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
802: l_oss_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
803: l_hesa_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
804: -- smaddali added these parameters for bug#3166126
805: l_only_exists BOOLEAN;

Line 802: l_oss_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;

798: l_oss_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
799: l_hesa_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
800: l_oss_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
801: l_hesa_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
802: l_oss_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
803: l_hesa_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
804: -- smaddali added these parameters for bug#3166126
805: l_only_exists BOOLEAN;
806: l_only_matches BOOLEAN ;

Line 803: l_hesa_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;

799: l_hesa_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;
800: l_oss_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
801: l_hesa_value_65 igs_he_ex_rn_dat_fd.value%TYPE ;
802: l_oss_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
803: l_hesa_value_6 igs_he_ex_rn_dat_fd.value%TYPE ;
804: -- smaddali added these parameters for bug#3166126
805: l_only_exists BOOLEAN;
806: l_only_matches BOOLEAN ;
807:

Line 985: FIELD - Igs_He_Ex_Rn_Dat_Fd

981: p_line_number IN Line Number
982: p_table_name IN Table Name
983: Values : INTERIM - Igs_He_Ext_Run_Interim
984: LINE - Igs_He_Ex_Rn_Dat_Ln
985: FIELD - Igs_He_Ex_Rn_Dat_Fd
986: ERROR - Igs_He_Ext_Run_Excp
987: WHO: AYEDUBAT
988: WHAT: Removed the 'PROCEDURE delete_rows' as all the call to this procedure are placed
989: with direct DMLS for bug,3179585

Line 1885: FROM igs_he_ex_rn_dat_fd a,

1881: --smaddali modified this cursor to add NVL 'N' to program_calc, also added ckeck that module_id is not null for bug 2425932
1882: CURSOR c_get_mod (p_stdnt_extract_run_id NUMBER)
1883: IS
1884: SELECT DISTINCT Nvl(a.override_value, a.value) module_id
1885: FROM igs_he_ex_rn_dat_fd a,
1886: igs_he_ex_rn_dat_ln b,
1887: igs_he_st_prog c
1888: WHERE a.extract_run_id = b.extract_run_id
1889: AND b.extract_run_id = p_stdnt_extract_run_id

Line 2531: -- Delete from igs_he_ex_rn_dat_fd

2527:
2528: -- Delete from igs_he_ext_run_interim
2529: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
2530:
2531: -- Delete from igs_he_ex_rn_dat_fd
2532: DELETE FROM igs_he_ex_rn_dat_fd WHERE extract_run_id = p_extract_run_id;
2533:
2534: -- Delete from igs_he_ex_rn_dat_ln
2535: DELETE FROM igs_he_ex_rn_dat_ln WHERE extract_run_id = p_extract_run_id;

Line 2532: DELETE FROM igs_he_ex_rn_dat_fd WHERE extract_run_id = p_extract_run_id;

2528: -- Delete from igs_he_ext_run_interim
2529: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
2530:
2531: -- Delete from igs_he_ex_rn_dat_fd
2532: DELETE FROM igs_he_ex_rn_dat_fd WHERE extract_run_id = p_extract_run_id;
2533:
2534: -- Delete from igs_he_ex_rn_dat_ln
2535: DELETE FROM igs_he_ex_rn_dat_ln WHERE extract_run_id = p_extract_run_id;
2536: