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_PS_NSUS_RTN_DTL

Line 10369: igs_ps_nsus_rtn_dtl nrd

10365:
10366: CURSOR cur_check_formula (cp_non_std_usec_rtn_id IN NUMBER) IS
10367: SELECT 'X'
10368: FROM igs_ps_nsus_rtn nr,
10369: igs_ps_nsus_rtn_dtl nrd
10370: WHERE nr.non_std_usec_rtn_id = nrd.non_std_usec_rtn_id
10371: AND nr.non_std_usec_rtn_id = cp_non_std_usec_rtn_id
10372: AND p_usec_ret_rec.formula_method IN ('P','M')
10373: AND nrd.offset_value > 100;

Line 10375: CURSOR c_cur(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE) IS

10371: AND nr.non_std_usec_rtn_id = cp_non_std_usec_rtn_id
10372: AND p_usec_ret_rec.formula_method IN ('P','M')
10373: AND nrd.offset_value > 100;
10374:
10375: CURSOR c_cur(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE) IS
10376: SELECT *
10377: FROM igs_ps_nsus_rtn_dtl a
10378: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id
10379: AND override_date_flag = 'N';

Line 10377: FROM igs_ps_nsus_rtn_dtl a

10373: AND nrd.offset_value > 100;
10374:
10375: CURSOR c_cur(cp_non_std_usec_rtn_id igs_ps_nsus_rtn_dtl.non_std_usec_rtn_id%TYPE) IS
10376: SELECT *
10377: FROM igs_ps_nsus_rtn_dtl a
10378: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id
10379: AND override_date_flag = 'N';
10380: l_offset_date DATE;
10381:

Line 10504: UPDATE igs_ps_nsus_rtn_dtl SET

10500: p_n_offset_value => l_c_rec.offset_value
10501: );
10502:
10503:
10504: UPDATE igs_ps_nsus_rtn_dtl SET
10505: offset_date = l_offset_date,
10506: last_updated_by = g_n_user_id ,
10507: last_update_date = sysdate ,
10508: last_update_login = g_n_login_id

Line 10900: IF igs_ps_nsus_rtn_dtl_pkg.get_uk_for_validation ( x_non_std_usec_rtn_id => l_n_non_std_usec_rtn_id,

10896: BEGIN
10897:
10898: IF p_insert_update = 'I' THEN
10899: -- Unique Key Validation
10900: IF igs_ps_nsus_rtn_dtl_pkg.get_uk_for_validation ( x_non_std_usec_rtn_id => l_n_non_std_usec_rtn_id,
10901: x_offset_value => p_usec_ret_dtl_rec.offset_value ) THEN
10902: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'RETENTION', 'LEGACY_TOKENS', FALSE);
10903: p_usec_ret_dtl_rec.status := 'W';
10904: RETURN;

Line 10912: igs_ps_nsus_rtn_dtl_pkg.check_constraints('OFFSET_VALUE', p_usec_ret_dtl_rec.offset_value);

10908:
10909:
10910: --Check constraint
10911: BEGIN
10912: igs_ps_nsus_rtn_dtl_pkg.check_constraints('OFFSET_VALUE', p_usec_ret_dtl_rec.offset_value);
10913: EXCEPTION
10914: WHEN OTHERS THEN
10915: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','OFFSET_VALUE','LEGACY_TOKENS',TRUE);
10916: p_usec_ret_dtl_rec.status :='E';

Line 10920: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_PERCENT', p_usec_ret_dtl_rec.retention_percent);

10916: p_usec_ret_dtl_rec.status :='E';
10917: END;
10918:
10919: BEGIN
10920: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_PERCENT', p_usec_ret_dtl_rec.retention_percent);
10921: EXCEPTION
10922: WHEN OTHERS THEN
10923: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','RETENTION_PERCENT','LEGACY_TOKENS',TRUE);
10924: p_usec_ret_dtl_rec.status :='E';

Line 10928: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_AMOUNT', p_usec_ret_dtl_rec.retention_amount);

10924: p_usec_ret_dtl_rec.status :='E';
10925: END;
10926:
10927: BEGIN
10928: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_AMOUNT', p_usec_ret_dtl_rec.retention_amount);
10929: EXCEPTION
10930: WHEN OTHERS THEN
10931: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','RETENTION_AMOUNT','LEGACY_TOKENS',TRUE);
10932: p_usec_ret_dtl_rec.status :='E';

Line 10972: FROM igs_ps_nsus_rtn_dtl

10968: FUNCTION check_insert_update ( p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) RETURN VARCHAR2 IS
10969:
10970: CURSOR c_ret_det_usec IS
10971: SELECT 'X'
10972: FROM igs_ps_nsus_rtn_dtl
10973: WHERE non_std_usec_rtn_id = l_n_non_std_usec_rtn_id
10974: AND offset_value = p_usec_ret_dtl_rec.offset_value;
10975:
10976: l_c_var VARCHAR2(1);

Line 10995: FROM igs_ps_nsus_rtn_dtl

10991:
10992: PROCEDURE Assign_defaults(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS
10993: CURSOR cur_ret_det IS
10994: SELECT *
10995: FROM igs_ps_nsus_rtn_dtl
10996: WHERE non_std_usec_rtn_id = l_n_non_std_usec_rtn_id
10997: AND offset_value = p_usec_ret_dtl_rec.offset_value;
10998:
10999: l_cur_ret_det cur_ret_det%ROWTYPE;

Line 11214: INSERT INTO IGS_PS_NSUS_RTN_DTL(

11210:
11211: IF p_usec_ret_dtl_tbl(I).status = 'S' THEN
11212:
11213: IF l_insert_update = 'I' THEN
11214: INSERT INTO IGS_PS_NSUS_RTN_DTL(
11215: non_std_usec_rtn_dtl_id,
11216: non_std_usec_rtn_id,
11217: offset_value,
11218: retention_percent,

Line 11228: igs_ps_nsus_rtn_dtl_s.NEXTVAL,

11224: last_updated_by,
11225: last_update_date,
11226: last_update_login )
11227: VALUES (
11228: igs_ps_nsus_rtn_dtl_s.NEXTVAL,
11229: l_n_non_std_usec_rtn_id,
11230: p_usec_ret_dtl_tbl(I).offset_value,
11231: p_usec_ret_dtl_tbl(I).retention_percent,
11232: p_usec_ret_dtl_tbl(I).retention_amount,

Line 11250: UPDATE IGS_PS_NSUS_RTN_DTL SET

11246: ||p_usec_ret_dtl_tbl(I).definition_level||' '||'Offset Value:'||p_usec_ret_dtl_tbl(I).offset_value);
11247: END IF;
11248:
11249: ELSE
11250: UPDATE IGS_PS_NSUS_RTN_DTL SET
11251: retention_percent = p_usec_ret_dtl_tbl(I).retention_percent,
11252: retention_amount = p_usec_ret_dtl_tbl(I).retention_amount,
11253: offset_date = l_d_offset_date,
11254: override_date_flag = p_usec_ret_dtl_tbl(I).override_date_flag,