APPS.IGS_FI_GEN_007 dependencies on IGS_FI_BALANCE_RULES

Line 1299: PROCEDURE finp_get_balance_rule (p_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,

1295:
1296: END finp_get_conv_prc_run_ind;
1297:
1298:
1299: PROCEDURE finp_get_balance_rule (p_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
1300: p_v_action IN VARCHAR2,
1301: p_n_balance_rule_id OUT NOCOPY igs_fi_balance_rules.balance_rule_id%TYPE,
1302: p_d_last_conversion_date OUT NOCOPY igs_fi_balance_rules.last_conversion_date%TYPE,
1303: p_n_version_number OUT NOCOPY igs_fi_balance_rules.version_number%TYPE ) AS

Line 1301: p_n_balance_rule_id OUT NOCOPY igs_fi_balance_rules.balance_rule_id%TYPE,

1297:
1298:
1299: PROCEDURE finp_get_balance_rule (p_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
1300: p_v_action IN VARCHAR2,
1301: p_n_balance_rule_id OUT NOCOPY igs_fi_balance_rules.balance_rule_id%TYPE,
1302: p_d_last_conversion_date OUT NOCOPY igs_fi_balance_rules.last_conversion_date%TYPE,
1303: p_n_version_number OUT NOCOPY igs_fi_balance_rules.version_number%TYPE ) AS
1304: /*|| Created By : PATHIPAT
1305: || Created On : 02-OCT-2002

Line 1302: p_d_last_conversion_date OUT NOCOPY igs_fi_balance_rules.last_conversion_date%TYPE,

1298:
1299: PROCEDURE finp_get_balance_rule (p_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
1300: p_v_action IN VARCHAR2,
1301: p_n_balance_rule_id OUT NOCOPY igs_fi_balance_rules.balance_rule_id%TYPE,
1302: p_d_last_conversion_date OUT NOCOPY igs_fi_balance_rules.last_conversion_date%TYPE,
1303: p_n_version_number OUT NOCOPY igs_fi_balance_rules.version_number%TYPE ) AS
1304: /*|| Created By : PATHIPAT
1305: || Created On : 02-OCT-2002
1306: || Purpose : For getting the balance rule defined in the system for an input balance type

Line 1303: p_n_version_number OUT NOCOPY igs_fi_balance_rules.version_number%TYPE ) AS

1299: PROCEDURE finp_get_balance_rule (p_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
1300: p_v_action IN VARCHAR2,
1301: p_n_balance_rule_id OUT NOCOPY igs_fi_balance_rules.balance_rule_id%TYPE,
1302: p_d_last_conversion_date OUT NOCOPY igs_fi_balance_rules.last_conversion_date%TYPE,
1303: p_n_version_number OUT NOCOPY igs_fi_balance_rules.version_number%TYPE ) AS
1304: /*|| Created By : PATHIPAT
1305: || Created On : 02-OCT-2002
1306: || Purpose : For getting the balance rule defined in the system for an input balance type
1307: || Known limitations, enhancements or remarks :

Line 1313: CURSOR cur_get_active(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS

1309: || Who When What
1310: || (reverse chronological order - newest change first) */
1311:
1312: -- Cursor to get the balance rule details when the p_v_action is 'ACTIVE'
1313: CURSOR cur_get_active(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
1314: SELECT balance_rule_id,
1315: version_number,
1316: last_conversion_date
1317: FROM IGS_FI_BALANCE_RULES

Line 1317: FROM IGS_FI_BALANCE_RULES

1313: CURSOR cur_get_active(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
1314: SELECT balance_rule_id,
1315: version_number,
1316: last_conversion_date
1317: FROM IGS_FI_BALANCE_RULES
1318: WHERE balance_name = cp_balance_type
1319: AND last_conversion_date IS NOT NULL
1320: ORDER BY version_number DESC;
1321:

Line 1323: CURSOR cur_get_max(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS

1319: AND last_conversion_date IS NOT NULL
1320: ORDER BY version_number DESC;
1321:
1322: -- Cursor to get the balance rule details when the p_v_action is 'MAX'
1323: CURSOR cur_get_max(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
1324: SELECT balance_rule_id,
1325: version_number,
1326: last_conversion_date
1327: FROM IGS_FI_BALANCE_RULES

Line 1327: FROM IGS_FI_BALANCE_RULES

1323: CURSOR cur_get_max(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
1324: SELECT balance_rule_id,
1325: version_number,
1326: last_conversion_date
1327: FROM IGS_FI_BALANCE_RULES
1328: WHERE balance_name = cp_balance_type
1329: ORDER BY version_number DESC;
1330:
1331: -- Cursor to check if the input balance type is a valid lookup code or not

Line 1332: CURSOR cur_balance_type(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS

1328: WHERE balance_name = cp_balance_type
1329: ORDER BY version_number DESC;
1330:
1331: -- Cursor to check if the input balance type is a valid lookup code or not
1332: CURSOR cur_balance_type(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
1333: SELECT *
1334: FROM igs_lookup_values
1335: WHERE lookup_type = 'IGS_FI_BALANCE_TYPE'
1336: AND lookup_code = cp_balance_type