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,calendar_aware=>fnd_date.calendar_aware_alt)||
119: '('||p_costing||')'; -- change as per bug 11830805
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,calendar_aware=>fnd_date.calendar_aware_alt))|| -- change as per bug 11830805

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,calendar_aware=>fnd_date.calendar_aware_alt))|| -- change as per bug 11830805
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,calendar_aware=>fnd_date.calendar_aware_alt))|| -- change as per bug 11830805
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,calendar_aware=>fnd_date.calendar_aware_alt))|| -- change as per bug 11830805
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,calendar_aware=>fnd_date.calendar_aware_alt))|| -- change as per bug 11830805
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,calendar_aware=>fnd_date.calendar_aware_alt))|| -- change as per bug 11830805
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,calendar_aware=>fnd_date.calendar_aware_alt))|| -- change as per bug 11830805
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 645: --Clearing the PL/SQL table of package pay_prl_xml_utils

641: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
642: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
643:
644: lv_costing_process_flag := 'N';
645: --Clearing the PL/SQL table of package pay_prl_xml_utils
646: pay_prl_xml_utils.gXMLTable.DELETE;
647: --
648: fnd_file.put_line(fnd_file.log,'Creating the XML...');
649:

Line 646: pay_prl_xml_utils.gXMLTable.DELETE;

642: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
643:
644: lv_costing_process_flag := 'N';
645: --Clearing the PL/SQL table of package pay_prl_xml_utils
646: pay_prl_xml_utils.gXMLTable.DELETE;
647: --
648: fnd_file.put_line(fnd_file.log,'Creating the XML...');
649:
650: --Creating a CLOB and opening the CLOB.

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

718: lv_csr_heading :='Costing Summary Report - GRE Totals';
719: lv_total_heading := 'GRE Totals';
720: END IF;
721:
722: lv_tableHeadings := pay_prl_xml_utils.getTag('CSR_GRE_OR_PAYROLL_HEADING',
723: lv_csr_heading)||
724: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL_TOTAL_HEADING',
725: lv_total_heading);
726: lv_tagged_parameters := lv_tagged_parameters || lv_tableHeadings;

Line 724: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL_TOTAL_HEADING',

720: END IF;
721:
722: lv_tableHeadings := pay_prl_xml_utils.getTag('CSR_GRE_OR_PAYROLL_HEADING',
723: lv_csr_heading)||
724: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL_TOTAL_HEADING',
725: lv_total_heading);
726: lv_tagged_parameters := lv_tagged_parameters || lv_tableHeadings;
727:
728: /***********************************************************************

Line 919: pay_prl_xml_utils.getTag(

915: --If no data is returned from the cursor then need to populate the
916: --XML data with no values.
917: IF(l_nodata_flag = TRUE) THEN
918: lv_tagged_parameters := lv_tagged_parameters||
919: pay_prl_xml_utils.getTag(
920: 'C_G_ASG_COSTING_DETAILS_NODATA',
921: '1');
922: l_tag := '';
923:

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

921: '1');
922: l_tag := '';
923:
924: l_tag := l_tag||
925: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
926: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
927: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
928: NULL)||
929: pay_prl_xml_utils.getTag('UOM',NULL)||

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

922: l_tag := '';
923:
924: l_tag := l_tag||
925: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
926: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
927: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
928: NULL)||
929: pay_prl_xml_utils.getTag('UOM',NULL)||
930: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||

Line 927: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',

923:
924: l_tag := l_tag||
925: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
926: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
927: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
928: NULL)||
929: pay_prl_xml_utils.getTag('UOM',NULL)||
930: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
931: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||

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

925: pay_prl_xml_utils.getTag('PAYROLL_NAME',NULL)||
926: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
927: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
928: NULL)||
929: pay_prl_xml_utils.getTag('UOM',NULL)||
930: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
931: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
932: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
933:

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

926: pay_prl_xml_utils.getTag('GRE_NAME', NULL)||
927: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
928: NULL)||
929: pay_prl_xml_utils.getTag('UOM',NULL)||
930: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
931: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
932: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
933:
934: --Need to provide the Heading of the columns eventhough no data

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

927: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
928: NULL)||
929: pay_prl_xml_utils.getTag('UOM',NULL)||
930: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
931: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
932: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
933:
934: --Need to provide the Heading of the columns eventhough no data
935: --found.So here it's going to fill the Column heading data.

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

928: NULL)||
929: pay_prl_xml_utils.getTag('UOM',NULL)||
930: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
931: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
932: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', NULL);
933:
934: --Need to provide the Heading of the columns eventhough no data
935: --found.So here it's going to fill the Column heading data.
936: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP

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

934: --Need to provide the Heading of the columns eventhough no data
935: --found.So here it's going to fill the Column heading data.
936: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
937: l_tag:= l_tag||''||
938: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
939: gtr_costing_segment(i).segment_label))||
940: pay_prl_xml_utils.getTag('VALUE',NULL)||
941: '';
942: END LOOP;

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

936: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
937: l_tag:= l_tag||''||
938: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
939: gtr_costing_segment(i).segment_label))||
940: pay_prl_xml_utils.getTag('VALUE',NULL)||
941: '';
942: END LOOP;
943: l_tag :=l_tag||'';
944: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 954: pay_prl_xml_utils.getTag(

950: -- in the XML output.
951: l_nodata_flag := FALSE;
952: IF(l_rec_count = 0) THEN
953: lv_tagged_parameters := lv_tagged_parameters||
954: pay_prl_xml_utils.getTag(
955: 'C_G_ASG_COSTING_DETAILS_NODATA',
956: '0');
957: END IF;
958: l_rec_count := l_rec_count + 1;

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

1014: --data variable.
1015: l_tag := '';
1016:
1017: l_tag := l_tag||
1018: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
1019: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
1020: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
1021: lv_input_value_name)||
1022: pay_prl_xml_utils.getTag('UOM',lv_uom)||

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

1015: l_tag := '';
1016:
1017: l_tag := l_tag||
1018: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
1019: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
1020: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
1021: lv_input_value_name)||
1022: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1023: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||

Line 1020: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',

1016:
1017: l_tag := l_tag||
1018: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
1019: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
1020: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
1021: lv_input_value_name)||
1022: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1023: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1024: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||

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

1018: pay_prl_xml_utils.getTag('PAYROLL_NAME',lv_payroll_name)||
1019: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
1020: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
1021: lv_input_value_name)||
1022: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1023: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1024: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
1025: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
1026:

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

1019: pay_prl_xml_utils.getTag('GRE_NAME', lv_gre_name)||
1020: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
1021: lv_input_value_name)||
1022: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1023: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1024: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
1025: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
1026:
1027: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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

1020: pay_prl_xml_utils.getTag('INPUT_VALUE_NAME',
1021: lv_input_value_name)||
1022: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1023: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1024: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
1025: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
1026:
1027: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1028:

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

1021: lv_input_value_name)||
1022: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1023: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1024: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount)||
1025: pay_prl_xml_utils.getTag('ACCRUAL_TYPE', lv_accrual_type);
1026:
1027: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1028:
1029: l_count := 1;

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

1091: elsIF gtr_costing_segment(i).column_name = 'SEGMENT30' THEN
1092: lv_segment_value := lv_segment30;
1093: END IF;
1094:
1095: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1096: gtr_costing_segment(i).segment_label);
1097: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1098:
1099: l_count := l_count + 1;

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

1093: END IF;
1094:
1095: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1096: gtr_costing_segment(i).segment_label);
1097: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1098:
1099: l_count := l_count + 1;
1100:
1101: END LOOP ;

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

1099: l_count := l_count + 1;
1100:
1101: END LOOP ;
1102:
1103: pay_prl_xml_utils.twoColumnar(p_type => 'G_ASG_COSTING_DETAILS_SEGMENT'
1104: ,p_data => pay_prl_xml_utils.gXMLTable
1105: ,p_count => l_count
1106: ,p_xml_data => g_xml_data);
1107: pay_prl_xml_utils.gXMLTable.delete;

Line 1104: ,p_data => pay_prl_xml_utils.gXMLTable

1100:
1101: END LOOP ;
1102:
1103: pay_prl_xml_utils.twoColumnar(p_type => 'G_ASG_COSTING_DETAILS_SEGMENT'
1104: ,p_data => pay_prl_xml_utils.gXMLTable
1105: ,p_count => l_count
1106: ,p_xml_data => g_xml_data);
1107: pay_prl_xml_utils.gXMLTable.delete;
1108:

Line 1107: pay_prl_xml_utils.gXMLTable.delete;

1103: pay_prl_xml_utils.twoColumnar(p_type => 'G_ASG_COSTING_DETAILS_SEGMENT'
1104: ,p_data => pay_prl_xml_utils.gXMLTable
1105: ,p_count => l_count
1106: ,p_xml_data => g_xml_data);
1107: pay_prl_xml_utils.gXMLTable.delete;
1108:
1109: l_tag := '';
1110:
1111: --Appending the XML data into the Global XML data variable.

Line 1125: pay_prl_xml_utils.gXMLTable.delete;

1121: * This code is for populating the XML with the Costing Summary *
1122: * Report for GRE/Payroll Depends on the parameter. *
1123: ********************************************************************/
1124:
1125: pay_prl_xml_utils.gXMLTable.delete;
1126:
1127: l_nodata_flag := TRUE;
1128: l_rec_count := 0;
1129:

Line 1186: pay_prl_xml_utils.getTag(

1182: --XML data with no values.
1183: IF(l_nodata_flag = TRUE) THEN
1184:
1185: lv_tagged_parameters := lv_tagged_parameters||
1186: pay_prl_xml_utils.getTag(
1187: 'C_G_CSR_GRE_OR_PRL_TOTAL_NODATA',
1188: '1');
1189: l_tag := '';
1190: l_tag := l_tag||

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

1187: 'C_G_CSR_GRE_OR_PRL_TOTAL_NODATA',
1188: '1');
1189: l_tag := '';
1190: l_tag := l_tag||
1191: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1192: pay_prl_xml_utils.getTag('UOM',NULL)||
1193: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1194: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1195:

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

1188: '1');
1189: l_tag := '';
1190: l_tag := l_tag||
1191: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1192: pay_prl_xml_utils.getTag('UOM',NULL)||
1193: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1194: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1195:
1196: --Need to provide the Heading of the columns eventhough no data

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

1189: l_tag := '';
1190: l_tag := l_tag||
1191: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1192: pay_prl_xml_utils.getTag('UOM',NULL)||
1193: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1194: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1195:
1196: --Need to provide the Heading of the columns eventhough no data
1197: --found.So here it's going to fill the Column heading data.

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

1190: l_tag := l_tag||
1191: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1192: pay_prl_xml_utils.getTag('UOM',NULL)||
1193: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1194: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1195:
1196: --Need to provide the Heading of the columns eventhough no data
1197: --found.So here it's going to fill the Column heading data.
1198: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP

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

1196: --Need to provide the Heading of the columns eventhough no data
1197: --found.So here it's going to fill the Column heading data.
1198: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1199: l_tag := l_tag ||''||
1200: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
1201: gtr_costing_segment(i).segment_label))||
1202: pay_prl_xml_utils.getTag('VALUE',NULL)||
1203: '';
1204: END LOOP;

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

1198: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1199: l_tag := l_tag ||''||
1200: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
1201: gtr_costing_segment(i).segment_label))||
1202: pay_prl_xml_utils.getTag('VALUE',NULL)||
1203: '';
1204: END LOOP;
1205:
1206: l_tag :=l_tag ||'';

Line 1219: pay_prl_xml_utils.getTag(

1215: -- in the XML output.
1216: l_nodata_flag := FALSE;
1217: IF(l_rec_count = 0)THEN
1218: lv_tagged_parameters := lv_tagged_parameters||
1219: pay_prl_xml_utils.getTag(
1220: 'C_G_CSR_GRE_OR_PRL_TOTAL_NODATA',
1221: '0');
1222: END IF;
1223: l_rec_count := l_rec_count + 1;

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

1226: --data variable.
1227: l_tag := '';
1228:
1229: l_tag := l_tag||
1230: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1231: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1232: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1233: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1234:

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

1227: l_tag := '';
1228:
1229: l_tag := l_tag||
1230: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1231: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1232: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1233: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1234:
1235: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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

1228:
1229: l_tag := l_tag||
1230: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1231: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1232: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1233: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1234:
1235: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1236:

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

1229: l_tag := l_tag||
1230: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',lv_gre_or_payroll)||
1231: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1232: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1233: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1234:
1235: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1236:
1237: l_count := 1;

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

1298: elsIF gtr_costing_segment(i).column_name = 'SEGMENT30' THEN
1299: lv_segment_value := lv_segment30;
1300: END IF;
1301:
1302: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1303: gtr_costing_segment(i).segment_label);
1304: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1305:
1306: l_count := l_count + 1;

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

1300: END IF;
1301:
1302: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1303: gtr_costing_segment(i).segment_label);
1304: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1305:
1306: l_count := l_count + 1;
1307:
1308: END LOOP ;

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

1306: l_count := l_count + 1;
1307:
1308: END LOOP ;
1309:
1310: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRE_OR_PRL_TOTAL_SEGMENT'
1311: ,p_data => pay_prl_xml_utils.gXMLTable
1312: ,p_count => l_count
1313: ,p_xml_data => g_xml_data);
1314: pay_prl_xml_utils.gXMLTable.delete;

Line 1311: ,p_data => pay_prl_xml_utils.gXMLTable

1307:
1308: END LOOP ;
1309:
1310: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRE_OR_PRL_TOTAL_SEGMENT'
1311: ,p_data => pay_prl_xml_utils.gXMLTable
1312: ,p_count => l_count
1313: ,p_xml_data => g_xml_data);
1314: pay_prl_xml_utils.gXMLTable.delete;
1315:

Line 1314: pay_prl_xml_utils.gXMLTable.delete;

1310: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRE_OR_PRL_TOTAL_SEGMENT'
1311: ,p_data => pay_prl_xml_utils.gXMLTable
1312: ,p_count => l_count
1313: ,p_xml_data => g_xml_data);
1314: pay_prl_xml_utils.gXMLTable.delete;
1315:
1316: l_tag := '';
1317:
1318: --Appending the XML data into the Global XML data variable.

Line 1332: pay_prl_xml_utils.gXMLTable.delete;

1328: ** This code is for populating the XML with the Costing Summary **
1329: ** Report for GRE/Payroll totals Depends on the parameter. **
1330: ********************************************************************/
1331:
1332: pay_prl_xml_utils.gXMLTable.delete;
1333:
1334: l_nodata_flag := TRUE;
1335: l_rec_count := 0;
1336: l_tag := '';

Line 1360: pay_prl_xml_utils.getTag(

1356: --If no data is returned from the cursor then need to populate the
1357: --XML data with no values.
1358: IF(l_nodata_flag=TRUE) THEN
1359: lv_tagged_parameters := lv_tagged_parameters||
1360: pay_prl_xml_utils.getTag(
1361: 'C_G_GRE_OR_PRL_TOTAL_NODATA',
1362: '1');
1363: l_tag := '';
1364: l_tag := l_tag||

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

1361: 'C_G_GRE_OR_PRL_TOTAL_NODATA',
1362: '1');
1363: l_tag := '';
1364: l_tag := l_tag||
1365: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1366: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1367: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1368: pay_prl_xml_utils.getTag('UOM',NULL)||
1369: '';

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

1362: '1');
1363: l_tag := '';
1364: l_tag := l_tag||
1365: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1366: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1367: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1368: pay_prl_xml_utils.getTag('UOM',NULL)||
1369: '';
1370: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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

1363: l_tag := '';
1364: l_tag := l_tag||
1365: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1366: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1367: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1368: pay_prl_xml_utils.getTag('UOM',NULL)||
1369: '';
1370: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1371: END IF;

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

1364: l_tag := l_tag||
1365: pay_prl_xml_utils.getTag('GRE_OR_PAYROLL',NULL)||
1366: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1367: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1368: pay_prl_xml_utils.getTag('UOM',NULL)||
1369: '';
1370: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1371: END IF;
1372: EXIT;

Line 1380: pay_prl_xml_utils.getTag(

1376: -- in the XML output.
1377: l_nodata_flag := FALSE;
1378: IF(l_rec_count = 0)THEN
1379: lv_tagged_parameters := lv_tagged_parameters||
1380: pay_prl_xml_utils.getTag(
1381: 'C_G_GRE_OR_PRL_TOTAL_NODATA',
1382: '0');
1383: END IF;
1384: l_rec_count := l_rec_count + 1;

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

1382: '0');
1383: END IF;
1384: l_rec_count := l_rec_count + 1;
1385: l_count := 1;
1386: pay_prl_xml_utils.gXMLTable(l_count).Name := 'GRE_OR_PAYROLL';
1387: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1388: l_count := l_count + 1;
1389:
1390: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';

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

1383: END IF;
1384: l_rec_count := l_rec_count + 1;
1385: l_count := 1;
1386: pay_prl_xml_utils.gXMLTable(l_count).Name := 'GRE_OR_PAYROLL';
1387: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1388: l_count := l_count + 1;
1389:
1390: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1391: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;

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

1386: pay_prl_xml_utils.gXMLTable(l_count).Name := 'GRE_OR_PAYROLL';
1387: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1388: l_count := l_count + 1;
1389:
1390: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1391: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;
1392: l_count := l_count + 1;
1393:
1394: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';

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

1387: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_gre_or_payroll;
1388: l_count := l_count + 1;
1389:
1390: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1391: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_credit_amount;
1392: l_count := l_count + 1;
1393:
1394: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1395: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;

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

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

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

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

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

1394: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1395: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;
1396: l_count := l_count + 1;
1397:
1398: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1399: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1400:
1401: --Appending the XML data into the Global XML data variable by
1402: --invoking the multiColumnar in the pay_prl_xml_utils package.

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

1395: pay_prl_xml_utils.gXMLTable(l_count).Value := ln_debit_amount;
1396: l_count := l_count + 1;
1397:
1398: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1399: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1400:
1401: --Appending the XML data into the Global XML data variable by
1402: --invoking the multiColumnar in the pay_prl_xml_utils package.
1403: pay_prl_xml_utils.multiColumnar(

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

1398: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1399: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1400:
1401: --Appending the XML data into the Global XML data variable by
1402: --invoking the multiColumnar in the pay_prl_xml_utils package.
1403: pay_prl_xml_utils.multiColumnar(
1404: 'G_GRE_OR_PRL_TOTAL',
1405: pay_prl_xml_utils.gXMLTable,
1406: l_count,

Line 1403: pay_prl_xml_utils.multiColumnar(

1399: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1400:
1401: --Appending the XML data into the Global XML data variable by
1402: --invoking the multiColumnar in the pay_prl_xml_utils package.
1403: pay_prl_xml_utils.multiColumnar(
1404: 'G_GRE_OR_PRL_TOTAL',
1405: pay_prl_xml_utils.gXMLTable,
1406: l_count,
1407: g_xml_data);

Line 1405: pay_prl_xml_utils.gXMLTable,

1401: --Appending the XML data into the Global XML data variable by
1402: --invoking the multiColumnar in the pay_prl_xml_utils package.
1403: pay_prl_xml_utils.multiColumnar(
1404: 'G_GRE_OR_PRL_TOTAL',
1405: pay_prl_xml_utils.gXMLTable,
1406: l_count,
1407: g_xml_data);
1408: pay_prl_xml_utils.gXMLTable.delete;
1409:

Line 1408: pay_prl_xml_utils.gXMLTable.delete;

1404: 'G_GRE_OR_PRL_TOTAL',
1405: pay_prl_xml_utils.gXMLTable,
1406: l_count,
1407: g_xml_data);
1408: pay_prl_xml_utils.gXMLTable.delete;
1409:
1410: END LOOP;
1411: CLOSE c_get_gre_or_payroll_totals;
1412:

Line 1421: pay_prl_xml_utils.gXMLTable.delete;

1417: * This code is for populating the XML with the Costing Summary *
1418: * Report for Grand Totals. *
1419: ********************************************************************/
1420:
1421: pay_prl_xml_utils.gXMLTable.delete;
1422:
1423: l_nodata_flag := TRUE;
1424: l_rec_count := 0;
1425: l_tag := '';

Line 1478: pay_prl_xml_utils.getTag(

1474: '.costing_summary', 120);
1475:
1476: IF (l_nodata_flag = TRUE)THEN
1477: lv_tagged_parameters := lv_tagged_parameters||
1478: pay_prl_xml_utils.getTag(
1479: 'C_G_CSR_GRAND_TOTAL_NODATA',
1480: '1');
1481: l_tag := '';
1482:

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

1480: '1');
1481: l_tag := '';
1482:
1483: l_tag := l_tag||
1484: pay_prl_xml_utils.getTag('UOM',NULL)||
1485: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1486: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1487:
1488: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP

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

1481: l_tag := '';
1482:
1483: l_tag := l_tag||
1484: pay_prl_xml_utils.getTag('UOM',NULL)||
1485: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1486: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1487:
1488: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1489: l_tag := l_tag ||''||

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

1482:
1483: l_tag := l_tag||
1484: pay_prl_xml_utils.getTag('UOM',NULL)||
1485: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1486: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1487:
1488: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1489: l_tag := l_tag ||''||
1490: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(

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

1486: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL);
1487:
1488: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1489: l_tag := l_tag ||''||
1490: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
1491: gtr_costing_segment(i).segment_label))||
1492: pay_prl_xml_utils.getTag('VALUE',NULL)||
1493: '';
1494: END LOOP;

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

1488: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1489: l_tag := l_tag ||''||
1490: pay_prl_xml_utils.getTag('SEGMENT',INITCAP(
1491: gtr_costing_segment(i).segment_label))||
1492: pay_prl_xml_utils.getTag('VALUE',NULL)||
1493: '';
1494: END LOOP;
1495: l_tag := l_tag ||'';
1496: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1504: pay_prl_xml_utils.getTag(

1500:
1501: l_nodata_flag := FALSE;
1502: IF(l_rec_count = 0) THEN
1503: lv_tagged_parameters := lv_tagged_parameters||
1504: pay_prl_xml_utils.getTag(
1505: 'C_G_CSR_GRAND_TOTAL_NODATA',
1506: '0');
1507: END IF;
1508: l_rec_count := l_rec_count + 1;

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

1508: l_rec_count := l_rec_count + 1;
1509: l_tag := '';
1510:
1511: l_tag := l_tag||
1512: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1513: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1514: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1515:
1516: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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

1509: l_tag := '';
1510:
1511: l_tag := l_tag||
1512: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1513: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1514: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1515:
1516: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1517:

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

1510:
1511: l_tag := l_tag||
1512: pay_prl_xml_utils.getTag('UOM',lv_uom)||
1513: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',ln_credit_amount)||
1514: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',ln_debit_amount);
1515:
1516: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1517:
1518: l_count := 1;

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

1578: elsIF gtr_costing_segment(i).column_name = 'SEGMENT30' THEN
1579: lv_segment_value := lv_segment30;
1580: END IF;
1581:
1582: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1583: gtr_costing_segment(i).segment_label);
1584: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1585:
1586: l_count := l_count + 1;

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

1580: END IF;
1581:
1582: pay_prl_xml_utils.gXMLTable(l_count).Name := INITCAP(
1583: gtr_costing_segment(i).segment_label);
1584: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_segment_value;
1585:
1586: l_count := l_count + 1;
1587:
1588: END LOOP ;

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

1586: l_count := l_count + 1;
1587:
1588: END LOOP ;
1589:
1590: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRAND_TOTAL_SEGMENT'
1591: ,p_data => pay_prl_xml_utils.gXMLTable
1592: ,p_count => l_count
1593: ,p_xml_data => g_xml_data);
1594:

Line 1591: ,p_data => pay_prl_xml_utils.gXMLTable

1587:
1588: END LOOP ;
1589:
1590: pay_prl_xml_utils.twoColumnar(p_type => 'G_CSR_GRAND_TOTAL_SEGMENT'
1591: ,p_data => pay_prl_xml_utils.gXMLTable
1592: ,p_count => l_count
1593: ,p_xml_data => g_xml_data);
1594:
1595: pay_prl_xml_utils.gXMLTable.delete;

Line 1595: pay_prl_xml_utils.gXMLTable.delete;

1591: ,p_data => pay_prl_xml_utils.gXMLTable
1592: ,p_count => l_count
1593: ,p_xml_data => g_xml_data);
1594:
1595: pay_prl_xml_utils.gXMLTable.delete;
1596:
1597: l_tag := '';
1598: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1599:

Line 1611: pay_prl_xml_utils.gXMLTable.delete;

1607: * This code is for populating the XML with the Costing Summary *
1608: * Report for Report Totals. *
1609: ********************************************************************/
1610:
1611: pay_prl_xml_utils.gXMLTable.delete;
1612: l_rec_count := 0;
1613:
1614: l_tag := '';
1615: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1629: pay_prl_xml_utils.getTag(

1625: IF c_get_report_totals%NOTFOUND THEN
1626: hr_utility.set_location(gv_package_name || '.costing_summary', 150);
1627: IF (l_nodata_flag = TRUE) THEN
1628: lv_tagged_parameters := lv_tagged_parameters||
1629: pay_prl_xml_utils.getTag(
1630: 'C_G_REPORT_TOTAL_NODATA',
1631: '1');
1632: l_tag := '';
1633: l_tag := l_tag||

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

1630: 'C_G_REPORT_TOTAL_NODATA',
1631: '1');
1632: l_tag := '';
1633: l_tag := l_tag||
1634: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1635: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1636: pay_prl_xml_utils.getTag('UOM',NULL)||
1637: '';
1638:

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

1631: '1');
1632: l_tag := '';
1633: l_tag := l_tag||
1634: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1635: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1636: pay_prl_xml_utils.getTag('UOM',NULL)||
1637: '';
1638:
1639: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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

1632: l_tag := '';
1633: l_tag := l_tag||
1634: pay_prl_xml_utils.getTag('CREDIT_AMOUNT',NULL)||
1635: pay_prl_xml_utils.getTag('DEBIT_AMOUNT',NULL)||
1636: pay_prl_xml_utils.getTag('UOM',NULL)||
1637: '';
1638:
1639: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1640: END IF;

Line 1648: pay_prl_xml_utils.getTag(

1644: l_nodata_flag := FALSE;
1645:
1646: IF(l_rec_count = 0) THEN
1647: lv_tagged_parameters := lv_tagged_parameters||
1648: pay_prl_xml_utils.getTag(
1649: 'C_G_REPORT_TOTAL_NODATA',
1650: '0');
1651: END IF;
1652: l_rec_count := l_rec_count + 1;

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

1651: END IF;
1652: l_rec_count := l_rec_count + 1;
1653:
1654: l_count := 1;
1655: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1656: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1657: l_count := l_count + 1;
1658:
1659: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';

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

1652: l_rec_count := l_rec_count + 1;
1653:
1654: l_count := 1;
1655: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1656: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1657: l_count := l_count + 1;
1658:
1659: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1660: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;

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

1655: pay_prl_xml_utils.gXMLTable(l_count).Name := 'CREDIT_AMOUNT';
1656: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1657: l_count := l_count + 1;
1658:
1659: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1660: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1661: l_count := l_count + 1;
1662:
1663: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';

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

1656: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_credit_sum;
1657: l_count := l_count + 1;
1658:
1659: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1660: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1661: l_count := l_count + 1;
1662:
1663: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1664: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;

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

1659: pay_prl_xml_utils.gXMLTable(l_count).Name := 'DEBIT_AMOUNT';
1660: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1661: l_count := l_count + 1;
1662:
1663: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1664: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1665:
1666: pay_prl_xml_utils.multiColumnar(
1667: 'G_REPORT_TOTAL',

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

1660: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_debit_sum;
1661: l_count := l_count + 1;
1662:
1663: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1664: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1665:
1666: pay_prl_xml_utils.multiColumnar(
1667: 'G_REPORT_TOTAL',
1668: pay_prl_xml_utils.gXMLTable,

Line 1666: pay_prl_xml_utils.multiColumnar(

1662:
1663: pay_prl_xml_utils.gXMLTable(l_count).Name := 'UOM';
1664: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1665:
1666: pay_prl_xml_utils.multiColumnar(
1667: 'G_REPORT_TOTAL',
1668: pay_prl_xml_utils.gXMLTable,
1669: l_count,
1670: g_xml_data);

Line 1668: pay_prl_xml_utils.gXMLTable,

1664: pay_prl_xml_utils.gXMLTable(l_count).Value := lv_uom;
1665:
1666: pay_prl_xml_utils.multiColumnar(
1667: 'G_REPORT_TOTAL',
1668: pay_prl_xml_utils.gXMLTable,
1669: l_count,
1670: g_xml_data);
1671: pay_prl_xml_utils.gXMLTable.delete;
1672:

Line 1671: pay_prl_xml_utils.gXMLTable.delete;

1667: 'G_REPORT_TOTAL',
1668: pay_prl_xml_utils.gXMLTable,
1669: l_count,
1670: g_xml_data);
1671: pay_prl_xml_utils.gXMLTable.delete;
1672:
1673: END LOOP;
1674: CLOSE c_get_report_totals;
1675: