DBA Data[Home] [Help]

APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_EXTRACT_DATA_PKG

Line 230: ** Package pay_element_extract_data_pkg (pyelerpd.pkh/pkb).

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

Line 426: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then

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:

Line 427: for i in pay_element_extract_data_pkg.ltt_element_extract_label.first ..

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 ||

Line 428: pay_element_extract_data_pkg.ltt_element_extract_label.last

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 (

Line 434: pay_element_extract_data_pkg.ltt_element_extract_label(i)

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;

Line 462: ** Package pay_element_extract_data_pkg (pyelerpd.pkh/pkb).

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

Line 559: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then

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:

Line 560: for i in pay_element_extract_data_pkg.ltt_element_extract_data.first ..

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 ||

Line 561: pay_element_extract_data_pkg.ltt_element_extract_data.last

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 (

Line 567: pay_element_extract_data_pkg.ltt_element_extract_data(i)

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:

Line 1321: pay_element_extract_data_pkg.populate_table(

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