[Home] [Help]
13: veramach 06-OCT-2003 FA 124
14: Added functions efc_i,is_inas_integrated,need_i,unmetneed_i
15: KUMMA 07-jun-2003 2853531, Modified corp_pre_process and build_sql_stmt for adding the dynamic and static group
16: functionality for financial aid system letter
17: kumma 24-JUN-2003 2853531, Modified the call to igs_pe_dynamic_persid_group.IGS_GET_DYNAMIC_SQL as earlier it was a procedure
18: and now it is a function
19: (reverse chronological order - newest change first)
20:
21: ***************************************************************/
1392: RETURN;
1393: END IF;
1394:
1395: --Bug #5021084. Replaced function IGS_GET_DYNAMIC_SQL with GET_DYNAMIC_SQL
1396: l_query_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_list_id ,lv_status,lv_group_type);
1397:
1398: IF lv_status <> 'S' THEN
1399: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1641:
1642: IF l_file_name IS NOT NULL THEN
1643: --Dynamic Person Id Group
1644: l_static_group := 'N';
1645: --igs_pe_dynamic_persid_group.igs_get_dynamic_sql(p_list_id ,l_query_str,lv_status,lv_count,lv_data);
1646:
1647: --Bug #5021084. Replaced function IGS_GET_DYNAMIC_SQL with GET_DYNAMIC_SQL
1648: lv_group_type := NULL;
1649: l_query_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_list_id ,lv_status,lv_group_type);
1645: --igs_pe_dynamic_persid_group.igs_get_dynamic_sql(p_list_id ,l_query_str,lv_status,lv_count,lv_data);
1646:
1647: --Bug #5021084. Replaced function IGS_GET_DYNAMIC_SQL with GET_DYNAMIC_SQL
1648: lv_group_type := NULL;
1649: l_query_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_list_id ,lv_status,lv_group_type);
1650:
1651: IF lv_status <> 'S' THEN
1652: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
1653: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);