217: end find_like_or_equal;
218: --
219: begin
220: --
221: hr_utility.set_location(g_package||'create_source: Entering',1);
222: --
223: -- The primary cursor, this ideally would have just row with information pretaining to the txn
224: --
225: for rec in c_txn loop
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);
245: --
246: -- l_ins would hold the string call to create source records on the results table
247: --
248: l_ins := 'pqh_copy_entity_results_api.create_copy_entity_result '||
262: --
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;
296: --
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;
310: end if; -- Primary Key
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;
324: end if; --
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;
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
367: ,rec.information5, rec.information6, rec.information7
368: ,rec.information8, rec.information9, rec.information10
372: ,rec.information20, rec.information21, rec.information22
373: ,rec.information23, rec.information24, rec.information25
374: ,rec.information26, rec.information27, rec.information28
375: ,rec.information29, rec.information30, p_delimiter) loop
376: hr_utility.set_location(g_package||'create_source: inside c_dec ',5);
377: --
378: -- COLUMN_NAME like COLUMN_NAME fails if the value is null and hence decided to form where
379: -- on if there is a value (SCNair 05/25/00 UK)
380: --
389: end loop ; --dec
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));
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));
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));
399: hr_utility.trace(substr(l_where,8001,2000));
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));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
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));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
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));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
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));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,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));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
397: hr_utility.trace(substr(l_where,4001,2000));
398: hr_utility.trace(substr(l_where,6001,2000));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
398: hr_utility.trace(substr(l_where,6001,2000));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
399: hr_utility.trace(substr(l_where,8001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
407: hr_utility.trace(substr(l_where,24001,2000));
400: hr_utility.trace(substr(l_where,10001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
407: hr_utility.trace(substr(l_where,24001,2000));
408: hr_utility.trace(substr(l_where,26001,2000));
401: hr_utility.trace(substr(l_where,12001,2000));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
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));
402: hr_utility.trace(substr(l_where,14001,2000));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
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));
403: hr_utility.trace(substr(l_where,16001,2000));
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
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');
404: hr_utility.trace(substr(l_where,18001,2000));
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
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: --
405: hr_utility.trace(substr(l_where,20001,2000));
406: hr_utility.trace(substr(l_where,22001,2000));
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
406: hr_utility.trace(substr(l_where,22001,2000));
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: --
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
414: --
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;
422: p_count := g_count;
423: p_msg := g_msg ;
424: else
425: l_ins := l_ins || ');';
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');
424: else
425: l_ins := l_ins || ');';
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));
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));
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));
435: hr_utility.trace(substr(l_sel,8001,2000));
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));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
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));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
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));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
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));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,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));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
433: hr_utility.trace(substr(l_sel,4001,2000));
434: hr_utility.trace(substr(l_sel,6001,2000));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
434: hr_utility.trace(substr(l_sel,6001,2000));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
435: hr_utility.trace(substr(l_sel,8001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
436: hr_utility.trace(substr(l_sel,10001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
444: hr_utility.trace(substr(l_sel,26001,2000));
437: hr_utility.trace(substr(l_sel,12001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
444: hr_utility.trace(substr(l_sel,26001,2000));
445: hr_utility.trace(substr(l_sel,28001,2000));
438: hr_utility.trace(substr(l_sel,14001,2000));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
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));
439: hr_utility.trace(substr(l_sel,16001,2000));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
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));
440: hr_utility.trace(substr(l_sel,18001,2000));
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
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');
441: hr_utility.trace(substr(l_sel,20001,2000));
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
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: --
442: hr_utility.trace(substr(l_sel,22001,2000));
443: hr_utility.trace(substr(l_sel,24001,2000));
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');
443: hr_utility.trace(substr(l_sel,24001,2000));
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));
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));
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));
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));
455: hr_utility.trace(substr(l_ins,8001,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));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
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));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
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));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
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));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,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));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
453: hr_utility.trace(substr(l_ins,4001,2000));
454: hr_utility.trace(substr(l_ins,6001,2000));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
454: hr_utility.trace(substr(l_ins,6001,2000));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
455: hr_utility.trace(substr(l_ins,8001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
456: hr_utility.trace(substr(l_ins,10001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
464: hr_utility.trace(substr(l_ins,26001,2000));
457: hr_utility.trace(substr(l_ins,12001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
464: hr_utility.trace(substr(l_ins,26001,2000));
465: hr_utility.trace(substr(l_ins,28001,2000));
458: hr_utility.trace(substr(l_ins,14001,2000));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
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));
459: hr_utility.trace(substr(l_ins,16001,2000));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
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));
460: hr_utility.trace(substr(l_ins,18001,2000));
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
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');
461: hr_utility.trace(substr(l_ins,20001,2000));
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
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: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
462: hr_utility.trace(substr(l_ins,22001,2000));
463: hr_utility.trace(substr(l_ins,24001,2000));
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:
463: hr_utility.trace(substr(l_ins,24001,2000));
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 '
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;';
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;';
473:
474: hr_utility.set_location(g_package||'create_source: after execute of ins api',9);
475: end if; -- p_row_count
476: end loop ; -- c_txn
477:
478: hr_utility.set_location(g_package||'create_source: Leaving',1);
474: hr_utility.set_location(g_package||'create_source: after execute of ins api',9);
475: end if; -- p_row_count
476: end loop ; -- c_txn
477:
478: hr_utility.set_location(g_package||'create_source: Leaving',1);
479: exception when others then
480: p_count := null;
481: p_msg := null;
482: raise;
900: procedure apply_changes
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);
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
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
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
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
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 '
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
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);
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;');
927: exit;
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;
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
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 ;
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);
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 ;
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: --
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)
947: is
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: --
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;';
974: hr_utility.trace(substr(l_str,1,255));
975: hr_utility.trace(substr(l_str,256,255));
976: hr_utility.trace(substr(l_str,511,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
971:
972: if l_str is not null then
973: l_str := 'Begin '||l_str||' end;';
974: hr_utility.trace(substr(l_str,1,255));
975: hr_utility.trace(substr(l_str,256,255));
976: hr_utility.trace(substr(l_str,511,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
972: if l_str is not null then
973: l_str := 'Begin '||l_str||' end;';
974: hr_utility.trace(substr(l_str,1,255));
975: hr_utility.trace(substr(l_str,256,255));
976: hr_utility.trace(substr(l_str,511,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
973: l_str := 'Begin '||l_str||' end;';
974: hr_utility.trace(substr(l_str,1,255));
975: hr_utility.trace(substr(l_str,256,255));
976: hr_utility.trace(substr(l_str,511,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
974: hr_utility.trace(substr(l_str,1,255));
975: hr_utility.trace(substr(l_str,256,255));
976: hr_utility.trace(substr(l_str,511,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
975: hr_utility.trace(substr(l_str,256,255));
976: hr_utility.trace(substr(l_str,511,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
976: hr_utility.trace(substr(l_str,511,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
977: hr_utility.trace(substr(l_str,766,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
978: hr_utility.trace(substr(l_str,1021,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
979: hr_utility.trace(substr(l_str,1276,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
987: hr_utility.trace(substr(l_str,3316,255));
980: hr_utility.trace(substr(l_str,1531,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
987: hr_utility.trace(substr(l_str,3316,255));
988: hr_utility.trace(substr(l_str,3571,255));
981: hr_utility.trace(substr(l_str,1786,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
987: hr_utility.trace(substr(l_str,3316,255));
988: hr_utility.trace(substr(l_str,3571,255));
989: hr_utility.trace(substr(l_str,3826,255));
982: hr_utility.trace(substr(l_str,2041,255));
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
987: hr_utility.trace(substr(l_str,3316,255));
988: hr_utility.trace(substr(l_str,3571,255));
989: hr_utility.trace(substr(l_str,3826,255));
990: execute immediate l_str ;
983: hr_utility.trace(substr(l_str,2296,255));
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
987: hr_utility.trace(substr(l_str,3316,255));
988: hr_utility.trace(substr(l_str,3571,255));
989: hr_utility.trace(substr(l_str,3826,255));
990: execute immediate l_str ;
991: end if;
984: hr_utility.trace(substr(l_str,2551,255));
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
987: hr_utility.trace(substr(l_str,3316,255));
988: hr_utility.trace(substr(l_str,3571,255));
989: hr_utility.trace(substr(l_str,3826,255));
990: execute immediate l_str ;
991: end if;
992:
985: hr_utility.trace(substr(l_str,2806,255));
986: hr_utility.trace(substr(l_str,3061,255));
987: hr_utility.trace(substr(l_str,3316,255));
988: hr_utility.trace(substr(l_str,3571,255));
989: hr_utility.trace(substr(l_str,3826,255));
990: execute immediate l_str ;
991: end if;
992:
993: hr_utility.set_location(g_package||'create_target>>apply_kf: Leaving',1);
989: hr_utility.trace(substr(l_str,3826,255));
990: execute immediate l_str ;
991: end if;
992:
993: hr_utility.set_location(g_package||'create_target>>apply_kf: Leaving',1);
994: end apply_kf;
995: --
996: procedure apply_special_attrib ( p_txn_category_attribute_id in number
997: , p_index in number
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
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;
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);
1105:
1106: if rec.flex_code = p_lf1 then
1107: l_fn := p_ln1;
1108: l_fd := p_ld1;
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; ';
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));
1147: hr_utility.trace(substr(l_str,1021,255));
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));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
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));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
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));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
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));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,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));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1145: hr_utility.trace(substr(l_str,511,255));
1146: hr_utility.trace(substr(l_str,766,255));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1146: hr_utility.trace(substr(l_str,766,255));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1147: hr_utility.trace(substr(l_str,1021,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1148: hr_utility.trace(substr(l_str,1276,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1156: hr_utility.trace(substr(l_str,3316,255));
1149: hr_utility.trace(substr(l_str,1531,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1156: hr_utility.trace(substr(l_str,3316,255));
1157: hr_utility.trace(substr(l_str,3571,255));
1150: hr_utility.trace(substr(l_str,1786,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1156: hr_utility.trace(substr(l_str,3316,255));
1157: hr_utility.trace(substr(l_str,3571,255));
1158: hr_utility.trace(substr(l_str,3826,255));
1151: hr_utility.trace(substr(l_str,2041,255));
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1156: hr_utility.trace(substr(l_str,3316,255));
1157: hr_utility.trace(substr(l_str,3571,255));
1158: hr_utility.trace(substr(l_str,3826,255));
1159:
1152: hr_utility.trace(substr(l_str,2296,255));
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1156: hr_utility.trace(substr(l_str,3316,255));
1157: hr_utility.trace(substr(l_str,3571,255));
1158: hr_utility.trace(substr(l_str,3826,255));
1159:
1160: execute immediate l_str;
1153: hr_utility.trace(substr(l_str,2551,255));
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1156: hr_utility.trace(substr(l_str,3316,255));
1157: hr_utility.trace(substr(l_str,3571,255));
1158: hr_utility.trace(substr(l_str,3826,255));
1159:
1160: execute immediate l_str;
1161: --
1154: hr_utility.trace(substr(l_str,2806,255));
1155: hr_utility.trace(substr(l_str,3061,255));
1156: hr_utility.trace(substr(l_str,3316,255));
1157: hr_utility.trace(substr(l_str,3571,255));
1158: hr_utility.trace(substr(l_str,3826,255));
1159:
1160: execute immediate l_str;
1161: --
1162: end if ; --attribute is a SEGMENT
1160: execute immediate l_str;
1161: --
1162: end if ; --attribute is a SEGMENT
1163: end loop; -- c_sat
1164: hr_utility.set_location(g_package||'create_target>>apply_special_attrib: Leaving',1);
1165: end apply_special_attrib;
1166: --
1167: procedure concat_segs (p_trt_id in number, p_flex in varchar2, p_kf_num in varchar2, p_kd in varchar2)
1168: is
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:
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
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 '
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 '
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));
1266: hr_utility.trace(substr(l_str,1021,255));
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));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
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));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
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));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
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));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,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));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1264: hr_utility.trace(substr(l_str,511,255));
1265: hr_utility.trace(substr(l_str,766,255));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1265: hr_utility.trace(substr(l_str,766,255));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1266: hr_utility.trace(substr(l_str,1021,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1267: hr_utility.trace(substr(l_str,1276,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1275: hr_utility.trace(substr(l_str,3316,255));
1268: hr_utility.trace(substr(l_str,1531,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1275: hr_utility.trace(substr(l_str,3316,255));
1276: hr_utility.trace(substr(l_str,3571,255));
1269: hr_utility.trace(substr(l_str,1786,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1275: hr_utility.trace(substr(l_str,3316,255));
1276: hr_utility.trace(substr(l_str,3571,255));
1277: hr_utility.trace(substr(l_str,3826,255));
1270: hr_utility.trace(substr(l_str,2041,255));
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1275: hr_utility.trace(substr(l_str,3316,255));
1276: hr_utility.trace(substr(l_str,3571,255));
1277: hr_utility.trace(substr(l_str,3826,255));
1278:
1271: hr_utility.trace(substr(l_str,2296,255));
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1275: hr_utility.trace(substr(l_str,3316,255));
1276: hr_utility.trace(substr(l_str,3571,255));
1277: hr_utility.trace(substr(l_str,3826,255));
1278:
1279: execute immediate l_str;
1272: hr_utility.trace(substr(l_str,2551,255));
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1275: hr_utility.trace(substr(l_str,3316,255));
1276: hr_utility.trace(substr(l_str,3571,255));
1277: hr_utility.trace(substr(l_str,3826,255));
1278:
1279: execute immediate l_str;
1280: end if;
1273: hr_utility.trace(substr(l_str,2806,255));
1274: hr_utility.trace(substr(l_str,3061,255));
1275: hr_utility.trace(substr(l_str,3316,255));
1276: hr_utility.trace(substr(l_str,3571,255));
1277: hr_utility.trace(substr(l_str,3826,255));
1278:
1279: execute immediate l_str;
1280: end if;
1281: /*
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;
1309: end if; --p_kd
1310: */
1311: hr_utility.set_location(g_package||'create_target>>concat_segs: Leaving',1);
1307: hr_utility.trace(substr(l_str,1,2000));
1308: execute immediate l_str;
1309: end if; --p_kd
1310: */
1311: hr_utility.set_location(g_package||'create_target>>concat_segs: Leaving',1);
1312: end concat_segs;
1313: --
1314: begin
1315: --
1312: end concat_segs;
1313: --
1314: begin
1315: --
1316: hr_utility.set_location(g_package||'create_target: Entering',1);
1317: --
1318: delete from pqh_copy_entity_results
1319: where result_type_cd = 'TARGET'
1320: and copy_entity_txn_id = p_copy_entity_txn_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: --
1334: PQH_GEN_FORM.g_attrib_tab.delete; -- clear table
1335: --
1336: hr_utility.set_location(g_package||'create_target: c_attrib',1);
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
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 ;
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 ;
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
1346: c_information1 := rec.information1 ;
1347: c_information2 := rec.information2 ;
1348: c_information3 := rec.information3 ;
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
1457: --
1458: end loop ; -- rec in c_ch_kf2
1459: end if;
1460: --
1461: hr_utility.set_location(g_package||'create_target: c_candidate',12);
1462: for rec in c_candidate loop
1463: g_information1 := rec.information1 ;
1464: g_information2 := rec.information2 ;
1465: g_information3 := rec.information3 ;
1654: apply_kf(p_lf2, '2');
1655: concat_segs (l_mast_trt_id,p_lf2, p_ln2, p_ld2) ;
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;';
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: --
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);
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
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:
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);
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);
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
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
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
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
1888: --
1889: l_warn := ''; -- reset to no warnings
1890: --
1891: end loop; -- c_candidate
1892: hr_utility.set_location(g_package||'create_target: Leaving',1);
1893: exception when others then
1894: p_batch_status := null;
1895: raise;
1896: end create_target;
2138: select responsibility_key
2139: from fnd_responsibility
2140: where responsibility_id = p_responsibility_id ;
2141: begin
2142: hr_utility.set_location('Entering alr : ',100);
2143: --
2144: -- get application short name to determine context
2145: --
2146: for i in c_appl loop
2145: --
2146: for i in c_appl loop
2147: p_application_short_name := i.application_short_name ;
2148: end loop;
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);
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: --
2158: for i in c_resp loop
2157: --
2158: for i in c_resp loop
2159: p_responsibility_key := i.responsibility_key ;
2160: end loop;
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 ;
2263: end if ; -- null (global)
2264:
2265: end loop; --c_one
2266: --
2267: hr_utility.set_location('Leaving alr : ',100);
2268: exception when others then
2269: p_application_short_name := null;
2270: p_legislation_code := null;
2271: p_responsibility_key := null;
2657: if p_valueset_id is null then
2658: return 'Y' ;
2659: end if;
2660:
2661: hr_utility.set_location('value of valueset_id : '||p_valueset_id, 11);
2662: for i in c_vset loop
2663: if i.validation_type in ('N') then -- , 'I') then (commented I..can be taken up for enhancement)
2664: return 'Y';
2665: end if;