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 651: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);

647: --
648: fnd_file.put_line(fnd_file.log,'Creating the XML...');
649:
650: --Creating a CLOB and opening the CLOB.
651: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);
652: DBMS_LOB.OPEN(g_xml_data,dbms_lob.lob_readwrite);
653: --
654: l_tag :='';
655: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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

648: fnd_file.put_line(fnd_file.log,'Creating the XML...');
649:
650: --Creating a CLOB and opening the CLOB.
651: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);
652: DBMS_LOB.OPEN(g_xml_data,dbms_lob.lob_readwrite);
653: --
654: l_tag :='';
655: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
656: --

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

651: DBMS_LOB.CREATETEMPORARY(g_xml_data,FALSE,DBMS_LOB.CALL);
652: DBMS_LOB.OPEN(g_xml_data,dbms_lob.lob_readwrite);
653: --
654: l_tag :='';
655: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
656: --
657: l_tag := '';
658: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
659: fnd_file.put_line(fnd_file.log,'Started...');

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

654: l_tag :='';
655: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
656: --
657: l_tag := '';
658: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
659: fnd_file.put_line(fnd_file.log,'Started...');
660: --
661: --Fill the Global PL/SQL table with the CostAllocation Keyflex's
662: --enabled segments and their corresponding values.

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

730: * Costing details of payrolls. *
731: ***********************************************************************/
732: --
733: l_tag := '';
734: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
735: --
736: OPEN c_get_session_id;
737: FETCH c_get_session_id INTO lv_session_id;
738: CLOSE c_get_session_id;

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

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);
945: END IF;
946: EXIT;
947: END IF;
948: --

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

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

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

1108:
1109: l_tag := '';
1110:
1111: --Appending the XML data into the Global XML data variable.
1112: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1113:
1114: END LOOP;
1115: CLOSE c_asg_costing_details;
1116:

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

1114: END LOOP;
1115: CLOSE c_asg_costing_details;
1116:
1117: l_tag := '';
1118: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1119:
1120: /********************************************************************
1121: * This code is for populating the XML with the Costing Summary *
1122: * Report for GRE/Payroll Depends on the parameter. *

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

1127: l_nodata_flag := TRUE;
1128: l_rec_count := 0;
1129:
1130: l_tag := '';
1131: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1132:
1133:
1134: --Opening the Cursor for the data of the Second table
1135: --i.e., Costing Summary Details Table

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

1204: END LOOP;
1205:
1206: l_tag :=l_tag ||'';
1207:
1208: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1209: END IF;
1210:
1211: EXIT;
1212: END IF;

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

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

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

1315:
1316: l_tag := '';
1317:
1318: --Appending the XML data into the Global XML data variable.
1319: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1320:
1321: END LOOP;
1322: CLOSE c_costing_summary_rpt_details;
1323:

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

1321: END LOOP;
1322: CLOSE c_costing_summary_rpt_details;
1323:
1324: l_tag := '';
1325: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1326:
1327: /********************************************************************
1328: ** This code is for populating the XML with the Costing Summary **
1329: ** Report for GRE/Payroll totals Depends on the parameter. **

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

1333:
1334: l_nodata_flag := TRUE;
1335: l_rec_count := 0;
1336: l_tag := '';
1337: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1338:
1339: --Opening the Cursor for the data of the Third table
1340: --i.e., GRE/Payroll Totals Table
1341: OPEN c_get_gre_or_payroll_totals (lv_session_id

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

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;
1373: END IF;
1374:

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

1410: END LOOP;
1411: CLOSE c_get_gre_or_payroll_totals;
1412:
1413: l_tag := '';
1414: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1415:
1416: /********************************************************************
1417: * This code is for populating the XML with the Costing Summary *
1418: * Report for Grand Totals. *

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

1422:
1423: l_nodata_flag := TRUE;
1424: l_rec_count := 0;
1425: l_tag := '';
1426: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1427:
1428: --Opening the Cursor for the data of the Fourth table
1429: --i.e., Costing Summary Report - Grand Totals Table
1430: OPEN c_costing_grand_totals (lv_session_id

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

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);
1497: END IF;
1498: EXIT;
1499: END IF;
1500:

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

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

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:
1600: END LOOP;
1601: CLOSE c_costing_grand_totals;
1602:

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

1600: END LOOP;
1601: CLOSE c_costing_grand_totals;
1602:
1603: l_tag := '';
1604: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1605:
1606: /********************************************************************
1607: * This code is for populating the XML with the Costing Summary *
1608: * Report for Report Totals. *

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

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);
1616:
1617: hr_utility.trace('Session id : '||lv_session_id);
1618: OPEN c_get_report_totals(lv_session_id,p_business_group_id,'CSR');
1619: LOOP

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

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;
1641: EXIT;
1642: END IF;
1643:

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

1673: END LOOP;
1674: CLOSE c_get_report_totals;
1675:
1676: l_tag := '';
1677: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1678:
1679: DBMS_LOB.WRITEAPPEND(g_xml_data, length(lv_tagged_parameters),
1680: lv_tagged_parameters);
1681:

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

1675:
1676: l_tag := '';
1677: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1678:
1679: DBMS_LOB.WRITEAPPEND(g_xml_data, length(lv_tagged_parameters),
1680: lv_tagged_parameters);
1681:
1682: l_tag := '';
1683: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);

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

1679: DBMS_LOB.WRITEAPPEND(g_xml_data, length(lv_tagged_parameters),
1680: lv_tagged_parameters);
1681:
1682: l_tag := '';
1683: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1684:
1685: DELETE FROM pay_us_rpt_totals where attribute31='CSR';
1686:
1687: p_xml := g_xml_data;