[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
msrinivi 13 aug,2001 bug 1882122: Take only ch_lns with err_acc ='N'
sykrishn 28-JAN changes to mass application - sfcr020 - 2191470
******************************************************************/
--global variable to know whether Oracle Financials is Yes Or No in System Options form.
g_rec_installed igs_fi_control.rec_installed%TYPE;
SELECT MIN(effective_date) min_date
FROM igs_fi_credits a,
igs_fi_cr_types b
WHERE a.credit_type_id = b.credit_type_id
AND b.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT');
SELECT MAX(effective_date) max_date
FROM igs_fi_credits a,
igs_fi_cr_types b
WHERE a.credit_type_id = b.credit_type_id
AND b.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT');
SELECT invoice_number
FROM igs_fi_inv_int
WHERE invoice_id = cp_invoice_id;
SELECT gl_date
FROM igs_fi_invln_int
WHERE invoice_id = cp_n_invoice_id;
SELECT gl_date
FROM igs_fi_credits
WHERE credit_id = cp_n_credit_id;
SELECT end_dt
FROM igs_ca_inst
WHERE cal_type = cp_cal_type
AND sequence_number = cp_seq_num;
sapanigr 20-Sep-2005 Enh#4228665. Modified CUR_CREDITS to select APPL_HIERARCHY_ID also from table IGS_FI_CR_TYPES_ALL
Modified CUR_HIERARCHIES.
Modified code logic to pass APPL_HIERARCHY_ID from CUR_CREDITS to CUR_HIERARCHIES
svuppala 07-JUL-2005 Enh 3392095 - Tution Waivers build
Modified CUR_CREDITS -- exclude credit class of 'Waiver'.
pathipat 23-Apr-2003 Enh 2831569 - Commercial Receivables build
Added validation for manage_account - call to chk_manage_account()
sarakshi 06-Mar-2003 Bug#2767522,added validation for checking credit date low cannot be greater than credit date high
pathipat 21-Jan-2003 Bug: 2686680 - When person_id and person_id grp are both specified
changed the error message logged from IGS_FI_PRS_OR_PRSIDGRP to IGS_FI_NO_PERS_PGRP
smadathi 9-Jan-2003 Bug 2722096. Removed the logging of person group id. Instead
used call to igs_fi_gen_005.finp_get_prsid_grp_code to
log person group code. Logging of the error message for invalid
parameters passed have been removed and same has been taken cared in mass_application procedure.
Moreover, call to igs_ge_msg_stack.add has been incorporated wherever explicit handling for
invalid parameter values have been done.
vvutukur 13-Dec-2002 Enh#2584741.Modified cursor cur_credits to exclude deposit transactions while selecting
rows from Credits Table.
smadathi 20-NOV-2002 Enh. Bug 2584986. Added new parameter GL Date to procedure mass_apply
schodava 19-Sep-2002 Enh # 2564643 - Subaccount Removal
Removed all references to subaccount.
agairola 23-May-2002 Modified the code for the bug 2378182
1. For the Charges being selected for the Fee Periods other than that of
the Fee Period of the Credit Record, the End Date of the Load Calendar
for the Fee Period of the Charge record should be less than or equal to
the End Date of the Load Calendar of the Credit Record's Fee Period.
agairola 21-May-2002 Modified the cursor cur_charge_not_fp to include the OR condition
instead of the AND condition for the Fee Period- Bug No 2377976
vvutukur 22-apr-2002 Modified code to show numbers and names in the log file instead of ids.
bug#2326163.(added cursors cur_subaccount_name,cur_credit_type).
******************************************************************/
-- cursor for getting the person_id when person group id is passed
CURSOR cur_person_group_id(cp_person_grp igs_pe_prsid_grp_mem_all.group_id%TYPE)
IS
SELECT person_id
FROM igs_pe_prsid_grp_mem
WHERE group_id = cp_person_grp
ORDER BY 1;
SELECT party_id
FROM hz_parties
WHERE party_id = cp_person_id
ORDER BY 1;
SELECT DISTINCT party_id
FROM igs_fi_credits
WHERE unapplied_amount>0
ORDER BY 1;
SELECT cr.rowid, cr.*,crt.credit_type_name,crt.appl_hierarchy_id
FROM igs_fi_credits cr,igs_fi_cr_types crt
WHERE
(cr.party_id = cp_person_id OR (cp_person_id IS NULL)) AND
(cr.credit_number = p_credit_number OR (p_credit_number IS NULL)) AND
(cr.credit_type_id = p_credit_type_id OR (p_credit_type_id IS NULL)) AND
(TRUNC(cr.effective_date) BETWEEN TRUNC(cp_credit_date_low) AND TRUNC(cp_credit_date_high)) AND
cr.unapplied_amount > 0 AND
cr.credit_type_id = crt.credit_type_id AND
crt.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT','CHGADJ','WAIVER')
ORDER BY party_id, effective_date
FOR UPDATE NOWAIT;
SELECT appl_hierarchy_id, hierarchy_name, effective_start_date, effective_end_date
FROM igs_fi_a_hierarchies
WHERE appl_hierarchy_id = cp_appl_hierarchy_id
ORDER by version_number desc;
SELECT rule_sequence, fee_type, enabled_flag
FROM igs_fi_app_rules_v
WHERE appl_hierarchy_id = cp_appl_hierarchy_id AND
enabled_flag = 'Y'
ORDER BY rule_sequence;
SELECT rule_sequence, fee_type, enabled_flag
FROM igs_fi_adl_app_rul_v
WHERE appl_hierarchy_id = cp_appl_hierarchy_id AND
enabled_flag = 'Y'
ORDER BY rule_sequence;
SELECT rowid, inv.*
FROM igs_fi_inv_int inv
WHERE person_id = cp_person_id AND
fee_type = cp_fee_type AND
fee_cal_type = cp_fee_cal_type AND
fee_ci_sequence_number = cp_fee_ci_sequence_number AND
invoice_amount_due > 0
AND NOT EXISTS (SELECT 'X'
FROM igs_fi_invln_int
WHERE invoice_id = inv.invoice_id
AND NVL(error_account,'N') = 'Y')
ORDER BY invoice_creation_date
FOR UPDATE NOWAIT;
SELECT rowid, inv.*
FROM igs_fi_inv_int inv
WHERE person_id = cp_person_id AND
fee_type = cp_fee_type AND
(fee_cal_type <> cp_fee_cal_type OR
fee_ci_sequence_number <> cp_fee_ci_sequence_number) AND
invoice_amount_due > 0
AND NOT EXISTS (SELECT 'X'
FROM igs_fi_invln_int
WHERE invoice_id = inv.invoice_id
AND NVL(error_account,'N') = 'Y')
ORDER BY invoice_creation_date
FOR UPDATE NOWAIT;
SELECT rowid, inv.*
FROM igs_fi_inv_int inv
WHERE person_id = cp_person_id AND
fee_type = cp_fee_type AND
invoice_amount_due > 0
AND NOT EXISTS (SELECT 'X'
FROM igs_fi_invln_int
WHERE invoice_id = inv.invoice_id
AND NVL(error_account,'N') = 'Y')
ORDER BY invoice_creation_date
FOR UPDATE NOWAIT;
SELECT title4_type_ind
FROM igs_fi_cr_types
WHERE credit_type_id = cp_credit_type_id;
SELECT pd.fund_authorization, p.party_number
--bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
--bug:5018036, replaced igs_fi_person_v by base tables
FROM hz_parties p, igs_pe_hz_parties pd
WHERE p.party_id = cp_person_id
AND p.party_id = pd.party_id;
SELECT credit_type_name
FROM igs_fi_cr_types
WHERE credit_type_id = cp_credit_type_id;
l_applications_rowid VARCHAR2(25); -- OUT NOCOPY parameter from the applications table Insert TBH