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.PAY_COSTING_SUMMARY_X_REP_PKG dependencies on PAY_PRL_XML_UTILS

Line 122: RETURN pay_prl_xml_utils.getTag(p_tag_Name => 'C_BUSINESS_GROUP'

118: l_costing := fnd_date.date_to_displaydate( p_start_date)||
119: '('||p_costing||')';
120: END IF;
121:
122: RETURN pay_prl_xml_utils.getTag(p_tag_Name => 'C_BUSINESS_GROUP'
123: ,p_tag_value => p_business_group)||
124: pay_prl_xml_utils.getTag(p_tag_Name => 'C_STARTDATE_ICX'
125: ,p_tag_value => fnd_date.date_to_displaydate(
126: p_start_date))||

Line 124: pay_prl_xml_utils.getTag(p_tag_Name => 'C_STARTDATE_ICX'

120: END IF;
121:
122: RETURN pay_prl_xml_utils.getTag(p_tag_Name => 'C_BUSINESS_GROUP'
123: ,p_tag_value => p_business_group)||
124: pay_prl_xml_utils.getTag(p_tag_Name => 'C_STARTDATE_ICX'
125: ,p_tag_value => fnd_date.date_to_displaydate(
126: p_start_date))||
127: pay_prl_xml_utils.getTag(p_tag_Name => 'C_ENDDATE_ICX'
128: ,p_tag_value => fnd_date.date_to_displaydate(

Line 127: pay_prl_xml_utils.getTag(p_tag_Name => 'C_ENDDATE_ICX'

123: ,p_tag_value => p_business_group)||
124: pay_prl_xml_utils.getTag(p_tag_Name => 'C_STARTDATE_ICX'
125: ,p_tag_value => fnd_date.date_to_displaydate(
126: p_start_date))||
127: pay_prl_xml_utils.getTag(p_tag_Name => 'C_ENDDATE_ICX'
128: ,p_tag_value => fnd_date.date_to_displaydate(
129: p_end_date))||
130: pay_prl_xml_utils.getTag(p_tag_Name => 'C_COSTING'
131: ,p_tag_value => l_costing)||

Line 130: pay_prl_xml_utils.getTag(p_tag_Name => 'C_COSTING'

126: p_start_date))||
127: pay_prl_xml_utils.getTag(p_tag_Name => 'C_ENDDATE_ICX'
128: ,p_tag_value => fnd_date.date_to_displaydate(
129: p_end_date))||
130: pay_prl_xml_utils.getTag(p_tag_Name => 'C_COSTING'
131: ,p_tag_value => l_costing)||
132: pay_prl_xml_utils.getTag(p_tag_Name => 'C_PAYROLL_NAME'
133: ,p_tag_value => p_payroll_name)||
134: pay_prl_xml_utils.getTag(p_tag_Name => 'C_CONSOLIDATION_SET'

Line 132: pay_prl_xml_utils.getTag(p_tag_Name => 'C_PAYROLL_NAME'

128: ,p_tag_value => fnd_date.date_to_displaydate(
129: p_end_date))||
130: pay_prl_xml_utils.getTag(p_tag_Name => 'C_COSTING'
131: ,p_tag_value => l_costing)||
132: pay_prl_xml_utils.getTag(p_tag_Name => 'C_PAYROLL_NAME'
133: ,p_tag_value => p_payroll_name)||
134: pay_prl_xml_utils.getTag(p_tag_Name => 'C_CONSOLIDATION_SET'
135: ,p_tag_value => p_consolidation_set_name)||
136: pay_prl_xml_utils.getTag(p_tag_Name => 'C_GRE_NAME'

Line 134: pay_prl_xml_utils.getTag(p_tag_Name => 'C_CONSOLIDATION_SET'

130: pay_prl_xml_utils.getTag(p_tag_Name => 'C_COSTING'
131: ,p_tag_value => l_costing)||
132: pay_prl_xml_utils.getTag(p_tag_Name => 'C_PAYROLL_NAME'
133: ,p_tag_value => p_payroll_name)||
134: pay_prl_xml_utils.getTag(p_tag_Name => 'C_CONSOLIDATION_SET'
135: ,p_tag_value => p_consolidation_set_name)||
136: pay_prl_xml_utils.getTag(p_tag_Name => 'C_GRE_NAME'
137: ,p_tag_value => p_gre_name)||
138: pay_prl_xml_utils.getTag(p_tag_Name => 'C_INCLUDE_ACCRUALS'

Line 136: pay_prl_xml_utils.getTag(p_tag_Name => 'C_GRE_NAME'

132: pay_prl_xml_utils.getTag(p_tag_Name => 'C_PAYROLL_NAME'
133: ,p_tag_value => p_payroll_name)||
134: pay_prl_xml_utils.getTag(p_tag_Name => 'C_CONSOLIDATION_SET'
135: ,p_tag_value => p_consolidation_set_name)||
136: pay_prl_xml_utils.getTag(p_tag_Name => 'C_GRE_NAME'
137: ,p_tag_value => p_gre_name)||
138: pay_prl_xml_utils.getTag(p_tag_Name => 'C_INCLUDE_ACCRUALS'
139: ,p_tag_value => p_include_accruals)||
140: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER1'

Line 138: pay_prl_xml_utils.getTag(p_tag_Name => 'C_INCLUDE_ACCRUALS'

134: pay_prl_xml_utils.getTag(p_tag_Name => 'C_CONSOLIDATION_SET'
135: ,p_tag_value => p_consolidation_set_name)||
136: pay_prl_xml_utils.getTag(p_tag_Name => 'C_GRE_NAME'
137: ,p_tag_value => p_gre_name)||
138: pay_prl_xml_utils.getTag(p_tag_Name => 'C_INCLUDE_ACCRUALS'
139: ,p_tag_value => p_include_accruals)||
140: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER1'
141: ,p_tag_value => p_sort_order1)||
142: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER2'

Line 140: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER1'

136: pay_prl_xml_utils.getTag(p_tag_Name => 'C_GRE_NAME'
137: ,p_tag_value => p_gre_name)||
138: pay_prl_xml_utils.getTag(p_tag_Name => 'C_INCLUDE_ACCRUALS'
139: ,p_tag_value => p_include_accruals)||
140: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER1'
141: ,p_tag_value => p_sort_order1)||
142: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER2'
143: ,p_tag_value => p_sort_order2)||
144: pay_prl_xml_utils.getTag(p_tag_name => 'C_TEMPLATE_NAME'

Line 142: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER2'

138: pay_prl_xml_utils.getTag(p_tag_Name => 'C_INCLUDE_ACCRUALS'
139: ,p_tag_value => p_include_accruals)||
140: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER1'
141: ,p_tag_value => p_sort_order1)||
142: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER2'
143: ,p_tag_value => p_sort_order2)||
144: pay_prl_xml_utils.getTag(p_tag_name => 'C_TEMPLATE_NAME'
145: ,p_tag_value => get_template_name(
146: p_app_short_name => 'PAY'

Line 144: pay_prl_xml_utils.getTag(p_tag_name => 'C_TEMPLATE_NAME'

140: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER1'
141: ,p_tag_value => p_sort_order1)||
142: pay_prl_xml_utils.getTag(p_tag_Name => 'C_SORT_ORDER2'
143: ,p_tag_value => p_sort_order2)||
144: pay_prl_xml_utils.getTag(p_tag_name => 'C_TEMPLATE_NAME'
145: ,p_tag_value => get_template_name(
146: p_app_short_name => 'PAY'
147: ,p_template_code =>
148: p_template_name));

Line 531: --Clearing the PL/SQL table of package pay_prl_xml_utils

527: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
528: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
529:
530: lv_costing_process_flag := 'N';
531: --Clearing the PL/SQL table of package pay_prl_xml_utils
532: pay_prl_xml_utils.gXMLTable.DELETE;
533: --
534: fnd_file.put_line(fnd_file.log,'Creating the XML...');
535:

Line 532: pay_prl_xml_utils.gXMLTable.DELETE;

528: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
529:
530: lv_costing_process_flag := 'N';
531: --Clearing the PL/SQL table of package pay_prl_xml_utils
532: pay_prl_xml_utils.gXMLTable.DELETE;
533: --
534: fnd_file.put_line(fnd_file.log,'Creating the XML...');
535:
536: --Creating a CLOB and opening the CLOB.

Line 608: lv_tableHeadings := pay_prl_xml_utils.getTag('CSR_GRE_OR_PAYROLL_HEADING',

604: lv_csr_heading :='Costing Summary Report - GRE Totals';
605: lv_total_heading := 'GRE Totals';
606: END IF;
607:
608: lv_tableHeadings := pay_prl_xml_utils.getTag('CSR_GRE_OR_PAYROLL_HEADING',
609: lv_csr_heading)||
610: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL_TOTAL_HEADING',
611: lv_total_heading);
612: lv_tagged_parameters := lv_tagged_parameters || lv_tableHeadings;

Line 610: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL_TOTAL_HEADING',

606: END IF;
607:
608: lv_tableHeadings := pay_prl_xml_utils.getTag('CSR_GRE_OR_PAYROLL_HEADING',
609: lv_csr_heading)||
610: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL_TOTAL_HEADING',
611: lv_total_heading);
612: lv_tagged_parameters := lv_tagged_parameters || lv_tableHeadings;
613:
614: /***********************************************************************

Line 746: pay_prl_xml_utils.getTag(

742: --If no data is returned from the cursor then need to populate the
743: --XML data with no values.
744: IF(l_nodata_flag = TRUE) THEN
745: lv_tagged_parameters := lv_tagged_parameters||
746: pay_prl_xml_utils.getTag(
747: 'C_G_ASG_COSTING_DETAILS_NODATA',
748: '1');
749: l_tag := '';
750:

Line 752: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||

748: '1');
749: l_tag := '';
750:
751: l_tag := l_tag||
752: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
753: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
754: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
755: NULL)||
756: pay_prl_xml_utils.getTag('UOM',NULL)||

Line 753: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||

749: l_tag := '';
750:
751: l_tag := l_tag||
752: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
753: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
754: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
755: NULL)||
756: pay_prl_xml_utils.getTag('UOM',NULL)||
757: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||

Line 754: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',

750:
751: l_tag := l_tag||
752: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
753: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
754: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
755: NULL)||
756: pay_prl_xml_utils.getTag('UOM',NULL)||
757: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
758: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||

Line 756: pay_prl_xml_utils.getTag('UOM',NULL)||

752: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
753: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
754: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
755: NULL)||
756: pay_prl_xml_utils.getTag('UOM',NULL)||
757: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
758: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
759: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
760:

Line 757: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||

753: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
754: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
755: NULL)||
756: pay_prl_xml_utils.getTag('UOM',NULL)||
757: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
758: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
759: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
760:
761: --Need to provide the Heading of the columns eventhough no data

Line 758: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||

754: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
755: NULL)||
756: pay_prl_xml_utils.getTag('UOM',NULL)||
757: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
758: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
759: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
760:
761: --Need to provide the Heading of the columns eventhough no data
762: --found.So here it's going to fill the Column heading data.

Line 759: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);

755: NULL)||
756: pay_prl_xml_utils.getTag('UOM',NULL)||
757: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
758: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
759: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
760:
761: --Need to provide the Heading of the columns eventhough no data
762: --found.So here it's going to fill the Column heading data.
763: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP

Line 765: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(

761: --Need to provide the Heading of the columns eventhough no data
762: --found.So here it's going to fill the Column heading data.
763: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
764: l_tag:= l_tag||''||
765: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
766: gtr_costing_segment(i).segment_label))||
767: pay_prl_xml_utils.getTag('VALUE',NULL)||
768: '';
769: END LOOP;

Line 767: pay_prl_xml_utils.getTag('VALUE',NULL)||

763: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
764: l_tag:= l_tag||''||
765: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
766: gtr_costing_segment(i).segment_label))||
767: pay_prl_xml_utils.getTag('VALUE',NULL)||
768: '';
769: END LOOP;
770: l_tag :=l_tag||'';
771: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 781: pay_prl_xml_utils.getTag(

777: -- in the XML output.
778: l_nodata_flag := FALSE;
779: IF(l_rec_count = 0) THEN
780: lv_tagged_parameters := lv_tagged_parameters||
781: pay_prl_xml_utils.getTag(
782: 'C_G_ASG_COSTING_DETAILS_NODATA',
783: '0');
784: END IF;
785: l_rec_count := l_rec_count + 1;

Line 834: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||

830: --data variable.
831: l_tag := '';
832:
833: l_tag := l_tag||
834: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
835: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
836: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
837: lv_input_value_name)||
838: pay_prl_xml_utils.getTag('UOM',lv_uom)||

Line 835: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||

831: l_tag := '';
832:
833: l_tag := l_tag||
834: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
835: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
836: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
837: lv_input_value_name)||
838: pay_prl_xml_utils.getTag('UOM',lv_uom)||
839: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||

Line 836: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',

832:
833: l_tag := l_tag||
834: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
835: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
836: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
837: lv_input_value_name)||
838: pay_prl_xml_utils.getTag('UOM',lv_uom)||
839: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
840: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||

Line 838: pay_prl_xml_utils.getTag('UOM',lv_uom)||

834: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
835: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
836: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
837: lv_input_value_name)||
838: pay_prl_xml_utils.getTag('UOM',lv_uom)||
839: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
840: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
841: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
842:

Line 839: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||

835: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
836: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
837: lv_input_value_name)||
838: pay_prl_xml_utils.getTag('UOM',lv_uom)||
839: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
840: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
841: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
842:
843: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 840: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||

836: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
837: lv_input_value_name)||
838: pay_prl_xml_utils.getTag('UOM',lv_uom)||
839: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
840: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
841: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
842:
843: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
844:

Line 841: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);

837: lv_input_value_name)||
838: pay_prl_xml_utils.getTag('UOM',lv_uom)||
839: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
840: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
841: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
842:
843: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
844:
845: l_count := 1;

Line 891: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(

887: elsIF gtr_costing_segment(i).column_name = 'SEGMENT20' THEN
888: lv_segment_value := lv_segment20;
889: END IF;
890:
891: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
892: gtr_costing_segment(i).segment_label);
893: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
894:
895: l_count := l_count + 1;

Line 893: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;

889: END IF;
890:
891: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
892: gtr_costing_segment(i).segment_label);
893: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
894:
895: l_count := l_count + 1;
896:
897: END LOOP ;

Line 899: pay_prl_xml_utils.twoColumnar(p_type => 'G_ASG_COSTING_DETAILS_SEGMENT'

895: l_count := l_count + 1;
896:
897: END LOOP ;
898:
899: pay_prl_xml_utils.twoColumnar(p_type => 'G_ASG_COSTING_DETAILS_SEGMENT'
900: ,p_data => pay_prl_xml_utils.gXMLTable
901: ,p_count => l_count
902: ,p_xml_data => g_xml_data);
903: pay_prl_xml_utils.gXMLTable.delete;

Line 900: ,p_data => pay_prl_xml_utils.gXMLTable

896:
897: END LOOP ;
898:
899: pay_prl_xml_utils.twoColumnar(p_type => 'G_ASG_COSTING_DETAILS_SEGMENT'
900: ,p_data => pay_prl_xml_utils.gXMLTable
901: ,p_count => l_count
902: ,p_xml_data => g_xml_data);
903: pay_prl_xml_utils.gXMLTable.delete;
904:

Line 903: pay_prl_xml_utils.gXMLTable.delete;

899: pay_prl_xml_utils.twoColumnar(p_type => 'G_ASG_COSTING_DETAILS_SEGMENT'
900: ,p_data => pay_prl_xml_utils.gXMLTable
901: ,p_count => l_count
902: ,p_xml_data => g_xml_data);
903: pay_prl_xml_utils.gXMLTable.delete;
904:
905: l_tag := '';
906:
907: --Appending the XML data into the Global XML data variable.

Line 921: pay_prl_xml_utils.gXMLTable.delete;

917: * This code is for populating the XML with the Costing Summary *
918: * Report for GRE/Payroll Depends on the parameter. *
919: ********************************************************************/
920:
921: pay_prl_xml_utils.gXMLTable.delete;
922:
923: l_nodata_flag := TRUE;
924: l_rec_count := 0;
925:

Line 972: pay_prl_xml_utils.getTag(

968: --XML data with no values.
969: IF(l_nodata_flag = TRUE) THEN
970:
971: lv_tagged_parameters := lv_tagged_parameters||
972: pay_prl_xml_utils.getTag(
973: 'C_G_CSR_GRE_OR_PRL_TOTAL_NODATA',
974: '1');
975: l_tag := '';
976: l_tag := l_tag||

Line 977: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||

973: 'C_G_CSR_GRE_OR_PRL_TOTAL_NODATA',
974: '1');
975: l_tag := '';
976: l_tag := l_tag||
977: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
978: pay_prl_xml_utils.getTag('UOM',NULL)||
979: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
980: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
981:

Line 978: pay_prl_xml_utils.getTag('UOM',NULL)||

974: '1');
975: l_tag := '';
976: l_tag := l_tag||
977: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
978: pay_prl_xml_utils.getTag('UOM',NULL)||
979: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
980: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
981:
982: --Need to provide the Heading of the columns eventhough no data

Line 979: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||

975: l_tag := '';
976: l_tag := l_tag||
977: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
978: pay_prl_xml_utils.getTag('UOM',NULL)||
979: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
980: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
981:
982: --Need to provide the Heading of the columns eventhough no data
983: --found.So here it's going to fill the Column heading data.

Line 980: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);

976: l_tag := l_tag||
977: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
978: pay_prl_xml_utils.getTag('UOM',NULL)||
979: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
980: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
981:
982: --Need to provide the Heading of the columns eventhough no data
983: --found.So here it's going to fill the Column heading data.
984: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP

Line 986: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(

982: --Need to provide the Heading of the columns eventhough no data
983: --found.So here it's going to fill the Column heading data.
984: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
985: l_tag := l_tag ||''||
986: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
987: gtr_costing_segment(i).segment_label))||
988: pay_prl_xml_utils.getTag('VALUE',NULL)||
989: '';
990: END LOOP;

Line 988: pay_prl_xml_utils.getTag('VALUE',NULL)||

984: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
985: l_tag := l_tag ||''||
986: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
987: gtr_costing_segment(i).segment_label))||
988: pay_prl_xml_utils.getTag('VALUE',NULL)||
989: '';
990: END LOOP;
991:
992: l_tag :=l_tag ||'';

Line 1005: pay_prl_xml_utils.getTag(

1001: -- in the XML output.
1002: l_nodata_flag := FALSE;
1003: IF(l_rec_count = 0)THEN
1004: lv_tagged_parameters := lv_tagged_parameters||
1005: pay_prl_xml_utils.getTag(
1006: 'C_G_CSR_GRE_OR_PRL_TOTAL_NODATA',
1007: '0');
1008: END IF;
1009: l_rec_count := l_rec_count + 1;

Line 1016: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||

1012: --data variable.
1013: l_tag := '';
1014:
1015: l_tag := l_tag||
1016: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1017: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1018: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1019: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1020:

Line 1017: pay_prl_xml_utils.getTag('UOM',lv_uom)||

1013: l_tag := '';
1014:
1015: l_tag := l_tag||
1016: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1017: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1018: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1019: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1020:
1021: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1018: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||

1014:
1015: l_tag := l_tag||
1016: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1017: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1018: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1019: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1020:
1021: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1022:

Line 1019: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);

1015: l_tag := l_tag||
1016: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1017: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1018: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1019: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1020:
1021: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1022:
1023: l_count := 1;

Line 1068: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(

1064: elsIF gtr_costing_segment(i).column_name = 'SEGMENT20' THEN
1065: lv_segment_value := lv_segment20;
1066: END IF;
1067:
1068: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1069: gtr_costing_segment(i).segment_label);
1070: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1071:
1072: l_count := l_count + 1;

Line 1070: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;

1066: END IF;
1067:
1068: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1069: gtr_costing_segment(i).segment_label);
1070: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1071:
1072: l_count := l_count + 1;
1073:
1074: END LOOP ;

Line 1076: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRE_OR_PRL_TOTAL_SEGMENT'

1072: l_count := l_count + 1;
1073:
1074: END LOOP ;
1075:
1076: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRE_OR_PRL_TOTAL_SEGMENT'
1077: ,p_data => pay_prl_xml_utils.gXMLTable
1078: ,p_count => l_count
1079: ,p_xml_data => g_xml_data);
1080: pay_prl_xml_utils.gXMLTable.delete;

Line 1077: ,p_data => pay_prl_xml_utils.gXMLTable

1073:
1074: END LOOP ;
1075:
1076: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRE_OR_PRL_TOTAL_SEGMENT'
1077: ,p_data => pay_prl_xml_utils.gXMLTable
1078: ,p_count => l_count
1079: ,p_xml_data => g_xml_data);
1080: pay_prl_xml_utils.gXMLTable.delete;
1081:

Line 1080: pay_prl_xml_utils.gXMLTable.delete;

1076: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRE_OR_PRL_TOTAL_SEGMENT'
1077: ,p_data => pay_prl_xml_utils.gXMLTable
1078: ,p_count => l_count
1079: ,p_xml_data => g_xml_data);
1080: pay_prl_xml_utils.gXMLTable.delete;
1081:
1082: l_tag := '';
1083:
1084: --Appending the XML data into the Global XML data variable.

Line 1098: pay_prl_xml_utils.gXMLTable.delete;

1094: ** This code is for populating the XML with the Costing Summary **
1095: ** Report for GRE/Payroll totals Depends on the parameter. **
1096: ********************************************************************/
1097:
1098: pay_prl_xml_utils.gXMLTable.delete;
1099:
1100: l_nodata_flag := TRUE;
1101: l_rec_count := 0;
1102: l_tag := '';

Line 1126: pay_prl_xml_utils.getTag(

1122: --If no data is returned from the cursor then need to populate the
1123: --XML data with no values.
1124: IF(l_nodata_flag=TRUE) THEN
1125: lv_tagged_parameters := lv_tagged_parameters||
1126: pay_prl_xml_utils.getTag(
1127: 'C_G_GRE_OR_PRL_TOTAL_NODATA',
1128: '1');
1129: l_tag := '';
1130: l_tag := l_tag||

Line 1131: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||

1127: 'C_G_GRE_OR_PRL_TOTAL_NODATA',
1128: '1');
1129: l_tag := '';
1130: l_tag := l_tag||
1131: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1132: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1133: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1134: pay_prl_xml_utils.getTag('UOM',NULL)||
1135: '';

Line 1132: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||

1128: '1');
1129: l_tag := '';
1130: l_tag := l_tag||
1131: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1132: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1133: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1134: pay_prl_xml_utils.getTag('UOM',NULL)||
1135: '';
1136: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1133: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||

1129: l_tag := '';
1130: l_tag := l_tag||
1131: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1132: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1133: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1134: pay_prl_xml_utils.getTag('UOM',NULL)||
1135: '';
1136: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1137: END IF;

Line 1134: pay_prl_xml_utils.getTag('UOM',NULL)||

1130: l_tag := l_tag||
1131: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1132: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1133: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1134: pay_prl_xml_utils.getTag('UOM',NULL)||
1135: '';
1136: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1137: END IF;
1138: EXIT;

Line 1146: pay_prl_xml_utils.getTag(

1142: -- in the XML output.
1143: l_nodata_flag := FALSE;
1144: IF(l_rec_count = 0)THEN
1145: lv_tagged_parameters := lv_tagged_parameters||
1146: pay_prl_xml_utils.getTag(
1147: 'C_G_GRE_OR_PRL_TOTAL_NODATA',
1148: '0');
1149: END IF;
1150: l_rec_count := l_rec_count + 1;

Line 1152: pay_prl_xml_utils.gXMLTable(l_count).Name := 'GRE_OR_PAYROLL';

1148: '0');
1149: END IF;
1150: l_rec_count := l_rec_count + 1;
1151: l_count := 1;
1152: pay_prl_xml_utils.gXMLTable(l_count).Name := 'GRE_OR_PAYROLL';
1153: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1154: l_count := l_count + 1;
1155:
1156: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';

Line 1153: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;

1149: END IF;
1150: l_rec_count := l_rec_count + 1;
1151: l_count := 1;
1152: pay_prl_xml_utils.gXMLTable(l_count).Name := 'GRE_OR_PAYROLL';
1153: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1154: l_count := l_count + 1;
1155:
1156: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1157: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;

Line 1156: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';

1152: pay_prl_xml_utils.gXMLTable(l_count).Name := 'GRE_OR_PAYROLL';
1153: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1154: l_count := l_count + 1;
1155:
1156: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1157: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;
1158: l_count := l_count + 1;
1159:
1160: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';

Line 1157: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;

1153: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1154: l_count := l_count + 1;
1155:
1156: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1157: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;
1158: l_count := l_count + 1;
1159:
1160: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1161: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;

Line 1160: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';

1156: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1157: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;
1158: l_count := l_count + 1;
1159:
1160: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1161: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;
1162: l_count := l_count + 1;
1163:
1164: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';

Line 1161: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;

1157: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;
1158: l_count := l_count + 1;
1159:
1160: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1161: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;
1162: l_count := l_count + 1;
1163:
1164: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1165: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;

Line 1164: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';

1160: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1161: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;
1162: l_count := l_count + 1;
1163:
1164: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1165: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1166:
1167: --Appending the XML data into the Global XML data variable by
1168: --invoking the multiColumnar in the pay_prl_xml_utils package.

Line 1165: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;

1161: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;
1162: l_count := l_count + 1;
1163:
1164: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1165: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1166:
1167: --Appending the XML data into the Global XML data variable by
1168: --invoking the multiColumnar in the pay_prl_xml_utils package.
1169: pay_prl_xml_utils.multiColumnar(

Line 1168: --invoking the multiColumnar in the pay_prl_xml_utils package.

1164: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1165: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1166:
1167: --Appending the XML data into the Global XML data variable by
1168: --invoking the multiColumnar in the pay_prl_xml_utils package.
1169: pay_prl_xml_utils.multiColumnar(
1170: 'G_GRE_OR_PRL_TOTAL',
1171: pay_prl_xml_utils.gXMLTable,
1172: l_count,

Line 1169: pay_prl_xml_utils.multiColumnar(

1165: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1166:
1167: --Appending the XML data into the Global XML data variable by
1168: --invoking the multiColumnar in the pay_prl_xml_utils package.
1169: pay_prl_xml_utils.multiColumnar(
1170: 'G_GRE_OR_PRL_TOTAL',
1171: pay_prl_xml_utils.gXMLTable,
1172: l_count,
1173: g_xml_data);

Line 1171: pay_prl_xml_utils.gXMLTable,

1167: --Appending the XML data into the Global XML data variable by
1168: --invoking the multiColumnar in the pay_prl_xml_utils package.
1169: pay_prl_xml_utils.multiColumnar(
1170: 'G_GRE_OR_PRL_TOTAL',
1171: pay_prl_xml_utils.gXMLTable,
1172: l_count,
1173: g_xml_data);
1174: pay_prl_xml_utils.gXMLTable.delete;
1175:

Line 1174: pay_prl_xml_utils.gXMLTable.delete;

1170: 'G_GRE_OR_PRL_TOTAL',
1171: pay_prl_xml_utils.gXMLTable,
1172: l_count,
1173: g_xml_data);
1174: pay_prl_xml_utils.gXMLTable.delete;
1175:
1176: END LOOP;
1177: CLOSE c_get_gre_or_payroll_totals;
1178:

Line 1187: pay_prl_xml_utils.gXMLTable.delete;

1183: * This code is for populating the XML with the Costing Summary *
1184: * Report for Grand Totals. *
1185: ********************************************************************/
1186:
1187: pay_prl_xml_utils.gXMLTable.delete;
1188:
1189: l_nodata_flag := TRUE;
1190: l_rec_count := 0;
1191: l_tag := '';

Line 1234: pay_prl_xml_utils.getTag(

1230: '.costing_summary', 120);
1231:
1232: IF (l_nodata_flag = TRUE)THEN
1233: lv_tagged_parameters := lv_tagged_parameters||
1234: pay_prl_xml_utils.getTag(
1235: 'C_G_CSR_GRAND_TOTAL_NODATA',
1236: '1');
1237: l_tag := '';
1238:

Line 1240: pay_prl_xml_utils.getTag('UOM',NULL)||

1236: '1');
1237: l_tag := '';
1238:
1239: l_tag := l_tag||
1240: pay_prl_xml_utils.getTag('UOM',NULL)||
1241: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1242: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1243:
1244: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP

Line 1241: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||

1237: l_tag := '';
1238:
1239: l_tag := l_tag||
1240: pay_prl_xml_utils.getTag('UOM',NULL)||
1241: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1242: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1243:
1244: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1245: l_tag := l_tag ||''||

Line 1242: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);

1238:
1239: l_tag := l_tag||
1240: pay_prl_xml_utils.getTag('UOM',NULL)||
1241: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1242: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1243:
1244: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1245: l_tag := l_tag ||''||
1246: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(

Line 1246: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(

1242: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1243:
1244: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1245: l_tag := l_tag ||''||
1246: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
1247: gtr_costing_segment(i).segment_label))||
1248: pay_prl_xml_utils.getTag('VALUE',NULL)||
1249: '';
1250: END LOOP;

Line 1248: pay_prl_xml_utils.getTag('VALUE',NULL)||

1244: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1245: l_tag := l_tag ||''||
1246: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
1247: gtr_costing_segment(i).segment_label))||
1248: pay_prl_xml_utils.getTag('VALUE',NULL)||
1249: '';
1250: END LOOP;
1251: l_tag := l_tag ||'';
1252: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1260: pay_prl_xml_utils.getTag(

1256:
1257: l_nodata_flag := FALSE;
1258: IF(l_rec_count = 0) THEN
1259: lv_tagged_parameters := lv_tagged_parameters||
1260: pay_prl_xml_utils.getTag(
1261: 'C_G_CSR_GRAND_TOTAL_NODATA',
1262: '0');
1263: END IF;
1264: l_rec_count := l_rec_count + 1;

Line 1268: pay_prl_xml_utils.getTag('UOM',lv_uom)||

1264: l_rec_count := l_rec_count + 1;
1265: l_tag := '';
1266:
1267: l_tag := l_tag||
1268: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1269: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1270: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1271:
1272: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1269: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||

1265: l_tag := '';
1266:
1267: l_tag := l_tag||
1268: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1269: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1270: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1271:
1272: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1273:

Line 1270: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);

1266:
1267: l_tag := l_tag||
1268: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1269: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1270: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1271:
1272: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1273:
1274: l_count := 1;

Line 1318: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(

1314: elsIF gtr_costing_segment(i).column_name = 'SEGMENT20' THEN
1315: lv_segment_value := lv_segment20;
1316: END IF;
1317:
1318: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1319: gtr_costing_segment(i).segment_label);
1320: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1321:
1322: l_count := l_count + 1;

Line 1320: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;

1316: END IF;
1317:
1318: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1319: gtr_costing_segment(i).segment_label);
1320: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1321:
1322: l_count := l_count + 1;
1323:
1324: END LOOP ;

Line 1326: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRAND_TOTAL_SEGMENT'

1322: l_count := l_count + 1;
1323:
1324: END LOOP ;
1325:
1326: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRAND_TOTAL_SEGMENT'
1327: ,p_data => pay_prl_xml_utils.gXMLTable
1328: ,p_count => l_count
1329: ,p_xml_data => g_xml_data);
1330:

Line 1327: ,p_data => pay_prl_xml_utils.gXMLTable

1323:
1324: END LOOP ;
1325:
1326: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRAND_TOTAL_SEGMENT'
1327: ,p_data => pay_prl_xml_utils.gXMLTable
1328: ,p_count => l_count
1329: ,p_xml_data => g_xml_data);
1330:
1331: pay_prl_xml_utils.gXMLTable.delete;

Line 1331: pay_prl_xml_utils.gXMLTable.delete;

1327: ,p_data => pay_prl_xml_utils.gXMLTable
1328: ,p_count => l_count
1329: ,p_xml_data => g_xml_data);
1330:
1331: pay_prl_xml_utils.gXMLTable.delete;
1332:
1333: l_tag := '';
1334: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1335:

Line 1347: pay_prl_xml_utils.gXMLTable.delete;

1343: * This code is for populating the XML with the Costing Summary *
1344: * Report for Report Totals. *
1345: ********************************************************************/
1346:
1347: pay_prl_xml_utils.gXMLTable.delete;
1348: l_rec_count := 0;
1349:
1350: l_tag := '';
1351: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1365: pay_prl_xml_utils.getTag(

1361: IF c_get_report_totals%NOTFOUND THEN
1362: hr_utility.set_location(gv_package_name || '.costing_summary', 150);
1363: IF (l_nodata_flag = TRUE) THEN
1364: lv_tagged_parameters := lv_tagged_parameters||
1365: pay_prl_xml_utils.getTag(
1366: 'C_G_REPORT_TOTAL_NODATA',
1367: '1');
1368: l_tag := '';
1369: l_tag := l_tag||

Line 1370: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||

1366: 'C_G_REPORT_TOTAL_NODATA',
1367: '1');
1368: l_tag := '';
1369: l_tag := l_tag||
1370: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1371: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1372: pay_prl_xml_utils.getTag('UOM',NULL)||
1373: '';
1374:

Line 1371: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||

1367: '1');
1368: l_tag := '';
1369: l_tag := l_tag||
1370: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1371: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1372: pay_prl_xml_utils.getTag('UOM',NULL)||
1373: '';
1374:
1375: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1372: pay_prl_xml_utils.getTag('UOM',NULL)||

1368: l_tag := '';
1369: l_tag := l_tag||
1370: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1371: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1372: pay_prl_xml_utils.getTag('UOM',NULL)||
1373: '';
1374:
1375: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1376: END IF;

Line 1384: pay_prl_xml_utils.getTag(

1380: l_nodata_flag := FALSE;
1381:
1382: IF(l_rec_count = 0) THEN
1383: lv_tagged_parameters := lv_tagged_parameters||
1384: pay_prl_xml_utils.getTag(
1385: 'C_G_REPORT_TOTAL_NODATA',
1386: '0');
1387: END IF;
1388: l_rec_count := l_rec_count + 1;

Line 1391: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';

1387: END IF;
1388: l_rec_count := l_rec_count + 1;
1389:
1390: l_count := 1;
1391: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1392: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1393: l_count := l_count + 1;
1394:
1395: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';

Line 1392: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;

1388: l_rec_count := l_rec_count + 1;
1389:
1390: l_count := 1;
1391: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1392: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1393: l_count := l_count + 1;
1394:
1395: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1396: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;

Line 1395: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';

1391: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1392: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1393: l_count := l_count + 1;
1394:
1395: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1396: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1397: l_count := l_count + 1;
1398:
1399: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';

Line 1396: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;

1392: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1393: l_count := l_count + 1;
1394:
1395: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1396: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1397: l_count := l_count + 1;
1398:
1399: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1400: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;

Line 1399: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';

1395: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1396: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1397: l_count := l_count + 1;
1398:
1399: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1400: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1401:
1402: pay_prl_xml_utils.multiColumnar(
1403: 'G_REPORT_TOTAL',

Line 1400: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;

1396: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1397: l_count := l_count + 1;
1398:
1399: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1400: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1401:
1402: pay_prl_xml_utils.multiColumnar(
1403: 'G_REPORT_TOTAL',
1404: pay_prl_xml_utils.gXMLTable,

Line 1402: pay_prl_xml_utils.multiColumnar(

1398:
1399: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1400: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1401:
1402: pay_prl_xml_utils.multiColumnar(
1403: 'G_REPORT_TOTAL',
1404: pay_prl_xml_utils.gXMLTable,
1405: l_count,
1406: g_xml_data);

Line 1404: pay_prl_xml_utils.gXMLTable,

1400: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1401:
1402: pay_prl_xml_utils.multiColumnar(
1403: 'G_REPORT_TOTAL',
1404: pay_prl_xml_utils.gXMLTable,
1405: l_count,
1406: g_xml_data);
1407: pay_prl_xml_utils.gXMLTable.delete;
1408:

Line 1407: pay_prl_xml_utils.gXMLTable.delete;

1403: 'G_REPORT_TOTAL',
1404: pay_prl_xml_utils.gXMLTable,
1405: l_count,
1406: g_xml_data);
1407: pay_prl_xml_utils.gXMLTable.delete;
1408:
1409: END LOOP;
1410: CLOSE c_get_report_totals;
1411: