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.PQH_GEN_FORM dependencies on FND_FLEX_EXT

Line 1131: l_str:= 'a := fnd_flex_ext.breakup_segments (pqh_gen_form.g_'||l_col||','''||l_fd||''', l_ac_seg); '

1127: l_col := a.ddf_column_name ;
1128: end loop;
1129: --
1130:
1131: l_str:= 'a := fnd_flex_ext.breakup_segments (pqh_gen_form.g_'||l_col||','''||l_fd||''', l_ac_seg); '
1132: ||'for i in 1..greatest(a,'||to_char(l_number)||') loop '
1133: ||'l_ch_seg(i) := null; end loop;'
1134: ||'for i in 1..a loop l_ch_seg(i) := l_ac_seg(i); end loop;'
1135: ||' hr_utility.set_location(''dyn ac:''|| pqh_gen_form.g_'||l_col||',2001);'

Line 1137: ||'l_val := fnd_flex_ext.concatenate_segments(greatest(a,'||to_char(l_number)

1133: ||'l_ch_seg(i) := null; end loop;'
1134: ||'for i in 1..a loop l_ch_seg(i) := l_ac_seg(i); end loop;'
1135: ||' hr_utility.set_location(''dyn ac:''|| pqh_gen_form.g_'||l_col||',2001);'
1136: ||'l_ch_seg('||to_char(l_number)||') := '''||l_cat_value||'''; '
1137: ||'l_val := fnd_flex_ext.concatenate_segments(greatest(a,'||to_char(l_number)
1138: ||'), l_ch_seg,'''||l_fd||'''); '
1139: ||'pqh_gen_form.g_'||l_col||' := l_val; ';
1140: --
1141: l_str:= 'declare j number := 0; l_a varchar2(300); a number; l_val varchar2(2000);'

Line 1142: ||' l_ac_seg FND_FLEX_EXT.SegmentArray ; l_ch_seg FND_FLEX_EXT.SegmentArray; begin '||l_str||' end;';

1138: ||'), l_ch_seg,'''||l_fd||'''); '
1139: ||'pqh_gen_form.g_'||l_col||' := l_val; ';
1140: --
1141: l_str:= 'declare j number := 0; l_a varchar2(300); a number; l_val varchar2(2000);'
1142: ||' l_ac_seg FND_FLEX_EXT.SegmentArray ; l_ch_seg FND_FLEX_EXT.SegmentArray; begin '||l_str||' end;';
1143: hr_utility.trace(substr(l_str,1,255));
1144: hr_utility.trace(substr(l_str,256,255));
1145: hr_utility.trace(substr(l_str,511,255));
1146: hr_utility.trace(substr(l_str,766,255));

Line 1171: l_ch_seg FND_FLEX_EXT.SegmentArray ;

1167: procedure concat_segs (p_trt_id in number, p_flex in varchar2, p_kf_num in varchar2, p_kd in varchar2)
1168: is
1169: l_str varchar2(32000);
1170: l_appl_id number(15) ;
1171: l_ch_seg FND_FLEX_EXT.SegmentArray ;
1172: l_ac_seg FND_FLEX_EXT.SegmentArray ;
1173:
1174: cursor c_sat(v_table_route_id number) is
1175: select sat.ddf_column_name ddf_column_name,

Line 1172: l_ac_seg FND_FLEX_EXT.SegmentArray ;

1168: is
1169: l_str varchar2(32000);
1170: l_appl_id number(15) ;
1171: l_ch_seg FND_FLEX_EXT.SegmentArray ;
1172: l_ac_seg FND_FLEX_EXT.SegmentArray ;
1173:
1174: cursor c_sat(v_table_route_id number) is
1175: select sat.ddf_column_name ddf_column_name,
1176: substr(pqh_generic.get_alias(column_name)

Line 1239: l_str:= l_str||'c := fnd_flex_ext.breakup_segments (nvl(pqh_gen_form.c_'||l.ch_col

1235: hr_utility.set_location(g_package||'create_target>>concat_segs: Entering',1);
1236:
1237: for l in c_change loop
1238:
1239: l_str:= l_str||'c := fnd_flex_ext.breakup_segments (nvl(pqh_gen_form.c_'||l.ch_col
1240: ||',pqh_gen_form.g_'||l.ac_col||'),'''||p_kd||''', l_ch_seg); '
1241: ||'a := fnd_flex_ext.breakup_segments (nvl(pqh_gen_form.g_'||l.ac_col
1242: ||',pqh_gen_form.c_'||l.ch_col||'),'''||p_kd||''', l_ac_seg); '
1243: ||' hr_utility.set_location(''dyn ch:''|| pqh_gen_form.c_'||l.ch_col||',1001);'

Line 1241: ||'a := fnd_flex_ext.breakup_segments (nvl(pqh_gen_form.g_'||l.ac_col

1237: for l in c_change loop
1238:
1239: l_str:= l_str||'c := fnd_flex_ext.breakup_segments (nvl(pqh_gen_form.c_'||l.ch_col
1240: ||',pqh_gen_form.g_'||l.ac_col||'),'''||p_kd||''', l_ch_seg); '
1241: ||'a := fnd_flex_ext.breakup_segments (nvl(pqh_gen_form.g_'||l.ac_col
1242: ||',pqh_gen_form.c_'||l.ch_col||'),'''||p_kd||''', l_ac_seg); '
1243: ||' hr_utility.set_location(''dyn ch:''|| pqh_gen_form.c_'||l.ch_col||',1001);'
1244: ||' hr_utility.set_location(''dyn ac:''|| pqh_gen_form.g_'||l.ac_col||',1002);'
1245: ||'for z in 1..c loop begin '

Line 1255: ||'l_val := fnd_flex_ext.concatenate_segments(c, l_ac_seg,'''||p_kd||'''); '

1251: ||'l_a := ''$PQH_unq$''; end ; '
1252: ||'if l_c <> l_a then if l_c <> ''$PQH_unq$'' then '
1253: ||'l_ac_seg(z) := l_c; elsif l_a <> ''$PQH_unq$'' then l_ac_seg(z) := l_a; '
1254: ||'else l_ac_seg(z) := null; end if; end if; end loop; '
1255: ||'l_val := fnd_flex_ext.concatenate_segments(c, l_ac_seg,'''||p_kd||'''); '
1256: ||'pqh_gen_form.g_'||l.ac_col||' := l_val; ';
1257: end loop;
1258: --
1259: if l_str is not null then

Line 1261: ||' l_ch_seg FND_FLEX_EXT.SegmentArray ; l_ac_seg FND_FLEX_EXT.SegmentArray ; begin '||l_str||' end;';

1257: end loop;
1258: --
1259: if l_str is not null then
1260: l_str:= 'declare j number := 0; l_a varchar2(300); l_c varchar2(300); a number; c number; l_val varchar2(2000);'
1261: ||' l_ch_seg FND_FLEX_EXT.SegmentArray ; l_ac_seg FND_FLEX_EXT.SegmentArray ; begin '||l_str||' end;';
1262: hr_utility.trace(substr(l_str,1,255));
1263: hr_utility.trace(substr(l_str,256,255));
1264: hr_utility.trace(substr(l_str,511,255));
1265: hr_utility.trace(substr(l_str,766,255));

Line 1293: l_str := 'declare j number := 0; l_val varchar2(2000); all_segs FND_FLEX_EXT.SegmentArray ; begin ';

1289: l_appl_id := 800 ;
1290: end if;
1291: --
1292: if p_kd is not null then
1293: l_str := 'declare j number := 0; l_val varchar2(2000); all_segs FND_FLEX_EXT.SegmentArray ; begin ';
1294: for k in c_kf_seg (p_flex, p_kf_num, l_appl_id) loop
1295: for i in c_sat(p_trt_id) loop
1296: if i.seg_no = k.seg_no then
1297: l_str := l_str ||' j:= j+1; all_segs(j):= pqh_gen_form.g_'||i.ddf_column_name||';';

Line 1303: l_str := l_str||' l_val := fnd_flex_ext.concatenate_segments(j, all_segs,'''||p_kd||''');'

1299: end loop;-- c_sat
1300: end loop;
1301: --
1302: for j in c_flex loop
1303: l_str := l_str||' l_val := fnd_flex_ext.concatenate_segments(j, all_segs,'''||p_kd||''');'
1304: ||' pqh_gen_form.g_'||j.ddf_column_name||' := l_val; end; ';
1305: end loop;
1306: --
1307: hr_utility.trace(substr(l_str,1,2000));