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 DBMS_LOB

Line 537: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);

533: --
534: fnd_file.put_line(fnd_file.log,'Creating the XML...');
535:
536: --Creating a CLOB and opening the CLOB.
537: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);
538: DBMS_LOB.OPEN(g_xml_data,dbms_lob.lob_readwrite);
539: --
540: l_tag :='';
541: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 538: DBMS_LOB.OPEN(g_xml_data,dbms_lob.lob_readwrite);

534: fnd_file.put_line(fnd_file.log,'Creating the XML...');
535:
536: --Creating a CLOB and opening the CLOB.
537: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);
538: DBMS_LOB.OPEN(g_xml_data,dbms_lob.lob_readwrite);
539: --
540: l_tag :='';
541: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
542: --

Line 541: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

537: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);
538: DBMS_LOB.OPEN(g_xml_data,dbms_lob.lob_readwrite);
539: --
540: l_tag :='';
541: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
542: --
543: l_tag := '';
544: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
545: fnd_file.put_line(fnd_file.log,'Started...');

Line 544: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

540: l_tag :='';
541: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
542: --
543: l_tag := '';
544: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
545: fnd_file.put_line(fnd_file.log,'Started...');
546: --
547: --Fill the Global PL/SQL table with the CostAllocation Keyflex's
548: --enabled segments and their corresponding values.

Line 620: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

616: * Costing details of payrolls. *
617: ***********************************************************************/
618: --
619: l_tag := '';
620: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
621: --
622: OPEN c_get_session_id;
623: FETCH c_get_session_id INTO lv_session_id;
624: CLOSE c_get_session_id;

Line 771: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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);
772: END IF;
773: EXIT;
774: END IF;
775: --

Line 843: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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;
846:
847: --Filling the Cost Allocation KFF Values into the XML data Variable.

Line 908: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

904:
905: l_tag := '';
906:
907: --Appending the XML data into the Global XML data variable.
908: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
909:
910: END LOOP;
911: CLOSE c_asg_costing_details;
912:

Line 914: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

910: END LOOP;
911: CLOSE c_asg_costing_details;
912:
913: l_tag := '';
914: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
915:
916: /********************************************************************
917: * This code is for populating the XML with the Costing Summary *
918: * Report for GRE/Payroll Depends on the parameter. *

Line 927: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

923: l_nodata_flag := TRUE;
924: l_rec_count := 0;
925:
926: l_tag := '';
927: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
928:
929:
930: --Opening the Cursor for the data of the Second table
931: --i.e., Costing Summary Details Table

Line 994: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

990: END LOOP;
991:
992: l_tag :=l_tag ||'';
993:
994: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
995: END IF;
996:
997: EXIT;
998: END IF;

Line 1021: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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;
1024: --Filling the Cost Allocation KFF Values into the XML data Variable.
1025: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP

Line 1085: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1081:
1082: l_tag := '';
1083:
1084: --Appending the XML data into the Global XML data variable.
1085: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1086:
1087: END LOOP;
1088: CLOSE c_costing_summary_rpt_details;
1089:

Line 1091: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1087: END LOOP;
1088: CLOSE c_costing_summary_rpt_details;
1089:
1090: l_tag := '';
1091: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1092:
1093: /********************************************************************
1094: ** This code is for populating the XML with the Costing Summary **
1095: ** Report for GRE/Payroll totals Depends on the parameter. **

Line 1103: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1099:
1100: l_nodata_flag := TRUE;
1101: l_rec_count := 0;
1102: l_tag := '';
1103: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1104:
1105: --Opening the Cursor for the data of the Third table
1106: --i.e., GRE/Payroll Totals Table
1107: OPEN c_get_gre_or_payroll_totals (lv_session_id

Line 1136: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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;
1139: END IF;
1140:

Line 1180: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1176: END LOOP;
1177: CLOSE c_get_gre_or_payroll_totals;
1178:
1179: l_tag := '';
1180: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1181:
1182: /********************************************************************
1183: * This code is for populating the XML with the Costing Summary *
1184: * Report for Grand Totals. *

Line 1192: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1188:
1189: l_nodata_flag := TRUE;
1190: l_rec_count := 0;
1191: l_tag := '';
1192: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1193:
1194: --Opening the Cursor for the data of the Fourth table
1195: --i.e., Costing Summary Report - Grand Totals Table
1196: OPEN c_costing_grand_totals (lv_session_id

Line 1252: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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);
1253: END IF;
1254: EXIT;
1255: END IF;
1256:

Line 1272: DBMS_LOB.WRITEAPPEND(g_xml_data, length(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;
1275: FOR i IN gtr_costing_segment.first .. gtr_costing_segment.last LOOP
1276: IF gtr_costing_segment(i).column_name = 'SEGMENT1' THEN

Line 1334: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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:
1336: END LOOP;
1337: CLOSE c_costing_grand_totals;
1338:

Line 1340: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1336: END LOOP;
1337: CLOSE c_costing_grand_totals;
1338:
1339: l_tag := '';
1340: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1341:
1342: /********************************************************************
1343: * This code is for populating the XML with the Costing Summary *
1344: * Report for Report Totals. *

Line 1351: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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);
1352:
1353: hr_utility.trace('Session id : '||lv_session_id);
1354: OPEN c_get_report_totals(lv_session_id,p_business_group_id,'CSR');
1355: LOOP

Line 1375: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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;
1377: EXIT;
1378: END IF;
1379:

Line 1413: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1409: END LOOP;
1410: CLOSE c_get_report_totals;
1411:
1412: l_tag := '';
1413: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1414:
1415: DBMS_LOB.WRITEAPPEND(g_xml_data, length(lv_tagged_parameters),
1416: lv_tagged_parameters);
1417:

Line 1415: DBMS_LOB.WRITEAPPEND(g_xml_data, length(lv_tagged_parameters),

1411:
1412: l_tag := '';
1413: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1414:
1415: DBMS_LOB.WRITEAPPEND(g_xml_data, length(lv_tagged_parameters),
1416: lv_tagged_parameters);
1417:
1418: l_tag := '';
1419: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

Line 1419: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

1415: DBMS_LOB.WRITEAPPEND(g_xml_data, length(lv_tagged_parameters),
1416: lv_tagged_parameters);
1417:
1418: l_tag := '';
1419: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1420:
1421: DELETE FROM pay_us_rpt_totals WHERE attribute1='CSR';
1422:
1423: p_xml := g_xml_data;