[Home] [Help]
175: smadathi 01-JUL-2004 Bug 3735396. Modified the cursor cur_val select to validate
176: existance of input person id group from igs_pe_persid_group_all
177: smadathi 31-DEC-2002 Bug 2620343. Modified the cursor cur_val select to fetch
178: the records from view igs_pe_persid_group instead of
179: igs_pe_persid_group_v. This fix is done to remove
180: Non-mergablity due to igs_pe_persid_group_v view and to reduce shared memory
181: ********************************************************************************************** */
182:
183: CURSOR cur_val IS
176: existance of input person id group from igs_pe_persid_group_all
177: smadathi 31-DEC-2002 Bug 2620343. Modified the cursor cur_val select to fetch
178: the records from view igs_pe_persid_group instead of
179: igs_pe_persid_group_v. This fix is done to remove
180: Non-mergablity due to igs_pe_persid_group_v view and to reduce shared memory
181: ********************************************************************************************** */
182:
183: CURSOR cur_val IS
184: SELECT 'X'
1376: errbuf OUT NOCOPY VARCHAR2,
1377: retcode OUT NOCOPY NUMBER,
1378: p_award_year IN VARCHAR2,
1379: p_base_id IN igf_ap_fa_con_v.base_id%TYPE,
1380: p_person_group_id IN igs_pe_persid_group_v.group_id%TYPE,
1381: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
1382: p_term_calendar IN VARCHAR2,
1383: p_d_gl_date IN VARCHAR2
1384: ) AS
1479: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
1480: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
1481: lv_profile_value VARCHAR2(30);
1482: lv_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
1483: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1484:
1485: BEGIN
1486:
1487: igf_aw_gen.set_org_id(NULL) ; -- sets the orgid