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 PQH_GEN_FORM

Line 1: Package Body PQH_GEN_FORM as

1: Package Body PQH_GEN_FORM as
2: /* $Header: pqgnfnf.pkb 120.2 2006/08/26 00:55:03 scnair noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- |-----------------------------< PQH_GEN_FORM >---------------------------------|

Line 5: -- |-----------------------------< PQH_GEN_FORM >---------------------------------|

1: Package Body PQH_GEN_FORM as
2: /* $Header: pqgnfnf.pkb 120.2 2006/08/26 00:55:03 scnair noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- |-----------------------------< PQH_GEN_FORM >---------------------------------|
6: -- ----------------------------------------------------------------------------
7: -- {Start Of Comments}
8: --
9: -- Created by : Sanej Nair (SCNair)

Line 25: g_package varchar2(80) := ' PQH_GEN_FORM.';

21: -- -------+-----------+--------------+----------------------------------------
22: -- 115.0 27-Feb-2000 Sanej Nair Initial Version
23: -- ==========================================================================
24:
25: g_package varchar2(80) := ' PQH_GEN_FORM.';
26: g_code varchar2(30) ;
27: g_meaning varchar2(240) ;
28: -- forllowing variables are for caching BG (context bg function usage)
29: g_private_bg_id number(15);

Line 194: and s.context = pqh_gen_form.g_gbl_context

190: where s.txn_category_attribute_id = c.txn_category_attribute_id
191: and c.attribute_id = a.attribute_id
192: and c.transaction_category_id = p_transaction_category_id
193: and s.attribute_type_cd = p_attribute_type_cd
194: and s.context = pqh_gen_form.g_gbl_context
195: and c.select_flag = 'Y'
196: and a.enable_flag = 'Y' ;
197: --
198: cursor c_session is

Line 240: pqh_gen_form.populate_context(rec.copy_entity_txn_id);

236: where current of c_session;
237: end if;
238: close c_session;
239: --
240: pqh_gen_form.populate_context(rec.copy_entity_txn_id);
241: --
242: if not(p_row_count) then
243:
244: hr_utility.set_location(g_package||'create_source: inside c_txn',2);

Line 267: if e_rec.context = pqh_gen_form.g_gbl_context then

263: -- cursor to pick the names of diplayable items on the form for given txn, responsibility etc.
264: --
265: for e_rec in c_sat('DISPLAY', rec.transaction_category_id) loop
266: hr_utility.set_location(g_package||'create_source: inside c_sat D',3);
267: if e_rec.context = pqh_gen_form.g_gbl_context then
268: if not( instr(l_ins, e_rec.ddf_column_name||'=>') <> 0 ) then
269: l_ins := l_ins ||
270: ',P_' ||e_rec.ddf_column_name||'=>i.'|| e_rec.alias;
271: end if; --instr(l_ins, e_rec.ddf_column_name) = 0

Line 286: ||' => rtrim(pqh_gen_form.get_value_from_id( i.'|| e_rec.alias

282: if e_rec.ddf_value_column_name is not null and e_rec.column_type <> 'D' then
283: if not( instr(l_ins, e_rec.ddf_value_column_name||'=>') <> 0 ) then
284: l_ins := l_ins ||
285: ',P_' ||e_rec.ddf_value_column_name
286: ||' => rtrim(pqh_gen_form.get_value_from_id( i.'|| e_rec.alias
287: ||','''||e_rec.value_set_id||'''))';
288: end if; --instr(l_ins, e_rec.ddf_column_name) = 0
289: end if; -- ddf_value_column_name
290: --

Line 301: if e_rec.context = pqh_gen_form.g_gbl_context then

297: -- cursor to pick the names of primary key items for given txn.
298: --
299: for e_rec in c_sat('PRIMARY_KEY', rec.transaction_category_id) loop
300: hr_utility.set_location(g_package||'create_source: inside c_sat P',3);
301: if e_rec.context = pqh_gen_form.g_gbl_context then
302: if not( instr(l_ins, e_rec.ddf_column_name||'=>') <> 0 ) then
303: l_ins := l_ins ||
304: ',P_' ||e_rec.ddf_column_name||'=>i.'|| e_rec.alias;
305: end if; --instr(l_ins, e_rec.ddf_column_name) = 0

Line 315: if e_rec.context = pqh_gen_form.g_gbl_context then

311: end loop ; -- c_sat primary_key
312: -- HIDDEN column addition
313: for e_rec in c_sat('HIDDEN', rec.transaction_category_id) loop
314: hr_utility.set_location(g_package||'create_source: inside c_sat H',31);
315: if e_rec.context = pqh_gen_form.g_gbl_context then
316: if not( instr(l_ins, e_rec.ddf_column_name||'=>') <> 0 ) then
317: l_ins := l_ins ||
318: ',P_' ||e_rec.ddf_column_name||'=>i.'|| e_rec.alias;
319: end if; --instr(l_ins, e_rec.ddf_column_name) = 0

Line 329: if e_rec.context = pqh_gen_form.g_gbl_context then

325: end loop ; -- c_sat HIDDEN column
326: -- SEGMENTs
327: for e_rec in c_sat('SEGMENT', rec.transaction_category_id) loop
328: hr_utility.set_location(g_package||'create_source: inside c_sat S',32);
329: if e_rec.context = pqh_gen_form.g_gbl_context then
330: if not( instr(l_ins, e_rec.ddf_column_name||'=>') <> 0 ) then
331: l_ins := l_ins ||
332: ',P_' ||e_rec.ddf_column_name||'=>i.'|| e_rec.alias;
333: end if; --instr(l_ins, e_rec.ddf_column_name) = 0

Line 362: if e_rec.context = pqh_gen_form.g_gbl_context then

358: --;
359: l_where := ' Where '||nvl(l_where, '1=1')||' ';
360: --
361: for e_rec in c_sat('CRITERIA', rec.transaction_category_id) loop
362: if e_rec.context = pqh_gen_form.g_gbl_context then
363: --
364: hr_utility.set_location(g_package||'create_source: inside c_sat 2',4);
365: for i in dec (e_rec.column_name, e_rec.ddf_column_name, rec.information1
366: ,rec.information2, rec.information3, rec.information4

Line 394: hr_utility.trace('BEGIN l_where PQH_GEN_FORM');

390: --
391: end if; -- for global context of txn_short_name
392: end loop ; -- c_sat changeable
393: hr_utility.set_location(g_package||'create_source: after c_dec ',6);
394: hr_utility.trace('BEGIN l_where PQH_GEN_FORM');
395: hr_utility.trace(substr(l_where,1,2000));
396: hr_utility.trace(substr(l_where,2001,2000));
397: hr_utility.trace(substr(l_where,4001,2000));
398: hr_utility.trace(substr(l_where,6001,2000));

Line 411: hr_utility.trace('END l_where PQH_GEN_FORM');

407: hr_utility.trace(substr(l_where,24001,2000));
408: hr_utility.trace(substr(l_where,26001,2000));
409: hr_utility.trace(substr(l_where,28001,2000));
410: hr_utility.trace(substr(l_where,30001,2000));
411: hr_utility.trace('END l_where PQH_GEN_FORM');
412: --
413: -- Replace where clause
414: --
415: if p_row_count then

Line 419: execute immediate 'begin select count(*) into pqh_gen_form.g_count from '||rec.from_clause ||l_where ||';'||

415: if p_row_count then
416: g_count := '';
417: g_msg := '';
418: hr_utility.set_location(g_package||'create_source: before count ',7);
419: execute immediate 'begin select count(*) into pqh_gen_form.g_count from '||rec.from_clause ||l_where ||';'||
420: ' exception when no_data_found then pqh_gen_form.g_count := 0;'||
421: ' when others then pqh_gen_form.g_msg := sqlerrm; end; ';
422: p_count := g_count;
423: p_msg := g_msg ;

Line 420: ' exception when no_data_found then pqh_gen_form.g_count := 0;'||

416: g_count := '';
417: g_msg := '';
418: hr_utility.set_location(g_package||'create_source: before count ',7);
419: execute immediate 'begin select count(*) into pqh_gen_form.g_count from '||rec.from_clause ||l_where ||';'||
420: ' exception when no_data_found then pqh_gen_form.g_count := 0;'||
421: ' when others then pqh_gen_form.g_msg := sqlerrm; end; ';
422: p_count := g_count;
423: p_msg := g_msg ;
424: else

Line 421: ' when others then pqh_gen_form.g_msg := sqlerrm; end; ';

417: g_msg := '';
418: hr_utility.set_location(g_package||'create_source: before count ',7);
419: execute immediate 'begin select count(*) into pqh_gen_form.g_count from '||rec.from_clause ||l_where ||';'||
420: ' exception when no_data_found then pqh_gen_form.g_count := 0;'||
421: ' when others then pqh_gen_form.g_msg := sqlerrm; end; ';
422: p_count := g_count;
423: p_msg := g_msg ;
424: else
425: l_ins := l_ins || ');';

Line 430: hr_utility.trace('BEGIN l_SEL PQH_GEN_FORM');

426: hr_utility.set_location(g_package||'create_source: after l_ins ',7);
427: l_sel := l_sel || ' from ' || rec.from_clause ||l_where||';' ;
428: hr_utility.set_location(g_package||'create_source: after l_sel ',8);
429: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
430: hr_utility.trace('BEGIN l_SEL PQH_GEN_FORM');
431: hr_utility.trace(substr(l_sel,1,2000));
432: hr_utility.trace(substr(l_sel,2001,2000));
433: hr_utility.trace(substr(l_sel,4001,2000));
434: hr_utility.trace(substr(l_sel,6001,2000));

Line 448: hr_utility.trace('END l_SEL PQH_GEN_FORM');

444: hr_utility.trace(substr(l_sel,26001,2000));
445: hr_utility.trace(substr(l_sel,28001,2000));
446: hr_utility.trace(substr(l_sel,30001,2000));
447: hr_utility.trace(substr(l_sel,32001,2000));
448: hr_utility.trace('END l_SEL PQH_GEN_FORM');
449: --
450: hr_utility.trace('BEGIN l_INS PQH_GEN_FORM');
451: hr_utility.trace(substr(l_ins,1,2000));
452: hr_utility.trace(substr(l_ins,2001,2000));

Line 450: hr_utility.trace('BEGIN l_INS PQH_GEN_FORM');

446: hr_utility.trace(substr(l_sel,30001,2000));
447: hr_utility.trace(substr(l_sel,32001,2000));
448: hr_utility.trace('END l_SEL PQH_GEN_FORM');
449: --
450: hr_utility.trace('BEGIN l_INS PQH_GEN_FORM');
451: hr_utility.trace(substr(l_ins,1,2000));
452: hr_utility.trace(substr(l_ins,2001,2000));
453: hr_utility.trace(substr(l_ins,4001,2000));
454: hr_utility.trace(substr(l_ins,6001,2000));

Line 468: hr_utility.trace('END l_INS PQH_GEN_FORM');

464: hr_utility.trace(substr(l_ins,26001,2000));
465: hr_utility.trace(substr(l_ins,28001,2000));
466: hr_utility.trace(substr(l_ins,30001,2000));
467: hr_utility.trace(substr(l_ins,32001,2000));
468: hr_utility.trace('END l_INS PQH_GEN_FORM');
469: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
470:
471: execute immediate 'declare l_var number; cursor c_a is '|| l_sel||' begin for i in c_a loop '
472: ||l_ins||' end loop; end;';

Line 875: and sat.context = pqh_gen_form.g_gbl_context

871: and tct.master_table_route_id = v_table_route_id
872: and tct.transaction_category_id = tca.transaction_category_id
873: and sat.txn_category_attribute_id = sat1.txn_category_attribute_id
874: and sat.context = sat1.context
875: and sat.context = pqh_gen_form.g_gbl_context
876: and tca.select_flag = 'Y'
877: and att.enable_flag = 'Y'
878: and sat.attribute_type_cd in ('DISPLAY')
879: and sat1.attribute_type_cd = 'CHANGEABLE'

Line 882: where context = pqh_gen_form.g_gbl_context

878: and sat.attribute_type_cd in ('DISPLAY')
879: and sat1.attribute_type_cd = 'CHANGEABLE'
880: and sat.txn_category_attribute_id not in
881: (select txn_category_attribute_id from pqh_special_attributes
882: where context = pqh_gen_form.g_gbl_context
883: and attribute_type_cd = 'KEY_FLEX');
884: --
885: cursor c_id (p_transaction_category_id in number) is
886: select upper(s.ddf_column_name ) ddf_column_name

Line 896: and s.context = pqh_gen_form.g_gbl_context

892: where s.txn_category_attribute_id = c.txn_category_attribute_id
893: and c.transaction_category_id = p_transaction_category_id
894: and s.ddf_column_name <> 'INFORMATION1'
895: and s.attribute_type_cd = 'DISPLAY'
896: and s.context = pqh_gen_form.g_gbl_context
897: and c.value_set_id is not null
898: and s.ddf_value_column_name is not null ;
899: --
900: procedure apply_changes

Line 905: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);

901: is
902: l_changeable_column_name varchar2(80);
903: begin
904: hr_utility.set_location(g_package||'Create_target>>apply_changes: Entering',1);
905: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
906: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
907: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
908: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
909: for k in 1..180 loop

Line 906: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);

902: l_changeable_column_name varchar2(80);
903: begin
904: hr_utility.set_location(g_package||'Create_target>>apply_changes: Entering',1);
905: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
906: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
907: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
908: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
909: for k in 1..180 loop
910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop

Line 907: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);

903: begin
904: hr_utility.set_location(g_package||'Create_target>>apply_changes: Entering',1);
905: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
906: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
907: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
908: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
909: for k in 1..180 loop
910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop
911: begin

Line 908: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);

904: hr_utility.set_location(g_package||'Create_target>>apply_changes: Entering',1);
905: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
906: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
907: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
908: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
909: for k in 1..180 loop
910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop
911: begin
912: if pqh_gen_form.g_attrib_tab(j).ddf_column_name = 'INFORMATION'||to_char(k) then

Line 910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop

906: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
907: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
908: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
909: for k in 1..180 loop
910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop
911: begin
912: if pqh_gen_form.g_attrib_tab(j).ddf_column_name = 'INFORMATION'||to_char(k) then
913: l_changeable_column_name := pqh_gen_form.g_attrib_tab(j).changeable_column_name ;
914: hr_utility.set_location(l_changeable_column_name||'->'||pqh_gen_form.g_attrib_tab(j).ddf_column_name,111);

Line 912: if pqh_gen_form.g_attrib_tab(j).ddf_column_name = 'INFORMATION'||to_char(k) then

908: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
909: for k in 1..180 loop
910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop
911: begin
912: if pqh_gen_form.g_attrib_tab(j).ddf_column_name = 'INFORMATION'||to_char(k) then
913: l_changeable_column_name := pqh_gen_form.g_attrib_tab(j).changeable_column_name ;
914: hr_utility.set_location(l_changeable_column_name||'->'||pqh_gen_form.g_attrib_tab(j).ddf_column_name,111);
915: --
916: -- Bug 5249887: dynamic select into has been failing for some unknown reason; alternative assignment seems to work.

Line 913: l_changeable_column_name := pqh_gen_form.g_attrib_tab(j).changeable_column_name ;

909: for k in 1..180 loop
910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop
911: begin
912: if pqh_gen_form.g_attrib_tab(j).ddf_column_name = 'INFORMATION'||to_char(k) then
913: l_changeable_column_name := pqh_gen_form.g_attrib_tab(j).changeable_column_name ;
914: hr_utility.set_location(l_changeable_column_name||'->'||pqh_gen_form.g_attrib_tab(j).ddf_column_name,111);
915: --
916: -- Bug 5249887: dynamic select into has been failing for some unknown reason; alternative assignment seems to work.
917: -- execute immediate 'begin select nvl(pqh_gen_form.c_'||l_changeable_column_name

Line 914: hr_utility.set_location(l_changeable_column_name||'->'||pqh_gen_form.g_attrib_tab(j).ddf_column_name,111);

910: for j in nvl(PQH_GEN_FORM.g_attrib_tab.first,0)..nvl(PQH_GEN_FORM.g_attrib_tab.last,-1) loop
911: begin
912: if pqh_gen_form.g_attrib_tab(j).ddf_column_name = 'INFORMATION'||to_char(k) then
913: l_changeable_column_name := pqh_gen_form.g_attrib_tab(j).changeable_column_name ;
914: hr_utility.set_location(l_changeable_column_name||'->'||pqh_gen_form.g_attrib_tab(j).ddf_column_name,111);
915: --
916: -- Bug 5249887: dynamic select into has been failing for some unknown reason; alternative assignment seems to work.
917: -- execute immediate 'begin select nvl(pqh_gen_form.c_'||l_changeable_column_name
918: -- ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||') into '

Line 917: -- execute immediate 'begin select nvl(pqh_gen_form.c_'||l_changeable_column_name

913: l_changeable_column_name := pqh_gen_form.g_attrib_tab(j).changeable_column_name ;
914: hr_utility.set_location(l_changeable_column_name||'->'||pqh_gen_form.g_attrib_tab(j).ddf_column_name,111);
915: --
916: -- Bug 5249887: dynamic select into has been failing for some unknown reason; alternative assignment seems to work.
917: -- execute immediate 'begin select nvl(pqh_gen_form.c_'||l_changeable_column_name
918: -- ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||') into '
919: -- || 'pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
920: -- || ' from fnd_dual where rownum < 2; end;';
921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name

Line 918: -- ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||') into '

914: hr_utility.set_location(l_changeable_column_name||'->'||pqh_gen_form.g_attrib_tab(j).ddf_column_name,111);
915: --
916: -- Bug 5249887: dynamic select into has been failing for some unknown reason; alternative assignment seems to work.
917: -- execute immediate 'begin select nvl(pqh_gen_form.c_'||l_changeable_column_name
918: -- ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||') into '
919: -- || 'pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
920: -- || ' from fnd_dual where rownum < 2; end;';
921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name

Line 919: -- || 'pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name

915: --
916: -- Bug 5249887: dynamic select into has been failing for some unknown reason; alternative assignment seems to work.
917: -- execute immediate 'begin select nvl(pqh_gen_form.c_'||l_changeable_column_name
918: -- ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||') into '
919: -- || 'pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
920: -- || ' from fnd_dual where rownum < 2; end;';
921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
923: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;';

Line 921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name

917: -- execute immediate 'begin select nvl(pqh_gen_form.c_'||l_changeable_column_name
918: -- ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||') into '
919: -- || 'pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
920: -- || ' from fnd_dual where rownum < 2; end;';
921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
923: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;';
924:
925: hr_utility.set_location( nvl(pqh_gen_form.c_information1,'Info 1')||'='

Line 922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name

918: -- ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||') into '
919: -- || 'pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
920: -- || ' from fnd_dual where rownum < 2; end;';
921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
923: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;';
924:
925: hr_utility.set_location( nvl(pqh_gen_form.c_information1,'Info 1')||'='
926: ||pqh_gen_form.g_attrib_tab(j).ddf_column_name ,112);

Line 923: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;';

919: -- || 'pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
920: -- || ' from fnd_dual where rownum < 2; end;';
921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
923: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;';
924:
925: hr_utility.set_location( nvl(pqh_gen_form.c_information1,'Info 1')||'='
926: ||pqh_gen_form.g_attrib_tab(j).ddf_column_name ,112);
927: exit;

Line 925: hr_utility.set_location( nvl(pqh_gen_form.c_information1,'Info 1')||'='

921: execute immediate 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
923: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;';
924:
925: hr_utility.set_location( nvl(pqh_gen_form.c_information1,'Info 1')||'='
926: ||pqh_gen_form.g_attrib_tab(j).ddf_column_name ,112);
927: exit;
928: end if;
929: exception when no_data_found then

Line 926: ||pqh_gen_form.g_attrib_tab(j).ddf_column_name ,112);

922: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
923: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;';
924:
925: hr_utility.set_location( nvl(pqh_gen_form.c_information1,'Info 1')||'='
926: ||pqh_gen_form.g_attrib_tab(j).ddf_column_name ,112);
927: exit;
928: end if;
929: exception when no_data_found then
930: hr_utility.set_location('no data on-'||j,113);

Line 932: hr_utility.trace( 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name

928: end if;
929: exception when no_data_found then
930: hr_utility.set_location('no data on-'||j,113);
931: hr_utility.trace(substr(sqlerrm,1,255));
932: hr_utility.trace( 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
933: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
934: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;');
935: end;
936: end loop; -- g_attrib_tab scan

Line 933: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name

929: exception when no_data_found then
930: hr_utility.set_location('no data on-'||j,113);
931: hr_utility.trace(substr(sqlerrm,1,255));
932: hr_utility.trace( 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
933: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
934: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;');
935: end;
936: end loop; -- g_attrib_tab scan
937: end loop; -- source information scan

Line 934: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;');

930: hr_utility.set_location('no data on-'||j,113);
931: hr_utility.trace(substr(sqlerrm,1,255));
932: hr_utility.trace( 'begin pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name
933: ||':= nvl(pqh_gen_form.c_'||l_changeable_column_name
934: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;');
935: end;
936: end loop; -- g_attrib_tab scan
937: end loop; -- source information scan
938: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);

Line 938: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);

934: ||',pqh_gen_form.g_'||pqh_gen_form.g_attrib_tab(j).ddf_column_name ||'); end;');
935: end;
936: end loop; -- g_attrib_tab scan
937: end loop; -- source information scan
938: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
939: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
940: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
941: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
942: --l_changeable_column_name := pqh_gen_form.g_attrib_tab(1000).changeable_column_name ;

Line 939: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);

935: end;
936: end loop; -- g_attrib_tab scan
937: end loop; -- source information scan
938: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
939: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
940: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
941: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
942: --l_changeable_column_name := pqh_gen_form.g_attrib_tab(1000).changeable_column_name ;
943: hr_utility.set_location(g_package||'Create_target>>apply_changes: Leaving',1);

Line 940: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);

936: end loop; -- g_attrib_tab scan
937: end loop; -- source information scan
938: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
939: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
940: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
941: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
942: --l_changeable_column_name := pqh_gen_form.g_attrib_tab(1000).changeable_column_name ;
943: hr_utility.set_location(g_package||'Create_target>>apply_changes: Leaving',1);
944: end apply_changes ;

Line 941: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);

937: end loop; -- source information scan
938: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
939: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
940: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
941: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
942: --l_changeable_column_name := pqh_gen_form.g_attrib_tab(1000).changeable_column_name ;
943: hr_utility.set_location(g_package||'Create_target>>apply_changes: Leaving',1);
944: end apply_changes ;
945: --

Line 942: --l_changeable_column_name := pqh_gen_form.g_attrib_tab(1000).changeable_column_name ;

938: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
939: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
940: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
941: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
942: --l_changeable_column_name := pqh_gen_form.g_attrib_tab(1000).changeable_column_name ;
943: hr_utility.set_location(g_package||'Create_target>>apply_changes: Leaving',1);
944: end apply_changes ;
945: --
946: procedure apply_kf (p_flex in varchar2, p_ite in varchar2)

Line 962: and sat.context = pqh_gen_form.g_gbl_context

958: and tca.select_flag = 'Y'
959: and att.enable_flag = 'Y'
960: and sat.attribute_type_cd = 'SEGMENT'
961: and sat.flex_code = p_flex
962: and sat.context = pqh_gen_form.g_gbl_context
963: order by to_number(substr(column_name,instr(column_name,'SEGMENT')+7,2)) ;
964: begin
965: hr_utility.set_location(g_package||'create_target>>apply_kf: Entering',1);
966: --

Line 968: l_str := l_str ||'pqh_gen_form.g_'||i.ddf_column_name ||' := nvl(pqh_gen_form.k'||p_ite||'_information'||i.nos

964: begin
965: hr_utility.set_location(g_package||'create_target>>apply_kf: Entering',1);
966: --
967: for i in c_sat loop
968: l_str := l_str ||'pqh_gen_form.g_'||i.ddf_column_name ||' := nvl(pqh_gen_form.k'||p_ite||'_information'||i.nos
969: ||',pqh_gen_form.g_'||i.ddf_column_name ||');';
970: end loop;
971:
972: if l_str is not null then

Line 969: ||',pqh_gen_form.g_'||i.ddf_column_name ||');';

965: hr_utility.set_location(g_package||'create_target>>apply_kf: Entering',1);
966: --
967: for i in c_sat loop
968: l_str := l_str ||'pqh_gen_form.g_'||i.ddf_column_name ||' := nvl(pqh_gen_form.k'||p_ite||'_information'||i.nos
969: ||',pqh_gen_form.g_'||i.ddf_column_name ||');';
970: end loop;
971:
972: if l_str is not null then
973: l_str := 'Begin '||l_str||' end;';

Line 1025: , pqh_gen_form.get_segment(ata.column_name) segment

1021: , nvl(upper(st.ddf_value_column_name), upper(st.ddf_column_name)) col_name
1022: , tc.value_set_id
1023: , upper(st.ddf_value_column_name) ddf_value_column_name
1024: , st.attribute_type_cd, st.flex_code
1025: , pqh_gen_form.get_segment(ata.column_name) segment
1026: from pqh_special_attributes st,
1027: pqh_txn_category_attributes tc,
1028: pqh_attributes ata
1029: where st.txn_category_attribute_id = tc.txn_category_attribute_id

Line 1032: and st.context = pqh_gen_form.g_gbl_context

1028: pqh_attributes ata
1029: where st.txn_category_attribute_id = tc.txn_category_attribute_id
1030: and ata.attribute_id = tc.attribute_id
1031: and st.attribute_type_cd in ('SEGMENT','DISPLAY')
1032: and st.context = pqh_gen_form.g_gbl_context
1033: and tc.select_flag = 'Y'
1034: and ata.enable_flag = 'Y'
1035: and st.txn_category_attribute_id in
1036: (select sat.txn_category_attribute_id

Line 1038: where sat.context = pqh_gen_form.g_gbl_context

1034: and ata.enable_flag = 'Y'
1035: and st.txn_category_attribute_id in
1036: (select sat.txn_category_attribute_id
1037: from pqh_special_attributes sat
1038: where sat.context = pqh_gen_form.g_gbl_context
1039: and sat.attribute_type_cd = 'CHANGEABLE'
1040: and sat.txn_category_attribute_id = p_txn_category_attribute_id ); -- special_attribute
1041: --
1042: cursor c_kf_seg (v_id_fc in varchar2, v_id_fn in varchar2, v_appl_id in number)is

Line 1058: and context = pqh_gen_form.g_gbl_context

1054: --
1055: cursor c_col (p_flex in varchar2) is
1056: select ddf_column_name from pqh_special_attributes
1057: where flex_code = p_flex
1058: and context = pqh_gen_form.g_gbl_context
1059: and attribute_type_cd = 'KEY_FLEX' ;
1060: begin
1061: hr_utility.set_location(g_package||'create_target>>apply_special_attribs: Entering',1);
1062: for rec in c_sat loop

Line 1064: execute immediate 'begin pqh_gen_form.g_initial_value := replace(pqh_gen_form.g_'||rec.col_name|| ','''''''','''''''''''') ; end;';

1060: begin
1061: hr_utility.set_location(g_package||'create_target>>apply_special_attribs: Entering',1);
1062: for rec in c_sat loop
1063: if p_index = 1 then
1064: execute immediate 'begin pqh_gen_form.g_initial_value := replace(pqh_gen_form.g_'||rec.col_name|| ','''''''','''''''''''') ; end;';
1065: end if;
1066: --
1067: begin
1068: if to_number(l_start_with) = 0 or true then

Line 1088: l_id_from_value := pqh_gen_form.get_id_from_value(p_value => l_cat_value

1084: end if;
1085: --
1086: if rec.ddf_value_column_name is not null and
1087: rec.value_set_id is not null then
1088: l_id_from_value := pqh_gen_form.get_id_from_value(p_value => l_cat_value
1089: ,p_vset_id => rec.value_set_id);
1090: if l_cat_value is not null and
1091: l_id_from_value is not null then
1092: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_column_name ||' :='''|| l_id_from_value||''';'||

Line 1092: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_column_name ||' :='''|| l_id_from_value||''';'||

1088: l_id_from_value := pqh_gen_form.get_id_from_value(p_value => l_cat_value
1089: ,p_vset_id => rec.value_set_id);
1090: if l_cat_value is not null and
1091: l_id_from_value is not null then
1092: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_column_name ||' :='''|| l_id_from_value||''';'||
1093: 'pqh_gen_form.g_'||rec.ddf_value_column_name ||' :='''|| l_cat_value||'''; end;';
1094: else
1095: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_value_column_name||' :='''||g_initial_value||'''; end;';
1096: l_warn := '0';

Line 1093: 'pqh_gen_form.g_'||rec.ddf_value_column_name ||' :='''|| l_cat_value||'''; end;';

1089: ,p_vset_id => rec.value_set_id);
1090: if l_cat_value is not null and
1091: l_id_from_value is not null then
1092: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_column_name ||' :='''|| l_id_from_value||''';'||
1093: 'pqh_gen_form.g_'||rec.ddf_value_column_name ||' :='''|| l_cat_value||'''; end;';
1094: else
1095: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_value_column_name||' :='''||g_initial_value||'''; end;';
1096: l_warn := '0';
1097: end if;

Line 1095: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_value_column_name||' :='''||g_initial_value||'''; end;';

1091: l_id_from_value is not null then
1092: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_column_name ||' :='''|| l_id_from_value||''';'||
1093: 'pqh_gen_form.g_'||rec.ddf_value_column_name ||' :='''|| l_cat_value||'''; end;';
1094: else
1095: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_value_column_name||' :='''||g_initial_value||'''; end;';
1096: l_warn := '0';
1097: end if;
1098: elsif rec.ddf_value_column_name is null and
1099: l_cat_value is not null then

Line 1100: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_column_name ||' :='''|| l_cat_value||'''; end;';

1096: l_warn := '0';
1097: end if;
1098: elsif rec.ddf_value_column_name is null and
1099: l_cat_value is not null then
1100: execute immediate 'begin pqh_gen_form.g_'||rec.ddf_column_name ||' :='''|| l_cat_value||'''; end;';
1101: end if;
1102: --
1103: if rec.attribute_type_cd = 'SEGMENT' then
1104: hr_utility.set_location(g_package||'create_target>>apply_special_attribs: Kf segment',5);

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 1135: ||' hr_utility.set_location(''dyn ac:''|| pqh_gen_form.g_'||l_col||',2001);'

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);'
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; ';

Line 1139: ||'pqh_gen_form.g_'||l_col||' := l_val; ';

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);'
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));

Line 1188: and sat.context = pqh_gen_form.g_gbl_context

1184: and tca.select_flag = 'Y'
1185: and att.enable_flag = 'Y'
1186: and sat.attribute_type_cd = 'SEGMENT'
1187: and sat.flex_code = p_flex
1188: and sat.context = pqh_gen_form.g_gbl_context
1189: order by to_number(substr(pqh_generic.get_alias(column_name)
1190: ,instr(upper(pqh_generic.get_alias(column_name)),'SEGMENT')+7)) ;
1191:
1192: cursor c_flex is

Line 1203: and sat.context = pqh_gen_form.g_gbl_context ;

1199: and tca.select_flag = 'Y'
1200: and att.enable_flag = 'Y'
1201: and sat.attribute_type_cd = 'KEY_FLEX'
1202: and sat.flex_code = p_flex
1203: and sat.context = pqh_gen_form.g_gbl_context ;
1204:
1205: cursor c_kf_seg (v_id_fc in varchar2, v_id_fn in varchar2, v_appl_id in number)is
1206: select application_column_name,
1207: segment_num,

Line 1231: and sat2.context = pqh_gen_form.g_gbl_context

1227: and att.enable_flag = 'Y'
1228: and sat.attribute_type_cd = 'KEY_FLEX'
1229: and sat2.attribute_type_cd = 'CHANGEABLE'
1230: and sat.flex_code = p_flex
1231: and sat2.context = pqh_gen_form.g_gbl_context
1232: and sat.context = pqh_gen_form.g_gbl_context ;
1233:
1234: begin
1235: hr_utility.set_location(g_package||'create_target>>concat_segs: Entering',1);

Line 1232: and sat.context = pqh_gen_form.g_gbl_context ;

1228: and sat.attribute_type_cd = 'KEY_FLEX'
1229: and sat2.attribute_type_cd = 'CHANGEABLE'
1230: and sat.flex_code = p_flex
1231: and sat2.context = pqh_gen_form.g_gbl_context
1232: and sat.context = pqh_gen_form.g_gbl_context ;
1233:
1234: begin
1235: hr_utility.set_location(g_package||'create_target>>concat_segs: Entering',1);
1236:

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 1240: ||',pqh_gen_form.g_'||l.ac_col||'),'''||p_kd||''', l_ch_seg); '

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);'
1244: ||' hr_utility.set_location(''dyn ac:''|| pqh_gen_form.g_'||l.ac_col||',1002);'

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 1242: ||',pqh_gen_form.c_'||l.ch_col||'),'''||p_kd||''', l_ac_seg); '

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 '
1246: ||'l_c := nvl(l_ch_seg(z),''$PQH_unq$''); '

Line 1243: ||' hr_utility.set_location(''dyn ch:''|| pqh_gen_form.c_'||l.ch_col||',1001);'

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 '
1246: ||'l_c := nvl(l_ch_seg(z),''$PQH_unq$''); '
1247: ||'exception when no_data_found then '

Line 1244: ||' hr_utility.set_location(''dyn ac:''|| pqh_gen_form.g_'||l.ac_col||',1002);'

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 '
1246: ||'l_c := nvl(l_ch_seg(z),''$PQH_unq$''); '
1247: ||'exception when no_data_found then '
1248: ||'l_c := ''$PQH_unq$''; end ; begin '

Line 1256: ||'pqh_gen_form.g_'||l.ac_col||' := l_val; ';

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
1260: l_str:= 'declare j number := 0; l_a varchar2(300); l_c varchar2(300); a number; c number; l_val varchar2(2000);'

Line 1297: l_str := l_str ||' j:= j+1; all_segs(j):= pqh_gen_form.g_'||i.ddf_column_name||';';

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||';';
1298: end if;
1299: end loop;-- c_sat
1300: end loop;
1301: --

Line 1304: ||' pqh_gen_form.g_'||j.ddf_column_name||' := l_val; end; ';

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));
1308: execute immediate l_str;

Line 1329: pqh_gen_form.populate_context(p_copy_entity_txn_id);

1325: l_start_with := rec.start_with ;
1326: l_increment_by := rec.increment_by ;
1327: l_mast_trt_id := rec.master_table_route_id ;
1328: l_transaction_id := rec.transaction_category_id ;
1329: pqh_gen_form.populate_context(p_copy_entity_txn_id);
1330: exit ; -- should ideally loop only once
1331: end loop ; -- c_txn
1332: hr_utility.set_location(g_package||'create_target: Clear Table',10);
1333: --

Line 1334: PQH_GEN_FORM.g_attrib_tab.delete; -- clear table

1330: exit ; -- should ideally loop only once
1331: end loop ; -- c_txn
1332: hr_utility.set_location(g_package||'create_target: Clear Table',10);
1333: --
1334: PQH_GEN_FORM.g_attrib_tab.delete; -- clear table
1335: --
1336: hr_utility.set_location(g_package||'create_target: c_attrib',1);
1337: hr_utility.set_location(' context: '||pqh_gen_form.g_context,11);
1338: for rec in c_attrib(l_mast_trt_id) loop

Line 1337: hr_utility.set_location(' context: '||pqh_gen_form.g_context,11);

1333: --
1334: PQH_GEN_FORM.g_attrib_tab.delete; -- clear table
1335: --
1336: hr_utility.set_location(g_package||'create_target: c_attrib',1);
1337: hr_utility.set_location(' context: '||pqh_gen_form.g_context,11);
1338: for rec in c_attrib(l_mast_trt_id) loop
1339: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).column_alias := rec.column_alias ;
1340: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).ddf_column_name := rec.ddf_column_name ;
1341: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).changeable_column_name := rec.changeable_column_name ;

Line 1339: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).column_alias := rec.column_alias ;

1335: --
1336: hr_utility.set_location(g_package||'create_target: c_attrib',1);
1337: hr_utility.set_location(' context: '||pqh_gen_form.g_context,11);
1338: for rec in c_attrib(l_mast_trt_id) loop
1339: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).column_alias := rec.column_alias ;
1340: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).ddf_column_name := rec.ddf_column_name ;
1341: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).changeable_column_name := rec.changeable_column_name ;
1342: end loop; -- c_attrib
1343: --

Line 1340: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).ddf_column_name := rec.ddf_column_name ;

1336: hr_utility.set_location(g_package||'create_target: c_attrib',1);
1337: hr_utility.set_location(' context: '||pqh_gen_form.g_context,11);
1338: for rec in c_attrib(l_mast_trt_id) loop
1339: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).column_alias := rec.column_alias ;
1340: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).ddf_column_name := rec.ddf_column_name ;
1341: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).changeable_column_name := rec.changeable_column_name ;
1342: end loop; -- c_attrib
1343: --
1344: hr_utility.set_location(g_package||'create_target: c_change',11);

Line 1341: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).changeable_column_name := rec.changeable_column_name ;

1337: hr_utility.set_location(' context: '||pqh_gen_form.g_context,11);
1338: for rec in c_attrib(l_mast_trt_id) loop
1339: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).column_alias := rec.column_alias ;
1340: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).ddf_column_name := rec.ddf_column_name ;
1341: pqh_gen_form.g_attrib_tab(c_attrib%rowcount).changeable_column_name := rec.changeable_column_name ;
1342: end loop; -- c_attrib
1343: --
1344: hr_utility.set_location(g_package||'create_target: c_change',11);
1345: for rec in c_change loop

Line 1381: -- execute immediate 'begin pqh_gen_form.c_information20 := pqh_gen_form.c_information'||i||'; end;';

1377: exit ; -- should ideally have only one record.
1378: --
1379: end loop ; -- rec in c_change
1380: --for i in 1..30 loop
1381: -- execute immediate 'begin pqh_gen_form.c_information20 := pqh_gen_form.c_information'||i||'; end;';
1382: -- hr_utility.set_location('attrib table: c_information'||i||' '||pqh_gen_form.c_information20,12);
1383: --end loop;
1384: --
1385: if p_lf1 is not null then

Line 1382: -- hr_utility.set_location('attrib table: c_information'||i||' '||pqh_gen_form.c_information20,12);

1378: --
1379: end loop ; -- rec in c_change
1380: --for i in 1..30 loop
1381: -- execute immediate 'begin pqh_gen_form.c_information20 := pqh_gen_form.c_information'||i||'; end;';
1382: -- hr_utility.set_location('attrib table: c_information'||i||' '||pqh_gen_form.c_information20,12);
1383: --end loop;
1384: --
1385: if p_lf1 is not null then
1386: for rec in c_ch_kf (p_lf1) loop

Line 1660: execute immediate 'begin pqh_gen_form.g_'||e_rec.ddf_value_column_name ||':= rtrim('

1656: end if;
1657: --
1658: hr_utility.set_location(g_package||'create_target: l_copies',13);
1659: for e_rec in c_id(l_transaction_id) loop
1660: execute immediate 'begin pqh_gen_form.g_'||e_rec.ddf_value_column_name ||':= rtrim('
1661: ||'pqh_gen_form.get_value_from_id(pqh_gen_form.g_'||e_rec.ddf_column_name ||','''
1662: ||e_rec.value_set_id||''')); end;';
1663: hr_utility.trace('Tgt Loop : '||e_rec.ddf_value_column_name ||' - '||e_rec.ddf_column_name);
1664: end loop; --c_id

Line 1661: ||'pqh_gen_form.get_value_from_id(pqh_gen_form.g_'||e_rec.ddf_column_name ||','''

1657: --
1658: hr_utility.set_location(g_package||'create_target: l_copies',13);
1659: for e_rec in c_id(l_transaction_id) loop
1660: execute immediate 'begin pqh_gen_form.g_'||e_rec.ddf_value_column_name ||':= rtrim('
1661: ||'pqh_gen_form.get_value_from_id(pqh_gen_form.g_'||e_rec.ddf_column_name ||','''
1662: ||e_rec.value_set_id||''')); end;';
1663: hr_utility.trace('Tgt Loop : '||e_rec.ddf_value_column_name ||' - '||e_rec.ddf_column_name);
1664: end loop; --c_id
1665: --

Line 1666: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);

1662: ||e_rec.value_set_id||''')); end;';
1663: hr_utility.trace('Tgt Loop : '||e_rec.ddf_value_column_name ||' - '||e_rec.ddf_column_name);
1664: end loop; --c_id
1665: --
1666: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1667: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1668: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1669: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1670: for i in 1..l_copies loop

Line 1667: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);

1663: hr_utility.trace('Tgt Loop : '||e_rec.ddf_value_column_name ||' - '||e_rec.ddf_column_name);
1664: end loop; --c_id
1665: --
1666: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1667: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1668: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1669: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1670: for i in 1..l_copies loop
1671:

Line 1668: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);

1664: end loop; --c_id
1665: --
1666: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1667: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1668: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1669: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1670: for i in 1..l_copies loop
1671:
1672: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);

Line 1669: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);

1665: --
1666: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1667: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1668: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1669: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1670: for i in 1..l_copies loop
1671:
1672: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1673: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);

Line 1672: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);

1668: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1669: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1670: for i in 1..l_copies loop
1671:
1672: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1673: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1674: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1675: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1676: apply_special_attrib ( p_txn_category_attribute_id => l_txn_category_attribute_id

Line 1673: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);

1669: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1670: for i in 1..l_copies loop
1671:
1672: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1673: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1674: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1675: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1676: apply_special_attrib ( p_txn_category_attribute_id => l_txn_category_attribute_id
1677: , p_index => i

Line 1674: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);

1670: for i in 1..l_copies loop
1671:
1672: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1673: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1674: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1675: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1676: apply_special_attrib ( p_txn_category_attribute_id => l_txn_category_attribute_id
1677: , p_index => i
1678: , p_replacement_type_cd => l_replacement_type_cd

Line 1675: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);

1671:
1672: hr_utility.set_location('Infor 1 '||pqh_gen_form.g_information1,1);
1673: hr_utility.set_location('Infor 3 '||pqh_gen_form.g_information3,1);
1674: hr_utility.set_location('Infor 4 '||pqh_gen_form.g_information4,1);
1675: hr_utility.set_location('C Infor 2 '||pqh_gen_form.c_information2,1);
1676: apply_special_attrib ( p_txn_category_attribute_id => l_txn_category_attribute_id
1677: , p_index => i
1678: , p_replacement_type_cd => l_replacement_type_cd
1679: , p_start_with => l_start_with

Line 1945: ||' into pqh_gen_form.g_v_id, pqh_gen_form.g_v_value '

1941: l_whr := 'Where '||l_col || p_add_where_clause||' and rownum < 2 ' ;
1942: end if;
1943: l_str := 'select '||l_v_r.table_info.id_column_name||','
1944: ||l_v_r.table_info.value_column_name
1945: ||' into pqh_gen_form.g_v_id, pqh_gen_form.g_v_value '
1946: ||' from '
1947: ||l_v_r.table_info.table_name||' '||l_whr;
1948: --
1949: else

Line 1966: pqh_gen_form.g_v_value := '';

1962: p_vset_id in varchar2) return varchar2 is
1963: l_sql varchar2(4000);
1964: l_cnt number;
1965: begin
1966: pqh_gen_form.g_v_value := '';
1967: if p_id is null then
1968: return('');
1969: end if;
1970: --

Line 1976: l_cnt := pqh_gen_form.g_vset_tab.count ;

1972: return(p_id);
1973: end if;
1974: --
1975: begin
1976: l_cnt := pqh_gen_form.g_vset_tab.count ;
1977: for j in nvl(PQH_GEN_FORM.g_vset_tab.first,0)..nvl(PQH_GEN_FORM.g_vset_tab.last,-1) loop
1978: if pqh_gen_form.g_vset_tab(j).vset_id = p_vset_id then
1979: if pqh_gen_form.g_vset_tab(j).code = p_id then
1980: return(pqh_gen_form.g_vset_tab(j).meaning);

Line 1977: for j in nvl(PQH_GEN_FORM.g_vset_tab.first,0)..nvl(PQH_GEN_FORM.g_vset_tab.last,-1) loop

1973: end if;
1974: --
1975: begin
1976: l_cnt := pqh_gen_form.g_vset_tab.count ;
1977: for j in nvl(PQH_GEN_FORM.g_vset_tab.first,0)..nvl(PQH_GEN_FORM.g_vset_tab.last,-1) loop
1978: if pqh_gen_form.g_vset_tab(j).vset_id = p_vset_id then
1979: if pqh_gen_form.g_vset_tab(j).code = p_id then
1980: return(pqh_gen_form.g_vset_tab(j).meaning);
1981: end if;

Line 1978: if pqh_gen_form.g_vset_tab(j).vset_id = p_vset_id then

1974: --
1975: begin
1976: l_cnt := pqh_gen_form.g_vset_tab.count ;
1977: for j in nvl(PQH_GEN_FORM.g_vset_tab.first,0)..nvl(PQH_GEN_FORM.g_vset_tab.last,-1) loop
1978: if pqh_gen_form.g_vset_tab(j).vset_id = p_vset_id then
1979: if pqh_gen_form.g_vset_tab(j).code = p_id then
1980: return(pqh_gen_form.g_vset_tab(j).meaning);
1981: end if;
1982: end if;

Line 1979: if pqh_gen_form.g_vset_tab(j).code = p_id then

1975: begin
1976: l_cnt := pqh_gen_form.g_vset_tab.count ;
1977: for j in nvl(PQH_GEN_FORM.g_vset_tab.first,0)..nvl(PQH_GEN_FORM.g_vset_tab.last,-1) loop
1978: if pqh_gen_form.g_vset_tab(j).vset_id = p_vset_id then
1979: if pqh_gen_form.g_vset_tab(j).code = p_id then
1980: return(pqh_gen_form.g_vset_tab(j).meaning);
1981: end if;
1982: end if;
1983: end loop;

Line 1980: return(pqh_gen_form.g_vset_tab(j).meaning);

1976: l_cnt := pqh_gen_form.g_vset_tab.count ;
1977: for j in nvl(PQH_GEN_FORM.g_vset_tab.first,0)..nvl(PQH_GEN_FORM.g_vset_tab.last,-1) loop
1978: if pqh_gen_form.g_vset_tab(j).vset_id = p_vset_id then
1979: if pqh_gen_form.g_vset_tab(j).code = p_id then
1980: return(pqh_gen_form.g_vset_tab(j).meaning);
1981: end if;
1982: end if;
1983: end loop;
1984: exception when no_data_found then null; -- in case the table is yet to be populated

Line 1993: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).vset_id := p_vset_id;

1989: p_where_on_id => true );
1990: --
1991: execute immediate 'Begin '||l_sql ||'; end;';
1992: --
1993: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).vset_id := p_vset_id;
1994: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).code := p_id;
1995: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).meaning := pqh_gen_form.g_v_value;
1996: --
1997: return(pqh_gen_form.g_v_value);

Line 1994: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).code := p_id;

1990: --
1991: execute immediate 'Begin '||l_sql ||'; end;';
1992: --
1993: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).vset_id := p_vset_id;
1994: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).code := p_id;
1995: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).meaning := pqh_gen_form.g_v_value;
1996: --
1997: return(pqh_gen_form.g_v_value);
1998: --

Line 1995: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).meaning := pqh_gen_form.g_v_value;

1991: execute immediate 'Begin '||l_sql ||'; end;';
1992: --
1993: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).vset_id := p_vset_id;
1994: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).code := p_id;
1995: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).meaning := pqh_gen_form.g_v_value;
1996: --
1997: return(pqh_gen_form.g_v_value);
1998: --
1999: exception

Line 1997: return(pqh_gen_form.g_v_value);

1993: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).vset_id := p_vset_id;
1994: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).code := p_id;
1995: pqh_gen_form.g_vset_tab(nvl(l_cnt,0)+1).meaning := pqh_gen_form.g_v_value;
1996: --
1997: return(pqh_gen_form.g_v_value);
1998: --
1999: exception
2000: when no_data_found then
2001: pqh_gen_form.g_v_id := '';

Line 2001: pqh_gen_form.g_v_id := '';

1997: return(pqh_gen_form.g_v_value);
1998: --
1999: exception
2000: when no_data_found then
2001: pqh_gen_form.g_v_id := '';
2002: pqh_gen_form.g_v_value := '';
2003: return(p_id);
2004: when others then
2005: pqh_gen_form.g_v_id := '';

Line 2002: pqh_gen_form.g_v_value := '';

1998: --
1999: exception
2000: when no_data_found then
2001: pqh_gen_form.g_v_id := '';
2002: pqh_gen_form.g_v_value := '';
2003: return(p_id);
2004: when others then
2005: pqh_gen_form.g_v_id := '';
2006: pqh_gen_form.g_v_value := '';

Line 2005: pqh_gen_form.g_v_id := '';

2001: pqh_gen_form.g_v_id := '';
2002: pqh_gen_form.g_v_value := '';
2003: return(p_id);
2004: when others then
2005: pqh_gen_form.g_v_id := '';
2006: pqh_gen_form.g_v_value := '';
2007: return(p_id||'-'||substr(sqlerrm,1,125));
2008: --raise ;
2009: end get_value_from_id;

Line 2006: pqh_gen_form.g_v_value := '';

2002: pqh_gen_form.g_v_value := '';
2003: return(p_id);
2004: when others then
2005: pqh_gen_form.g_v_id := '';
2006: pqh_gen_form.g_v_value := '';
2007: return(p_id||'-'||substr(sqlerrm,1,125));
2008: --raise ;
2009: end get_value_from_id;
2010: --

Line 2029: return(pqh_gen_form.g_v_id);

2025: p_where_on_id => false );
2026: --
2027: execute immediate 'Begin '||l_sql ||'; end;';
2028: --
2029: return(pqh_gen_form.g_v_id);
2030: --
2031: exception
2032: when no_data_found then
2033: pqh_gen_form.g_v_id := '';

Line 2033: pqh_gen_form.g_v_id := '';

2029: return(pqh_gen_form.g_v_id);
2030: --
2031: exception
2032: when no_data_found then
2033: pqh_gen_form.g_v_id := '';
2034: pqh_gen_form.g_v_value := '';
2035: return('');
2036: when others then
2037: pqh_gen_form.g_v_id := '';

Line 2034: pqh_gen_form.g_v_value := '';

2030: --
2031: exception
2032: when no_data_found then
2033: pqh_gen_form.g_v_id := '';
2034: pqh_gen_form.g_v_value := '';
2035: return('');
2036: when others then
2037: pqh_gen_form.g_v_id := '';
2038: pqh_gen_form.g_v_value := '';

Line 2037: pqh_gen_form.g_v_id := '';

2033: pqh_gen_form.g_v_id := '';
2034: pqh_gen_form.g_v_value := '';
2035: return('');
2036: when others then
2037: pqh_gen_form.g_v_id := '';
2038: pqh_gen_form.g_v_value := '';
2039: return('');
2040: --raise ;
2041: end get_id_from_value;

Line 2038: pqh_gen_form.g_v_value := '';

2034: pqh_gen_form.g_v_value := '';
2035: return('');
2036: when others then
2037: pqh_gen_form.g_v_id := '';
2038: pqh_gen_form.g_v_value := '';
2039: return('');
2040: --raise ;
2041: end get_id_from_value;
2042: --

Line 2153: p_legislation_code := pqh_gen_form.get_legislation_code(p_business_group_id);

2149: hr_utility.set_location(' a : '||p_application_short_name ,100);
2150: --
2151: -- get legislation_code to help determine context
2152: --
2153: p_legislation_code := pqh_gen_form.get_legislation_code(p_business_group_id);
2154: hr_utility.set_location(' l : '||p_legislation_code ,100);
2155: --
2156: -- read responsibility short name to facilitate deriving context
2157: --

Line 2165: pqh_gen_form.g_txn_name := p_transaction_short_name ;

2161: hr_utility.set_location(' r : '||p_responsibility_key ,100);
2162: --
2163: for rec in c_gbl loop
2164: p_gbl_context := rec.context ;
2165: pqh_gen_form.g_txn_name := p_transaction_short_name ;
2166: pqh_gen_form.g_gbl_context := rec.context ;
2167: end loop; --c_gbl
2168: --
2169: for i in c_one loop

Line 2166: pqh_gen_form.g_gbl_context := rec.context ;

2162: --
2163: for rec in c_gbl loop
2164: p_gbl_context := rec.context ;
2165: pqh_gen_form.g_txn_name := p_transaction_short_name ;
2166: pqh_gen_form.g_gbl_context := rec.context ;
2167: end loop; --c_gbl
2168: --
2169: for i in c_one loop
2170: --

Line 2177: pqh_gen_form.g_context := i.context;

2173: nvl(i.responsibility_key , 'NULL') = p_responsibility_key then
2174: p_application_short_name := i.application_short_name ;
2175: p_legislation_code := i.legislation_code ;
2176: p_responsibility_key := i.responsibility_key ;
2177: pqh_gen_form.g_context := i.context;
2178: return (i.context);
2179: end if ; -- alr
2180: end loop; --c_one
2181: --

Line 2189: pqh_gen_form.g_context := i.context;

2185: nvl(i.responsibility_key , 'NULL') = p_responsibility_key then
2186: p_application_short_name := i.application_short_name ;
2187: p_legislation_code := 'NULL' ;
2188: p_responsibility_key := i.responsibility_key ;
2189: pqh_gen_form.g_context := i.context;
2190: return (i.context);
2191: end if ; -- a r
2192: end loop; --c_one
2193: --

Line 2201: pqh_gen_form.g_context := i.context;

2197: nvl(i.responsibility_key , 'NULL') = p_responsibility_key then
2198: p_application_short_name := 'NULL';
2199: p_legislation_code := i.legislation_code ;
2200: p_responsibility_key := i.responsibility_key ;
2201: pqh_gen_form.g_context := i.context;
2202: return (i.context);
2203: end if ; -- lr
2204: end loop; --c_one
2205: --

Line 2213: pqh_gen_form.g_context := i.context;

2209: nvl(upper(i.responsibility_key) , 'NULL') = 'NULL' then
2210: p_application_short_name := i.application_short_name ;
2211: p_legislation_code := i.legislation_code ;
2212: p_responsibility_key := 'NULL' ;
2213: pqh_gen_form.g_context := i.context;
2214: return (i.context);
2215: end if ; -- al
2216: end loop; --c_one
2217: --

Line 2225: pqh_gen_form.g_context := i.context;

2221: nvl(i.responsibility_key , 'NULL') = p_responsibility_key then
2222: p_application_short_name := 'NULL' ;
2223: p_legislation_code := 'NULL' ;
2224: p_responsibility_key := i.responsibility_key ;
2225: pqh_gen_form.g_context := i.context;
2226: return (i.context);
2227: end if ; -- r
2228: end loop; --c_one
2229: --

Line 2237: pqh_gen_form.g_context := i.context;

2233: nvl(upper(i.responsibility_key) , 'NULL') = 'NULL' then
2234: p_application_short_name := 'NULL' ;
2235: p_legislation_code := i.legislation_code ;
2236: p_responsibility_key := 'NULL' ;
2237: pqh_gen_form.g_context := i.context;
2238: return (i.context);
2239: end if ; -- l
2240: end loop; --c_one
2241: --

Line 2249: pqh_gen_form.g_context := i.context;

2245: nvl(upper(i.responsibility_key) , 'NULL') = 'NULL' then
2246: p_application_short_name := i.application_short_name ;
2247: p_legislation_code := 'NULL' ;
2248: p_responsibility_key := 'NULL' ;
2249: pqh_gen_form.g_context := i.context;
2250: return (i.context);
2251: end if ; -- a
2252: end loop; --c_one
2253: --

Line 2261: pqh_gen_form.g_context := i.context;

2257: nvl(upper(i.responsibility_key) , 'NULL') = 'NULL' then
2258: p_application_short_name := 'NULL' ;
2259: p_legislation_code := 'NULL' ;
2260: p_responsibility_key := 'NULL' ;
2261: pqh_gen_form.g_context := i.context;
2262: return (i.context);
2263: end if ; -- null (global)
2264:
2265: end loop; --c_one

Line 2294: if pqh_gen_form.g_context is null then

2290: and nvl(upper(ce1.application_short_name), 'NULL') = 'NULL'
2291: and nvl(upper(ce1.legislation_code) , 'NULL') = 'NULL'
2292: and nvl(upper(ce1.responsibility_key) , 'NULL') = 'NULL';
2293: begin
2294: if pqh_gen_form.g_context is null then
2295: for i in c_txn loop
2296: pqh_gen_form.g_context := i.context ;
2297: end loop;
2298: end if;

Line 2296: pqh_gen_form.g_context := i.context ;

2292: and nvl(upper(ce1.responsibility_key) , 'NULL') = 'NULL';
2293: begin
2294: if pqh_gen_form.g_context is null then
2295: for i in c_txn loop
2296: pqh_gen_form.g_context := i.context ;
2297: end loop;
2298: end if;
2299: --
2300: if pqh_gen_form.g_gbl_context is null then

Line 2300: if pqh_gen_form.g_gbl_context is null then

2296: pqh_gen_form.g_context := i.context ;
2297: end loop;
2298: end if;
2299: --
2300: if pqh_gen_form.g_gbl_context is null then
2301: for i in c_gbl(pqh_gen_form.g_context) loop
2302: pqh_gen_form.g_gbl_context := i.context ;
2303: end loop;
2304: end if;

Line 2301: for i in c_gbl(pqh_gen_form.g_context) loop

2297: end loop;
2298: end if;
2299: --
2300: if pqh_gen_form.g_gbl_context is null then
2301: for i in c_gbl(pqh_gen_form.g_context) loop
2302: pqh_gen_form.g_gbl_context := i.context ;
2303: end loop;
2304: end if;
2305: end;

Line 2302: pqh_gen_form.g_gbl_context := i.context ;

2298: end if;
2299: --
2300: if pqh_gen_form.g_gbl_context is null then
2301: for i in c_gbl(pqh_gen_form.g_context) loop
2302: pqh_gen_form.g_gbl_context := i.context ;
2303: end loop;
2304: end if;
2305: end;
2306: --

Line 2384: return (pqh_gen_form.g_context);

2380: --
2381: function my_con return varchar2 is
2382: begin
2383: --
2384: return (pqh_gen_form.g_context);
2385: --
2386: end;
2387: --
2388: function get_look (p_code in varchar2) return varchar2

Line 2553: where copy_entity_txn_id = pqh_gen_form.g_txn_id;

2549: --
2550: cursor c_bg is
2551: select context_business_group_id
2552: from pqh_copy_entity_txns
2553: where copy_entity_txn_id = pqh_gen_form.g_txn_id;
2554: begin
2555:
2556: if pqh_gen_form.g_txn_id is not null then
2557: if g_private_txn_id is not null and

Line 2556: if pqh_gen_form.g_txn_id is not null then

2552: from pqh_copy_entity_txns
2553: where copy_entity_txn_id = pqh_gen_form.g_txn_id;
2554: begin
2555:
2556: if pqh_gen_form.g_txn_id is not null then
2557: if g_private_txn_id is not null and
2558: g_private_bg_id is not null and
2559: g_private_txn_id = pqh_gen_form.g_txn_id then
2560:

Line 2559: g_private_txn_id = pqh_gen_form.g_txn_id then

2555:
2556: if pqh_gen_form.g_txn_id is not null then
2557: if g_private_txn_id is not null and
2558: g_private_bg_id is not null and
2559: g_private_txn_id = pqh_gen_form.g_txn_id then
2560:
2561: return (g_private_bg_id) ;
2562: end if;
2563: --

Line 2566: g_private_txn_id := pqh_gen_form.g_txn_id;

2562: end if;
2563: --
2564: for i in c_bg loop
2565: g_private_bg_id := i.context_business_group_id;
2566: g_private_txn_id := pqh_gen_form.g_txn_id;
2567: return (i.context_business_group_id);
2568: end loop;
2569: end if;
2570:

Line 2575: pqh_gen_form.g_txn_id := p_txn_id ;

2571: end context_bg;
2572: --
2573: procedure set_txn_id (p_txn_id in number) is
2574: begin
2575: pqh_gen_form.g_txn_id := p_txn_id ;
2576:
2577: end ;
2578: --
2579: procedure set_dt (p_dt_mode in varchar2, p_dt_desc in varchar2) is

Line 2591: and s.context = pqh_gen_form.g_gbl_context

2587: where a.attribute_id = c.attribute_id
2588: and c.txn_category_attribute_id = s.txn_category_attribute_id
2589: and a.enable_flag = 'Y'
2590: and c.select_flag = 'Y'
2591: and s.context = pqh_gen_form.g_gbl_context
2592: and s.attribute_type_cd = p_type
2593: and a.column_name like 'DATETRACK_MODE'
2594: and s.ddf_column_name is not null;
2595: --

Line 2600: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)

2596: begin
2597: for i in c_dt('DISPLAY') loop
2598: if i.ddf_value_column_name is not null then
2599: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc
2600: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2601: ||' and result_type_cd = ''TARGET'''
2602: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2603: end if;
2604: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode

Line 2605: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)

2601: ||' and result_type_cd = ''TARGET'''
2602: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2603: end if;
2604: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode
2605: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2606: ||' and result_type_cd = ''TARGET'''
2607: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2608:
2609: l_upd := FALSE;

Line 2616: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)

2612: if l_upd then
2613: for i in c_dt('SELECT') loop
2614: if i.ddf_value_column_name is not null then
2615: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc
2616: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2617: ||' and result_type_cd = ''TARGET'''
2618: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2619: end if;
2620: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode

Line 2621: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)

2617: ||' and result_type_cd = ''TARGET'''
2618: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2619: end if;
2620: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode
2621: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2622: ||' and result_type_cd = ''TARGET'''
2623: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2624:
2625: l_upd := FALSE;

Line 2633: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)

2629: if l_upd then
2630: for i in c_dt('PARAMETER') loop
2631: if i.ddf_value_column_name is not null then
2632: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc
2633: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2634: ||' and result_type_cd = ''TARGET'''
2635: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2636: end if;
2637: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode

Line 2638: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)

2634: ||' and result_type_cd = ''TARGET'''
2635: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2636: end if;
2637: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode
2638: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2639: ||' and result_type_cd = ''TARGET'''
2640: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2641:
2642: l_upd := FALSE;

Line 2682: END PQH_GEN_FORM;

2678: return (substr(l_col,1,instr(l_col||'_','_')-1));
2679:
2680: end get_segment;
2681: --
2682: END PQH_GEN_FORM;