226: ** can insert data and the label in this PL/SQL table which will
227: ** be printed at the end of the report.
228: ** The PL/SQL table which needs to be populated is
229: ** LTR_ELEMENT_EXTRACT_DATA. This PL/SQL table is defined in the
230: ** Package pay_element_extract_data_pkg (pyelerpd.pkh/pkb).
231: *****************************************************************/
232: PROCEDURE formated_static_header(
233: p_output_file_type in varchar2
234: ,p_static_label1 out nocopy varchar2
422:
423: /*******************************************************************
424: ** Only do this if there is some configuration data present
425: *******************************************************************/
426: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
427: for i in pay_element_extract_data_pkg.ltt_element_extract_label.first ..
428: pay_element_extract_data_pkg.ltt_element_extract_label.last
429: loop
430:
423: /*******************************************************************
424: ** Only do this if there is some configuration data present
425: *******************************************************************/
426: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
427: for i in pay_element_extract_data_pkg.ltt_element_extract_label.first ..
428: pay_element_extract_data_pkg.ltt_element_extract_label.last
429: loop
430:
431: lv_format2 := lv_format2 ||
424: ** Only do this if there is some configuration data present
425: *******************************************************************/
426: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
427: for i in pay_element_extract_data_pkg.ltt_element_extract_label.first ..
428: pay_element_extract_data_pkg.ltt_element_extract_label.last
429: loop
430:
431: lv_format2 := lv_format2 ||
432: formated_data_string (
430:
431: lv_format2 := lv_format2 ||
432: formated_data_string (
433: p_input_string =>
434: pay_element_extract_data_pkg.ltt_element_extract_label(i)
435: ,p_bold => 'Y'
436: ,p_output_file_type => p_output_file_type);
437:
438: end loop;
458: ** can insert data and the label in this PL/SQL table which will
459: ** be printed at the end of the report.
460: ** The PL/SQL table which needs to be populated is
461: ** LTR_ELEMENT_EXTRACT_DATA. This PL/SQL table is defined in the
462: ** Package pay_element_extract_data_pkg (pyelerpd.pkh/pkb).
463: *****************************************************************/
464: PROCEDURE formated_static_data (
465: p_action_type in varchar2
466: ,p_action_effective_date in date
555:
556: /*******************************************************************
557: ** Only do this if there is some configuration data present
558: *******************************************************************/
559: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
560: for i in pay_element_extract_data_pkg.ltt_element_extract_data.first ..
561: pay_element_extract_data_pkg.ltt_element_extract_data.last
562: loop
563:
556: /*******************************************************************
557: ** Only do this if there is some configuration data present
558: *******************************************************************/
559: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
560: for i in pay_element_extract_data_pkg.ltt_element_extract_data.first ..
561: pay_element_extract_data_pkg.ltt_element_extract_data.last
562: loop
563:
564: lv_format2 := lv_format2 ||
557: ** Only do this if there is some configuration data present
558: *******************************************************************/
559: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
560: for i in pay_element_extract_data_pkg.ltt_element_extract_data.first ..
561: pay_element_extract_data_pkg.ltt_element_extract_data.last
562: loop
563:
564: lv_format2 := lv_format2 ||
565: formated_data_string (
563:
564: lv_format2 := lv_format2 ||
565: formated_data_string (
566: p_input_string =>
567: pay_element_extract_data_pkg.ltt_element_extract_data(i)
568: ,p_output_file_type => p_output_file_type);
569: end loop;
570: end if;
571:
1317: /********************************************************************
1318: ** Populate the user defined PL/SQL table to print the additional
1319: ** columns in the report.
1320: ********************************************************************/
1321: pay_element_extract_data_pkg.populate_table(
1322: p_assignment_id => ln_assignment_id
1323: ,p_person_id => ln_person_id
1324: ,p_assignment_action_id => ln_assignment_action_id
1325: ,p_effective_date=> ld_effective_date