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

Line 10243: IF igs_ps_nsus_rtn_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,

10239: BEGIN
10240:
10241: IF p_insert_update = 'I' AND p_usec_ret_rec.definition_level='UNIT_SECTION_FEE_TYPE' THEN
10242: -- Unique Key Validation
10243: IF igs_ps_nsus_rtn_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,
10244: x_fee_type => p_usec_ret_rec.fee_type ) THEN
10245: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'RETENTION', 'LEGACY_TOKENS', FALSE);
10246: p_usec_ret_rec.status := 'W';
10247: RETURN;

Line 10261: igs_ps_nsus_rtn_pkg.check_constraints('FORMULA_METHOD', p_usec_ret_rec.formula_method);

10257:
10258:
10259: --Check constraint
10260: BEGIN
10261: igs_ps_nsus_rtn_pkg.check_constraints('FORMULA_METHOD', p_usec_ret_rec.formula_method);
10262: EXCEPTION
10263: WHEN OTHERS THEN
10264: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','FORMULA_METHOD','LEGACY_TOKENS',TRUE);
10265: p_usec_ret_rec.status :='E';

Line 10269: igs_ps_nsus_rtn_pkg.check_constraints('ROUND_METHOD', p_usec_ret_rec.round_method);

10265: p_usec_ret_rec.status :='E';
10266: END;
10267:
10268: BEGIN
10269: igs_ps_nsus_rtn_pkg.check_constraints('ROUND_METHOD', p_usec_ret_rec.round_method);
10270: EXCEPTION
10271: WHEN OTHERS THEN
10272: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','ROUND_METHOD','LEGACY_TOKENS',TRUE);
10273: p_usec_ret_rec.status :='E';

Line 10277: igs_ps_nsus_rtn_pkg.check_constraints('INCL_WKEND_DURATION_FLAG', p_usec_ret_rec.incl_wkend_duration_flag);

10273: p_usec_ret_rec.status :='E';
10274: END;
10275:
10276: BEGIN
10277: igs_ps_nsus_rtn_pkg.check_constraints('INCL_WKEND_DURATION_FLAG', p_usec_ret_rec.incl_wkend_duration_flag);
10278: EXCEPTION
10279: WHEN OTHERS THEN
10280: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','INCL_WKEND_DURATION_FLAG','LEGACY_TOKENS',TRUE);
10281: p_usec_ret_rec.status :='E';

Line 10301: FROM igs_ps_nsus_rtn

10297: FUNCTION check_insert_update ( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) RETURN VARCHAR2 IS
10298:
10299: CURSOR c_ret_usec IS
10300: SELECT non_std_usec_rtn_id
10301: FROM igs_ps_nsus_rtn
10302: WHERE uoo_id = l_n_uoo_id
10303: AND definition_code='UNIT_SECTION';
10304:
10305: CURSOR c_ret_usec_fee IS

Line 10307: FROM igs_ps_nsus_rtn

10303: AND definition_code='UNIT_SECTION';
10304:
10305: CURSOR c_ret_usec_fee IS
10306: SELECT non_std_usec_rtn_id
10307: FROM igs_ps_nsus_rtn
10308: WHERE uoo_id = l_n_uoo_id
10309: AND fee_type = p_usec_ret_rec.fee_type;
10310:
10311: BEGIN

Line 10368: FROM igs_ps_nsus_rtn nr,

10364: cur_fee_rec cur_fee%ROWTYPE;
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')

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 10625: INSERT INTO IGS_PS_NSUS_RTN(

10621:
10622: IF p_usec_ret_tbl(I).status = 'S' THEN
10623:
10624: IF l_insert_update = 'I' THEN
10625: INSERT INTO IGS_PS_NSUS_RTN(
10626: non_std_usec_rtn_id,
10627: uoo_id,
10628: fee_type,
10629: definition_code,

Line 10639: igs_ps_nsus_rtn_s.NEXTVAL,

10635: last_updated_by,
10636: last_update_date,
10637: last_update_login )
10638: VALUES (
10639: igs_ps_nsus_rtn_s.NEXTVAL,
10640: l_n_uoo_id,
10641: p_usec_ret_tbl(I).fee_type,
10642: p_usec_ret_tbl(I).definition_level,
10643: p_usec_ret_tbl(I).formula_method,

Line 10662: UPDATE IGS_PS_NSUS_RTN SET

10658: END IF;
10659:
10660:
10661: ELSE
10662: UPDATE IGS_PS_NSUS_RTN SET
10663: formula_method = p_usec_ret_tbl(I).formula_method,
10664: round_method = p_usec_ret_tbl(I).round_method,
10665: incl_wkend_duration_flag = p_usec_ret_tbl(I).incl_wkend_duration_flag,
10666: last_updated_by = g_n_user_id ,

Line 10829: FROM igs_ps_nsus_rtn

10825: l_c_ret_status VARCHAR2(30);
10826:
10827: CURSOR c_ret_usec IS
10828: SELECT non_std_usec_rtn_id,formula_method,round_method,incl_wkend_duration_flag
10829: FROM igs_ps_nsus_rtn
10830: WHERE uoo_id = l_n_uoo_id
10831: AND definition_code='UNIT_SECTION';
10832:
10833: CURSOR c_ret_usec_fee IS

Line 10835: FROM igs_ps_nsus_rtn

10831: AND definition_code='UNIT_SECTION';
10832:
10833: CURSOR c_ret_usec_fee IS
10834: SELECT non_std_usec_rtn_id,formula_method,round_method,incl_wkend_duration_flag
10835: FROM igs_ps_nsus_rtn
10836: WHERE uoo_id = l_n_uoo_id
10837: AND fee_type = p_usec_ret_dtl_rec.fee_type;
10838:
10839: l_c_formula_method VARCHAR2(1);

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 11036: FROM igs_ps_nsus_rtn nr

11032: l_message_name VARCHAR2(30);
11033:
11034: CURSOR cur_check_formula (cp_non_std_usec_rtn_id IN NUMBER) IS
11035: SELECT 'X'
11036: FROM igs_ps_nsus_rtn nr
11037: WHERE nr.non_std_usec_rtn_id = cp_non_std_usec_rtn_id
11038: AND nr.formula_method IN ('P','M')
11039: AND p_usec_ret_dtl_rec.offset_value > 100;
11040:

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,