APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_CA_PAYREG_EXTRACT_DATA_PKG

Line 302: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).

298: ** can insert data and the label in this PL/SQL table which will
299: ** be printed at the end of the report.
300: ** The PL/SQL table which needs to be populated is
301: ** LTT_PAYMENT_EXTRACT_DATA. This PL/SQL table is defined in the
302: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).
303: *****************************************************************/
304: PROCEDURE formated_static_header(
305: p_output_file_type in varchar2
306: ,p_static_label1 out NOCOPY varchar2

Line 469: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then

465:
466: /*******************************************************************
467: ** Only do this if there is some configuration data present
468: *******************************************************************/
469: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
470: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..
471: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last
472: loop
473:

Line 470: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..

466: /*******************************************************************
467: ** Only do this if there is some configuration data present
468: *******************************************************************/
469: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
470: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..
471: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last
472: loop
473:
474: lv_format2 := lv_format2 ||

Line 471: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last

467: ** Only do this if there is some configuration data present
468: *******************************************************************/
469: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
470: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..
471: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last
472: loop
473:
474: lv_format2 := lv_format2 ||
475: formated_data_string (

Line 477: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label(i)

473:
474: lv_format2 := lv_format2 ||
475: formated_data_string (
476: p_input_string =>
477: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label(i)
478: ,p_bold => 'Y'
479: ,p_output_file_type => p_output_file_type);
480:
481: end loop;

Line 506: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).

502: ** can insert data and the label in this PL/SQL table which will
503: ** be printed at the end of the report.
504: ** The PL/SQL table which needs to be populated is
505: ** LTT_PAYMENT_EXTRACT_DATA. This PL/SQL table is defined in the
506: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).
507: *****************************************************************/
508: /* Added two columns p_case_number, p_payee_name to format the
509: Third Party Payments, to fix bug#2745577 */
510: PROCEDURE formated_static_data(

Line 610: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then

606:
607: /*******************************************************************
608: ** Only do this if there is some configuration data present
609: *******************************************************************/
610: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
611:
612: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..
613: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last
614: loop

Line 612: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..

608: ** Only do this if there is some configuration data present
609: *******************************************************************/
610: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
611:
612: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..
613: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last
614: loop
615:
616: lv_format2 := lv_format2 ||

Line 613: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last

609: *******************************************************************/
610: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
611:
612: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..
613: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last
614: loop
615:
616: lv_format2 := lv_format2 ||
617: formated_data_string (

Line 619: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data(i)

615:
616: lv_format2 := lv_format2 ||
617: formated_data_string (
618: p_input_string =>
619: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data(i)
620: ,p_output_file_type => p_output_file_type);
621:
622: end loop;
623: end if;

Line 1299: /* pay_ca_payreg_extract_data_pkg.populate_table(

1295: /********************************************************************
1296: ** Populate the user defined PL/SQL table to print the additional
1297: ** columns in the report.
1298: ********************************************************************/
1299: /* pay_ca_payreg_extract_data_pkg.populate_table(
1300: p_assignment_id => ln_assignment_id
1301: ,p_person_id => ln_person_id
1302: ,p_assignment_action_id => ln_assignment_action_id
1303: ,p_effective_date=> ld_effective_date