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.IGF_AW_GEN_004 dependencies on FND_DSQL

Line 285: fnd_dsql.init;

281: Removed the p_person_id parameter from the build_sql_stm call and
282: procedure since the person id are stored in PLSQL table (and treated as PIPELINED function)
283: (reverse chronological order - newest change first)
284: ***************************************************************/
285: fnd_dsql.init;
286: fnd_dsql.add_text(' SELECT distinct email_address,person_id,award_year FROM ');
287:
288: IF p_sys_ltr_code IN ('FAMISTM','FADISBT') THEN
289: l_award_year := igf_gr_gen.get_calendar_desc( RTRIM(SUBSTR(p_award_year,1,10)), TO_NUMBER(RTRIM(SUBSTR(p_award_year,11))));

Line 286: fnd_dsql.add_text(' SELECT distinct email_address,person_id,award_year FROM ');

282: procedure since the person id are stored in PLSQL table (and treated as PIPELINED function)
283: (reverse chronological order - newest change first)
284: ***************************************************************/
285: fnd_dsql.init;
286: fnd_dsql.add_text(' SELECT distinct email_address,person_id,award_year FROM ');
287:
288: IF p_sys_ltr_code IN ('FAMISTM','FADISBT') THEN
289: l_award_year := igf_gr_gen.get_calendar_desc( RTRIM(SUBSTR(p_award_year,1,10)), TO_NUMBER(RTRIM(SUBSTR(p_award_year,11))));
290: ELSE

Line 300: fnd_dsql.add_text(' IGF_AW_PER_LIST_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');

296: log_to_fnd('build_sql_stmt','debug','IT IS LETTER CODE of type '||p_sys_ltr_code||' with select type as '||p_select_type||' and award year = '||l_award_year);
297: IF p_sys_ltr_code IN ('FAAWARD', 'FAMISTM','FADISBT') THEN
298: IF p_select_type IN ('S','G','A','L') THEN
299: IF p_sys_ltr_code='FAAWARD' THEN
300: fnd_dsql.add_text(' IGF_AW_PER_LIST_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
301: fnd_dsql.add_text(') AND award_year =');
302: fnd_dsql.add_bind(l_award_year);
303: ELSIF p_sys_ltr_code='FAMISTM' THEN
304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');

Line 301: fnd_dsql.add_text(') AND award_year =');

297: IF p_sys_ltr_code IN ('FAAWARD', 'FAMISTM','FADISBT') THEN
298: IF p_select_type IN ('S','G','A','L') THEN
299: IF p_sys_ltr_code='FAAWARD' THEN
300: fnd_dsql.add_text(' IGF_AW_PER_LIST_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
301: fnd_dsql.add_text(') AND award_year =');
302: fnd_dsql.add_bind(l_award_year);
303: ELSIF p_sys_ltr_code='FAMISTM' THEN
304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
305: fnd_dsql.add_text(') AND award_year =');

Line 302: fnd_dsql.add_bind(l_award_year);

298: IF p_select_type IN ('S','G','A','L') THEN
299: IF p_sys_ltr_code='FAAWARD' THEN
300: fnd_dsql.add_text(' IGF_AW_PER_LIST_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
301: fnd_dsql.add_text(') AND award_year =');
302: fnd_dsql.add_bind(l_award_year);
303: ELSIF p_sys_ltr_code='FAMISTM' THEN
304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
305: fnd_dsql.add_text(') AND award_year =');
306: fnd_dsql.add_bind(l_award_year);

Line 304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');

300: fnd_dsql.add_text(' IGF_AW_PER_LIST_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
301: fnd_dsql.add_text(') AND award_year =');
302: fnd_dsql.add_bind(l_award_year);
303: ELSIF p_sys_ltr_code='FAMISTM' THEN
304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
305: fnd_dsql.add_text(') AND award_year =');
306: fnd_dsql.add_bind(l_award_year);
307: ELSIF p_sys_ltr_code='FADISBT' THEN
308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');

Line 305: fnd_dsql.add_text(') AND award_year =');

301: fnd_dsql.add_text(') AND award_year =');
302: fnd_dsql.add_bind(l_award_year);
303: ELSIF p_sys_ltr_code='FAMISTM' THEN
304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
305: fnd_dsql.add_text(') AND award_year =');
306: fnd_dsql.add_bind(l_award_year);
307: ELSIF p_sys_ltr_code='FADISBT' THEN
308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
309: fnd_dsql.add_text(') AND award_year =');

Line 306: fnd_dsql.add_bind(l_award_year);

302: fnd_dsql.add_bind(l_award_year);
303: ELSIF p_sys_ltr_code='FAMISTM' THEN
304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
305: fnd_dsql.add_text(') AND award_year =');
306: fnd_dsql.add_bind(l_award_year);
307: ELSIF p_sys_ltr_code='FADISBT' THEN
308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
309: fnd_dsql.add_text(') AND award_year =');
310: fnd_dsql.add_bind(l_award_year);

Line 308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');

304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
305: fnd_dsql.add_text(') AND award_year =');
306: fnd_dsql.add_bind(l_award_year);
307: ELSIF p_sys_ltr_code='FADISBT' THEN
308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
309: fnd_dsql.add_text(') AND award_year =');
310: fnd_dsql.add_bind(l_award_year);
311: END IF;
312: END IF;

Line 309: fnd_dsql.add_text(') AND award_year =');

305: fnd_dsql.add_text(') AND award_year =');
306: fnd_dsql.add_bind(l_award_year);
307: ELSIF p_sys_ltr_code='FADISBT' THEN
308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
309: fnd_dsql.add_text(') AND award_year =');
310: fnd_dsql.add_bind(l_award_year);
311: END IF;
312: END IF;
313: END IF;

Line 310: fnd_dsql.add_bind(l_award_year);

306: fnd_dsql.add_bind(l_award_year);
307: ELSIF p_sys_ltr_code='FADISBT' THEN
308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
309: fnd_dsql.add_text(') AND award_year =');
310: fnd_dsql.add_bind(l_award_year);
311: END IF;
312: END IF;
313: END IF;
314:

Line 315: p_sql_stmt := fnd_dsql.get_text(FALSE);

311: END IF;
312: END IF;
313: END IF;
314:
315: p_sql_stmt := fnd_dsql.get_text(FALSE);
316: log_to_fnd('build_sql_stmt','debug','SQL Stmt got from build_sql_stmt is '||p_sql_stmt);
317: END build_sql_stmt;
318:
319: FUNCTION efc_i(