DBA Data[Home] [Help]

APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_EXTRACT_DATA_PKG

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

217: ** can insert data and the label in this PL/SQL table which will
218: ** be printed at the end of the report.
219: ** The PL/SQL table which needs to be populated is
220: ** LTR_ELEMENT_EXTRACT_DATA. This PL/SQL table is defined in the
221: ** Package pay_element_extract_data_pkg (pyelerpd.pkh/pkb).
222: *****************************************************************/
223: PROCEDURE formated_static_header(
224: p_output_file_type in varchar2
225: ,p_static_label1 out nocopy varchar2

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

413:
414: /*******************************************************************
415: ** Only do this if there is some configuration data present
416: *******************************************************************/
417: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
418: for i in pay_element_extract_data_pkg.ltt_element_extract_label.first ..
419: pay_element_extract_data_pkg.ltt_element_extract_label.last
420: loop
421:

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

414: /*******************************************************************
415: ** Only do this if there is some configuration data present
416: *******************************************************************/
417: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
418: for i in pay_element_extract_data_pkg.ltt_element_extract_label.first ..
419: pay_element_extract_data_pkg.ltt_element_extract_label.last
420: loop
421:
422: lv_format2 := lv_format2 ||

Line 419: pay_element_extract_data_pkg.ltt_element_extract_label.last

415: ** Only do this if there is some configuration data present
416: *******************************************************************/
417: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
418: for i in pay_element_extract_data_pkg.ltt_element_extract_label.first ..
419: pay_element_extract_data_pkg.ltt_element_extract_label.last
420: loop
421:
422: lv_format2 := lv_format2 ||
423: formated_data_string (

Line 425: pay_element_extract_data_pkg.ltt_element_extract_label(i)

421:
422: lv_format2 := lv_format2 ||
423: formated_data_string (
424: p_input_string =>
425: pay_element_extract_data_pkg.ltt_element_extract_label(i)
426: ,p_bold => 'Y'
427: ,p_output_file_type => p_output_file_type);
428:
429: end loop;

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

449: ** can insert data and the label in this PL/SQL table which will
450: ** be printed at the end of the report.
451: ** The PL/SQL table which needs to be populated is
452: ** LTR_ELEMENT_EXTRACT_DATA. This PL/SQL table is defined in the
453: ** Package pay_element_extract_data_pkg (pyelerpd.pkh/pkb).
454: *****************************************************************/
455: PROCEDURE formated_static_data (
456: p_action_type in varchar2
457: ,p_action_effective_date in date

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

546:
547: /*******************************************************************
548: ** Only do this if there is some configuration data present
549: *******************************************************************/
550: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
551: for i in pay_element_extract_data_pkg.ltt_element_extract_data.first ..
552: pay_element_extract_data_pkg.ltt_element_extract_data.last
553: loop
554:

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

547: /*******************************************************************
548: ** Only do this if there is some configuration data present
549: *******************************************************************/
550: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
551: for i in pay_element_extract_data_pkg.ltt_element_extract_data.first ..
552: pay_element_extract_data_pkg.ltt_element_extract_data.last
553: loop
554:
555: lv_format2 := lv_format2 ||

Line 552: pay_element_extract_data_pkg.ltt_element_extract_data.last

548: ** Only do this if there is some configuration data present
549: *******************************************************************/
550: if pay_element_extract_data_pkg.ltt_element_extract_label.count > 0 then
551: for i in pay_element_extract_data_pkg.ltt_element_extract_data.first ..
552: pay_element_extract_data_pkg.ltt_element_extract_data.last
553: loop
554:
555: lv_format2 := lv_format2 ||
556: formated_data_string (

Line 558: pay_element_extract_data_pkg.ltt_element_extract_data(i)

554:
555: lv_format2 := lv_format2 ||
556: formated_data_string (
557: p_input_string =>
558: pay_element_extract_data_pkg.ltt_element_extract_data(i)
559: ,p_output_file_type => p_output_file_type);
560: end loop;
561: end if;
562:

Line 1312: pay_element_extract_data_pkg.populate_table(

1308: /********************************************************************
1309: ** Populate the user defined PL/SQL table to print the additional
1310: ** columns in the report.
1311: ********************************************************************/
1312: pay_element_extract_data_pkg.populate_table(
1313: p_assignment_id => ln_assignment_id
1314: ,p_person_id => ln_person_id
1315: ,p_assignment_action_id => ln_assignment_action_id
1316: ,p_effective_date=> ld_effective_date