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.OTA_FR_TRG_SUM dependencies on HR_UTILITY

Line 83: hr_utility.trace('

79: g_utf8 := FALSE;
80: end if;
81: xml_t(p_xml,' 82: nvl(rec_lookup.tag,'UTF-8')||'" ?>');
83: hr_utility.trace(' 84: nvl(rec_lookup.tag,'UTF-8')||'" ?>');
85: --
86: end xml_utf8;
87:

Line 130: -- hr_utility.trace_on(NULL,'TRG');

126:
127:
128: BEGIN
129:
130: -- hr_utility.trace_on(NULL,'TRG');
131: dbms_lob.createtemporary(p_xml, TRUE, dbms_lob.session);
132: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
133: xml_utf8(p_xml);
134: xml_t(p_xml,'');

Line 141: hr_utility.TRACE('l_date_to ' || to_char(l_date_to,'YYYY-MON-DD'));

137:
138: --OTA_FR_TRG_SUM.vXMLTable.DELETE;
139: --vCtr:=0;
140:
141: hr_utility.TRACE('l_date_to ' || to_char(l_date_to,'YYYY-MON-DD'));
142:
143:
144: if (p_asg_num='A') then
145:

Line 568: hr_utility.trace(''); ---Start tag of an Employee

564: xml_t(p_xml,''||xml_d(l_c_emp_h.SIRET)||'');
565: xml_t(p_xml,''||xml_d(l_c_emp_h.COM_NAME)||'');
566: xml_t(p_xml,''||xml_d(l_c_emp_h.COM_ADDRESS)||'');
567:
568: hr_utility.trace(''); ---Start tag of an Employee
569: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NAME)||'');
570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');
571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');

Line 569: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NAME)||'');

565: xml_t(p_xml,''||xml_d(l_c_emp_h.COM_NAME)||'');
566: xml_t(p_xml,''||xml_d(l_c_emp_h.COM_ADDRESS)||'');
567:
568: hr_utility.trace(''); ---Start tag of an Employee
569: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NAME)||'');
570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');
571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');

Line 570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');

566: xml_t(p_xml,''||xml_d(l_c_emp_h.COM_ADDRESS)||'');
567:
568: hr_utility.trace(''); ---Start tag of an Employee
569: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NAME)||'');
570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');
571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');

Line 571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');

567:
568: hr_utility.trace(''); ---Start tag of an Employee
569: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NAME)||'');
570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');
571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');

Line 572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');

568: hr_utility.trace(''); ---Start tag of an Employee
569: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NAME)||'');
570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');
571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');

Line 573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');

569: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NAME)||'');
570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');
571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');

Line 574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');

570: hr_utility.trace(''||xml_d(l_c_emp_h.EMP_NUM)||'');
571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');

Line 575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');

571: hr_utility.trace(''||xml_d(l_c_emp_h.E_ADDRESS)||'');
572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');

Line 576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');

572: hr_utility.trace(''||xml_d(l_c_emp_h.HIRE_DATE)||'');
573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');

Line 577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');

573: hr_utility.trace(''||xml_d(l_c_emp_h.ADJUSTED_SVC_DATE)||'');
574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');

Line 578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');

574: hr_utility.trace(''||xml_d(l_c_emp_h.TERM_DATE)||'');
575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');

Line 579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');

575: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_CATEGORY)||'');
576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');
583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');

Line 580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');

576: hr_utility.trace(''||xml_d(l_c_emp_h.CONTRACT_TYPE)||'');
577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');
583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');
584: hr_utility.trace(''||xml_d(l_c_emp_h.COM_NAME)||'');

Line 581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');

577: hr_utility.trace(''||xml_d(l_c_emp_h.COLLECTIVE_AGREEMENT)||'');
578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');
583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');
584: hr_utility.trace(''||xml_d(l_c_emp_h.COM_NAME)||'');
585: hr_utility.trace(''||xml_d(l_c_emp_h.COM_ADDRESS)||'');

Line 582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');

578: hr_utility.trace(''||xml_d(l_c_emp_h.ASSGN_CATEGORY)||'');
579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');
583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');
584: hr_utility.trace(''||xml_d(l_c_emp_h.COM_NAME)||'');
585: hr_utility.trace(''||xml_d(l_c_emp_h.COM_ADDRESS)||'');
586:

Line 583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');

579: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_FROM)||'');
580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');
583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');
584: hr_utility.trace(''||xml_d(l_c_emp_h.COM_NAME)||'');
585: hr_utility.trace(''||xml_d(l_c_emp_h.COM_ADDRESS)||'');
586:
587: for l_c_emp_w_trg in c_emp_w_trg --- Courses Within Training Plan

Line 584: hr_utility.trace(''||xml_d(l_c_emp_h.COM_NAME)||'');

580: hr_utility.trace(''||xml_d(l_c_emp_h.PERIOD_TO)||'');
581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');
583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');
584: hr_utility.trace(''||xml_d(l_c_emp_h.COM_NAME)||'');
585: hr_utility.trace(''||xml_d(l_c_emp_h.COM_ADDRESS)||'');
586:
587: for l_c_emp_w_trg in c_emp_w_trg --- Courses Within Training Plan
588: loop

Line 585: hr_utility.trace(''||xml_d(l_c_emp_h.COM_ADDRESS)||'');

581: hr_utility.trace(''||xml_d(l_c_emp_h.EST_NAME)||'');
582: hr_utility.trace(''||xml_d(l_c_emp_h.EST_ADDRESS)||'');
583: hr_utility.trace(''||xml_d(l_c_emp_h.SIRET)||'');
584: hr_utility.trace(''||xml_d(l_c_emp_h.COM_NAME)||'');
585: hr_utility.trace(''||xml_d(l_c_emp_h.COM_ADDRESS)||'');
586:
587: for l_c_emp_w_trg in c_emp_w_trg --- Courses Within Training Plan
588: loop
589:

Line 604: hr_utility.trace('');

600: xml_t(p_xml,''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');
601: xml_t(p_xml,'');
602:
603:
604: hr_utility.trace('');
605: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_NAME)||'');
606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');
607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');

Line 605: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_NAME)||'');

601: xml_t(p_xml,'');
602:
603:
604: hr_utility.trace('');
605: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_NAME)||'');
606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');
607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');

Line 606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');

602:
603:
604: hr_utility.trace('');
605: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_NAME)||'');
606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');
607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');

Line 607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');

603:
604: hr_utility.trace('');
605: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_NAME)||'');
606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');
607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');

Line 608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');

604: hr_utility.trace('');
605: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_NAME)||'');
606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');
607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');

Line 609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');

605: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_NAME)||'');
606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');
607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');
613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');

Line 610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');

606: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_STATUS)||'');
607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');
613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');
614: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');

Line 611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');

607: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_E_DAT)||'');
608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');
613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');
614: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');
615: hr_utility.trace('');

Line 612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');

608: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_S_DAT)||'');
609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');
613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');
614: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');
615: hr_utility.trace('');
616: end loop;

Line 613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');

609: hr_utility.trace(''||xml_d(l_c_emp_w_trg.ENR_SOURCE)||'');
610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');
613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');
614: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');
615: hr_utility.trace('');
616: end loop;
617:

Line 614: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');

610: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_TOT_HR)||'');
611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');
613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');
614: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');
615: hr_utility.trace('');
616: end loop;
617:
618:

Line 615: hr_utility.trace('');

611: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_O_HR)||'');
612: hr_utility.trace(''||xml_d(l_c_emp_w_trg.FAIL_REASON)||'');
613: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_REF)||'');
614: hr_utility.trace(''||xml_d(l_c_emp_w_trg.C_W_L_CAT)||'');
615: hr_utility.trace('');
616: end loop;
617:
618:
619: for l_c_emp_w_trg_tot in c_emp_w_trg_tot --Category Total for Courses Within Training Plan

Line 628: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');

624: g_catg1_o :=l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR+g_catg1_o ;
625: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
626: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
627:
628: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
629: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
630: else
631: if l_c_emp_w_trg_tot.LEGAL_CATG = 'JOB_EVOL' then
632: g_catg2_t :=l_c_emp_w_trg_tot.W_TOT_HOURS+g_catg2_t ; -- ii) JOB_EVOL , iii)COMP_DEV

Line 629: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');

625: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
626: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
627:
628: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
629: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
630: else
631: if l_c_emp_w_trg_tot.LEGAL_CATG = 'JOB_EVOL' then
632: g_catg2_t :=l_c_emp_w_trg_tot.W_TOT_HOURS+g_catg2_t ; -- ii) JOB_EVOL , iii)COMP_DEV
633: g_catg2_o :=l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR+g_catg2_o ;

Line 639: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');

635: l_catg23_o_w :=l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR+l_catg23_o_w ;
636: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
637: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
638:
639: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
640: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
641: else
642: if l_c_emp_w_trg_tot.LEGAL_CATG = 'COMP_DEV' then
643: g_catg3_t :=l_c_emp_w_trg_tot.W_TOT_HOURS+g_catg3_t ; -- ii) JOB_EVOL , iii)COMP_DEV

Line 640: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');

636: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
637: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
638:
639: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
640: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
641: else
642: if l_c_emp_w_trg_tot.LEGAL_CATG = 'COMP_DEV' then
643: g_catg3_t :=l_c_emp_w_trg_tot.W_TOT_HOURS+g_catg3_t ; -- ii) JOB_EVOL , iii)COMP_DEV
644: g_catg3_o :=l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR+g_catg3_o ;

Line 650: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');

646: l_catg23_o_w :=l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR+l_catg23_o_w ;
647: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
648: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
649:
650: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
651: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
652: end if;
653: end if;
654: end if;

Line 651: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');

647: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
648: xml_t(p_xml,''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
649:
650: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_HOURS)||'');
651: hr_utility.trace(''||xml_d(l_c_emp_w_trg_tot.W_TOT_OUT_WK_HR)||'');
652: end if;
653: end if;
654: end if;
655:

Line 664: hr_utility.trace(''||xml_d(l_catg23_t_w)||'');

660:
661: end loop;
662: xml_t(p_xml,''||xml_d(l_catg23_t_w)||'');
663: xml_t(p_xml,''||xml_d(l_catg23_o_w)||'');
664: hr_utility.trace(''||xml_d(l_catg23_t_w)||'');
665: hr_utility.trace(''||xml_d(l_catg23_o_w)||'');
666: for l_c_emp_o_trg in c_emp_o_trg --- Courses Outside Training Plan
667: loop
668:

Line 665: hr_utility.trace(''||xml_d(l_catg23_o_w)||'');

661: end loop;
662: xml_t(p_xml,''||xml_d(l_catg23_t_w)||'');
663: xml_t(p_xml,''||xml_d(l_catg23_o_w)||'');
664: hr_utility.trace(''||xml_d(l_catg23_t_w)||'');
665: hr_utility.trace(''||xml_d(l_catg23_o_w)||'');
666: for l_c_emp_o_trg in c_emp_o_trg --- Courses Outside Training Plan
667: loop
668:
669: xml_t(p_xml,'');

Line 688: hr_utility.trace('');

684: xml_t(p_xml,''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');
685: xml_t(p_xml,'');
686:
687:
688: hr_utility.trace('');
689: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_NAME)||'');
690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');
691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');

Line 689: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_NAME)||'');

685: xml_t(p_xml,'');
686:
687:
688: hr_utility.trace('');
689: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_NAME)||'');
690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');
691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');

Line 690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');

686:
687:
688: hr_utility.trace('');
689: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_NAME)||'');
690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');
691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');

Line 691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');

687:
688: hr_utility.trace('');
689: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_NAME)||'');
690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');
691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');

Line 692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');

688: hr_utility.trace('');
689: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_NAME)||'');
690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');
691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');

Line 693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');

689: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_NAME)||'');
690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');
691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');

Line 694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');

690: hr_utility.trace(''||xml_d(l_c_emp_o_trg.ABS_TYPE)||'');
691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');

Line 695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');

691: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_E_DAT)||'');
692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');

Line 696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');

692: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_S_DAT)||'');
693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');

Line 697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');

693: hr_utility.trace(''||xml_d(l_c_emp_o_trg.DURATION_DAYS)||'');
694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');

Line 698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');

694: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_TOT_HR)||'');
695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');
702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');

Line 699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');

695: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_LEAV_CATG)||'');
696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');
702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');
703: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');

Line 700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');

696: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TRG_PROV)||'');
697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');
702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');
703: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');
704: hr_utility.trace('');

Line 701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');

697: hr_utility.trace(''||xml_d(l_c_emp_o_trg.TYPE_OF_TRG)||'');
698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');
702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');
703: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');
704: hr_utility.trace('');
705:

Line 702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');

698: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_REF)||'');
699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');
702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');
703: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');
704: hr_utility.trace('');
705:
706:

Line 703: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');

699: hr_utility.trace(''||xml_d(l_c_emp_o_trg.WITH_TRG_PLAN)||'');
700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');
702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');
703: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');
704: hr_utility.trace('');
705:
706:
707:

Line 704: hr_utility.trace('');

700: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_L_CAT)||'');
701: hr_utility.trace(''||xml_d(l_c_emp_o_trg.C_O_O_HR)||'');
702: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_TYPE)||'');
703: hr_utility.trace(''||xml_d(l_c_emp_o_trg.SUBSI_ORG)||'');
704: hr_utility.trace('');
705:
706:
707:
708: end loop;

Line 719: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');

715: g_catg1_o :=l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR+g_catg1_o ;
716: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
717: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
718:
719: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
720: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
721: else
722: if l_c_emp_o_trg_tot.LEGAL_CATG = 'JOB_EVOL' then
723: g_catg2_t :=l_c_emp_o_trg_tot.O_TOT_HOURS+g_catg2_t ; -- ii) JOB_EVOL , iii)COMP_DEV

Line 720: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');

716: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
717: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
718:
719: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
720: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
721: else
722: if l_c_emp_o_trg_tot.LEGAL_CATG = 'JOB_EVOL' then
723: g_catg2_t :=l_c_emp_o_trg_tot.O_TOT_HOURS+g_catg2_t ; -- ii) JOB_EVOL , iii)COMP_DEV
724: g_catg2_o :=l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR+g_catg2_o ;

Line 732: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');

728:
729: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
730: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
731:
732: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
733: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
734: else
735: if l_c_emp_o_trg_tot.LEGAL_CATG = 'COMP_DEV' then
736: g_catg3_t :=l_c_emp_o_trg_tot.O_TOT_HOURS+g_catg3_t ; -- ii) JOB_EVOL , iii)COMP_DEV

Line 733: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');

729: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
730: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
731:
732: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
733: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
734: else
735: if l_c_emp_o_trg_tot.LEGAL_CATG = 'COMP_DEV' then
736: g_catg3_t :=l_c_emp_o_trg_tot.O_TOT_HOURS+g_catg3_t ; -- ii) JOB_EVOL , iii)COMP_DEV
737: g_catg3_o :=l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR+g_catg3_o ;

Line 745: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');

741:
742: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
743: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
744:
745: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
746: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
747: end if;
748: end if;
749: end if;

Line 746: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');

742: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
743: xml_t(p_xml,''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
744:
745: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_HOURS)||'');
746: hr_utility.trace(''||xml_d(l_c_emp_o_trg_tot.O_TOT_OUT_WK_HR)||'');
747: end if;
748: end if;
749: end if;
750:

Line 758: hr_utility.trace(''||xml_d(l_catg23_t)||'');

754: end loop;
755: xml_t(p_xml,''||xml_d(l_catg23_t)||'');
756: xml_t(p_xml,''||xml_d(l_catg23_o)||'');
757:
758: hr_utility.trace(''||xml_d(l_catg23_t)||'');
759: hr_utility.trace(''||xml_d(l_catg23_o)||'');
760:
761: xml_t(p_xml,''||xml_d(g_catg1_t)||'');
762: xml_t(p_xml,''||xml_d(g_catg2_t)||'');

Line 759: hr_utility.trace(''||xml_d(l_catg23_o)||'');

755: xml_t(p_xml,''||xml_d(l_catg23_t)||'');
756: xml_t(p_xml,''||xml_d(l_catg23_o)||'');
757:
758: hr_utility.trace(''||xml_d(l_catg23_t)||'');
759: hr_utility.trace(''||xml_d(l_catg23_o)||'');
760:
761: xml_t(p_xml,''||xml_d(g_catg1_t)||'');
762: xml_t(p_xml,''||xml_d(g_catg2_t)||'');
763: xml_t(p_xml,''||xml_d(g_catg3_t)||'');

Line 770: hr_utility.trace(''||xml_d(g_catg1_t)||'');

766: xml_t(p_xml,''||xml_d(g_catg3_o)||'');
767: xml_t(p_xml,''||xml_d(g_catg2_t+g_catg3_t)||'');
768: xml_t(p_xml,''||xml_d(g_catg2_o+g_catg3_o)||'');
769:
770: hr_utility.trace(''||xml_d(g_catg1_t)||'');
771: hr_utility.trace(''||xml_d(g_catg2_t)||'');
772: hr_utility.trace(''||xml_d(g_catg3_t)||'');
773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');

Line 771: hr_utility.trace(''||xml_d(g_catg2_t)||'');

767: xml_t(p_xml,''||xml_d(g_catg2_t+g_catg3_t)||'');
768: xml_t(p_xml,''||xml_d(g_catg2_o+g_catg3_o)||'');
769:
770: hr_utility.trace(''||xml_d(g_catg1_t)||'');
771: hr_utility.trace(''||xml_d(g_catg2_t)||'');
772: hr_utility.trace(''||xml_d(g_catg3_t)||'');
773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');
775: hr_utility.trace(''||xml_d(g_catg3_o)||'');

Line 772: hr_utility.trace(''||xml_d(g_catg3_t)||'');

768: xml_t(p_xml,''||xml_d(g_catg2_o+g_catg3_o)||'');
769:
770: hr_utility.trace(''||xml_d(g_catg1_t)||'');
771: hr_utility.trace(''||xml_d(g_catg2_t)||'');
772: hr_utility.trace(''||xml_d(g_catg3_t)||'');
773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');
775: hr_utility.trace(''||xml_d(g_catg3_o)||'');
776: hr_utility.trace(''||xml_d(g_catg2_t+g_catg3_t)||'');

Line 773: hr_utility.trace(''||xml_d(g_catg1_o)||'');

769:
770: hr_utility.trace(''||xml_d(g_catg1_t)||'');
771: hr_utility.trace(''||xml_d(g_catg2_t)||'');
772: hr_utility.trace(''||xml_d(g_catg3_t)||'');
773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');
775: hr_utility.trace(''||xml_d(g_catg3_o)||'');
776: hr_utility.trace(''||xml_d(g_catg2_t+g_catg3_t)||'');
777: hr_utility.trace(''||xml_d(g_catg2_o+g_catg3_o)||'');

Line 774: hr_utility.trace(''||xml_d(g_catg2_o)||'');

770: hr_utility.trace(''||xml_d(g_catg1_t)||'');
771: hr_utility.trace(''||xml_d(g_catg2_t)||'');
772: hr_utility.trace(''||xml_d(g_catg3_t)||'');
773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');
775: hr_utility.trace(''||xml_d(g_catg3_o)||'');
776: hr_utility.trace(''||xml_d(g_catg2_t+g_catg3_t)||'');
777: hr_utility.trace(''||xml_d(g_catg2_o+g_catg3_o)||'');
778:

Line 775: hr_utility.trace(''||xml_d(g_catg3_o)||'');

771: hr_utility.trace(''||xml_d(g_catg2_t)||'');
772: hr_utility.trace(''||xml_d(g_catg3_t)||'');
773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');
775: hr_utility.trace(''||xml_d(g_catg3_o)||'');
776: hr_utility.trace(''||xml_d(g_catg2_t+g_catg3_t)||'');
777: hr_utility.trace(''||xml_d(g_catg2_o+g_catg3_o)||'');
778:
779: g_catg1_t :=0;

Line 776: hr_utility.trace(''||xml_d(g_catg2_t+g_catg3_t)||'');

772: hr_utility.trace(''||xml_d(g_catg3_t)||'');
773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');
775: hr_utility.trace(''||xml_d(g_catg3_o)||'');
776: hr_utility.trace(''||xml_d(g_catg2_t+g_catg3_t)||'');
777: hr_utility.trace(''||xml_d(g_catg2_o+g_catg3_o)||'');
778:
779: g_catg1_t :=0;
780: g_catg2_t :=0;

Line 777: hr_utility.trace(''||xml_d(g_catg2_o+g_catg3_o)||'');

773: hr_utility.trace(''||xml_d(g_catg1_o)||'');
774: hr_utility.trace(''||xml_d(g_catg2_o)||'');
775: hr_utility.trace(''||xml_d(g_catg3_o)||'');
776: hr_utility.trace(''||xml_d(g_catg2_t+g_catg3_t)||'');
777: hr_utility.trace(''||xml_d(g_catg2_o+g_catg3_o)||'');
778:
779: g_catg1_t :=0;
780: g_catg2_t :=0;
781: g_catg3_t :=0;

Line 786: hr_utility.TRACE('');

782: g_catg1_o :=0;
783: g_catg2_o :=0;
784: g_catg3_o :=0;
785: xml_t(p_xml,'');
786: hr_utility.TRACE('');
787: end loop;
788:
789: END make_employee;
790: