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_NSTD_USEC_DL

Line 8981: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%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);
8985:

Line 8982: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%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);
8985:
8986: PROCEDURE trim_values ( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS

Line 8983: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%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);
8985:
8986: PROCEDURE trim_values ( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS
8987: BEGIN

Line 9077: IF igs_en_nstd_usec_dl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,

9073: BEGIN
9074:
9075: IF p_insert_update = 'I' THEN
9076: -- Unique Key Validation
9077: IF igs_en_nstd_usec_dl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,
9078: x_function_name => p_usec_enr_dead_rec.function_name ) THEN
9079: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'ENR_DEADLINE', 'LEGACY_TOKENS', FALSE);
9080: p_usec_enr_dead_rec.status := 'W';
9081: RETURN;

Line 9107: FROM igs_en_nstd_usec_dl

9103: FUNCTION check_insert_update ( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) RETURN VARCHAR2 IS
9104:
9105: CURSOR c_enr_dead IS
9106: SELECT 'X'
9107: FROM igs_en_nstd_usec_dl
9108: WHERE uoo_id = l_n_uoo_id
9109: AND function_name = p_usec_enr_dead_rec.function_name;
9110: l_c_var VARCHAR2(1);
9111:

Line 9143: FROM igs_en_nstd_usec_dl

9139: l_cur_dead_details cur_dead_details%ROWTYPE;
9140:
9141: CURSOR c_enr_dead IS
9142: SELECT *
9143: FROM igs_en_nstd_usec_dl
9144: WHERE uoo_id = l_n_uoo_id
9145: AND function_name = p_usec_enr_dead_rec.function_name;
9146: l_c_enr_dead c_enr_dead%ROWTYPE;
9147:

Line 9425: INSERT INTO IGS_EN_NSTD_USEC_DL(

9421:
9422: IF p_usec_enr_dead_tbl(I).status = 'S' THEN
9423:
9424: IF l_insert_update = 'I' THEN
9425: INSERT INTO IGS_EN_NSTD_USEC_DL(
9426: nstd_usec_dl_id ,
9427: non_std_usec_dls_id ,
9428: function_name ,
9429: definition_code ,

Line 9445: igs_en_nstd_usec_dl_s.NEXTVAL,

9441: last_updated_by,
9442: last_update_date,
9443: last_update_login )
9444: VALUES (
9445: igs_en_nstd_usec_dl_s.NEXTVAL,
9446: l_n_non_std_usec_dls_id,
9447: p_usec_enr_dead_tbl(I).function_name,
9448: l_c_definition_code,
9449: l_c_org_unit_code,

Line 9472: UPDATE IGS_EN_NSTD_USEC_DL SET

9468: p_usec_enr_dead_tbl(I).unit_class||' '||'function_name:'||p_usec_enr_dead_tbl(I).function_name);
9469: END IF;
9470:
9471: ELSE
9472: UPDATE IGS_EN_NSTD_USEC_DL SET
9473: non_std_usec_dls_id = l_n_non_std_usec_dls_id,
9474: definition_code = l_c_definition_code,
9475: org_unit_code = l_c_org_unit_code,
9476: formula_method = l_c_formula_method,

Line 9549: l_n_duration_days igs_en_nstd_usec_dl.enr_dl_total_days%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);
9553:

Line 9550: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%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);
9553:
9554: PROCEDURE trim_values ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS

Line 9551: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%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);
9553:
9554: PROCEDURE trim_values ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS
9555: BEGIN