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.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_EN_NSU_DLSTP

Line 8970: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsu_dlstp with igs_en_nsu_dlstp_all for cursor cur_dead_details

8966:
8967: Known limitations,enhancements,remarks:
8968: Change History
8969: Who When What
8970: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsu_dlstp with igs_en_nsu_dlstp_all for cursor cur_dead_details
8971: in proccedure Assign_defaults
8972: ***********************************************************************************************/
8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;

Line 8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;

8970: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsu_dlstp with igs_en_nsu_dlstp_all for cursor cur_dead_details
8971: in proccedure Assign_defaults
8972: ***********************************************************************************************/
8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;

Line 8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;

8971: in proccedure Assign_defaults
8972: ***********************************************************************************************/
8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
8979: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;

Line 8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;

8972: ***********************************************************************************************/
8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
8979: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
8980: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;

Line 8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;

8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
8979: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
8980: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
8981: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;

Line 8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;

8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
8979: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
8980: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
8981: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;
8982: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;

Line 8979: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;

8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
8979: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
8980: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
8981: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;
8982: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;
8983: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE;

Line 8980: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;

8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
8978: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
8979: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
8980: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
8981: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;
8982: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;
8983: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE;
8984: l_insert_update VARCHAR2(1);

Line 9094: IF NOT igs_en_nsu_dlstp_pkg.get_pk_for_validation ( l_n_non_std_usec_dls_id) THEN

9090: END IF;
9091:
9092:
9093: IF l_n_non_std_usec_dls_id IS NOT NULL THEN
9094: IF NOT igs_en_nsu_dlstp_pkg.get_pk_for_validation ( l_n_non_std_usec_dls_id) THEN
9095: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'NON_STD_USEC_DLS_ID', 'LEGACY_TOKENS', FALSE);
9096: p_usec_enr_dead_rec.status := 'E';
9097: END IF;
9098: END IF;

Line 9136: FROM igs_en_nsu_dlstp_all

9132: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;
9133:
9134: CURSOR cur_dead_details (cp_org_unit_cd IN VARCHAR2,cp_function_name IN VARCHAR2) IS
9135: SELECT formula_method,round_method,offset_duration,non_std_usec_dls_id,offset_dt_code,org_unit_code,definition_code
9136: FROM igs_en_nsu_dlstp_all
9137: WHERE ((org_unit_code = cp_org_unit_cd AND definition_code = 'ORGANIZATIONAL_UNIT') OR definition_code = 'INSTITUTION')
9138: AND function_name = cp_function_name;
9139: l_cur_dead_details cur_dead_details%ROWTYPE;
9140:

Line 9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;

9538: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsd_dlstp with igs_en_nsd_dlstp_all for cursor cur_disc_details
9539: in proccedure Assign_defaults
9540: ***********************************************************************************************/
9541: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;

Line 9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;

9539: in proccedure Assign_defaults
9540: ***********************************************************************************************/
9541: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
9547: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;

Line 9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;

9540: ***********************************************************************************************/
9541: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
9547: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
9548: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;

Line 9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;

9541: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
9547: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
9548: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
9549: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;

Line 9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;

9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
9547: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
9548: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
9549: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;
9550: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;

Line 9547: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;

9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
9547: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
9548: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
9549: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;
9550: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;
9551: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE;

Line 9548: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;

9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;
9546: l_c_round_method igs_en_nsu_dlstp.round_method%TYPE;
9547: l_n_offset_duration igs_en_nsu_dlstp.offset_duration%TYPE;
9548: l_c_offset_dt_code igs_en_nsu_dlstp.offset_dt_code%TYPE;
9549: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%TYPE;
9550: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;
9551: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE;
9552: l_insert_update VARCHAR2(1);