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.CSC_ROUTING_UTL dependencies on CSC_SERVICE_KEY_PVT

Line 1213: l_hdr_info_tbl CSC_SERVICE_KEY_PVT.HDR_info_tbl_type;

1209: l_customer_id number;
1210: l_match varchar2(1):='0';
1211: l_cust_account_id number;
1212: l_acct_last_update_date date;
1213: l_hdr_info_tbl CSC_SERVICE_KEY_PVT.HDR_info_tbl_type;
1214:
1215: --Variables used only for transfer/conference values
1216: l_xfer_action_id NUMBER;
1217: l_xfer_interaction_id NUMBER;

Line 1419: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SERVICE_REQUEST_NUMBER',

1415: if l_sr_num is not null then
1416: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SR');
1417:
1418: --call anand lookup to search for sr num
1419: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SERVICE_REQUEST_NUMBER',
1420: p_skey_value => l_sr_num,
1421: x_hdr_info_tbl => l_hdr_info_tbl);
1422: IF (l_hdr_info_tbl.count = 0) THEN
1423: l_match := '0';

Line 1504: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INSTANCE_NAME',

1500: elsif l_instance_name is not null then
1501: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceName');
1502:
1503: --call anand lookup to search for instance name
1504: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INSTANCE_NAME',
1505: p_skey_value => l_instance_name,
1506: x_hdr_info_tbl => l_hdr_info_tbl);
1507: IF (l_hdr_info_tbl.count = 0) THEN
1508: l_match := '0';

Line 1546: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INSTANCE_NUMBER',

1542: elsif l_instance_num is not null then
1543: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceNum');
1544:
1545: --call anand lookup to search for instance num
1546: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INSTANCE_NUMBER',
1547: p_skey_value => l_instance_num,
1548: x_hdr_info_tbl => l_hdr_info_tbl);
1549: IF (l_hdr_info_tbl.count = 0) THEN
1550: l_match := '0';

Line 1587: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SERIAL_NUMBER',

1583: elsif l_serial_num is not null then
1584: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SerialNum');
1585:
1586: --call anand lookup to search for serial num
1587: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SERIAL_NUMBER',
1588: p_skey_value => l_serial_num,
1589: x_hdr_info_tbl => l_hdr_info_tbl);
1590: IF (l_hdr_info_tbl.count = 0) THEN
1591: l_match := '0';

Line 1629: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'EXTERNAL_REFERENCE',

1625: elsif l_tag_num is not null then
1626: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','TagNum');
1627:
1628: --call anand lookup to search for tag num
1629: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'EXTERNAL_REFERENCE',
1630: p_skey_value => l_tag_num,
1631: x_hdr_info_tbl => l_hdr_info_tbl);
1632: IF (l_hdr_info_tbl.count = 0) THEN
1633: l_match := '0';

Line 1671: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SYSTEM_NUMBER',

1667: elsif l_system_name is not null then
1668: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SystemName');
1669:
1670: --call anand lookup to search for system name
1671: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SYSTEM_NUMBER',
1672: p_skey_value => l_system_name,
1673: x_hdr_info_tbl => l_hdr_info_tbl);
1674: IF (l_hdr_info_tbl.count = 0) THEN
1675: l_match := '0';

Line 1713: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'RMA_NUMBER',

1709: elsif l_rma_num is not null then
1710: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','RMANum');
1711:
1712: --call anand lookup to search for rma num
1713: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'RMA_NUMBER',
1714: p_skey_value => l_rma_num,
1715: x_hdr_info_tbl => l_hdr_info_tbl);
1716: IF (l_hdr_info_tbl.count = 0) THEN
1717: l_match := '0';

Line 1755: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'ORDER_NUMBER',

1751: elsif l_order_num is not null then
1752: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','OrderNum');
1753:
1754: --call anand lookup to search for order num
1755: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'ORDER_NUMBER',
1756: p_skey_value => l_order_num,
1757: x_hdr_info_tbl => l_hdr_info_tbl);
1758: IF (l_hdr_info_tbl.count = 0) THEN
1759: l_match := '0';

Line 1797: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SSN',

1793: elsif l_ssn is not null then
1794: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SSN');
1795:
1796: --call anand lookup to search for ssn
1797: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SSN',
1798: p_skey_value => l_ssn,
1799: x_hdr_info_tbl => l_hdr_info_tbl);
1800: IF (l_hdr_info_tbl.count = 0) THEN
1801: l_match := '0';

Line 1834: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'CONTRACT_NUMBER',

1830: elsif l_contract_num is not null then
1831: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ContractNum');
1832:
1833: --call anand lookup to search for contract num
1834: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'CONTRACT_NUMBER',
1835: p_skey_value => l_contract_num,
1836: x_hdr_info_tbl => l_hdr_info_tbl);
1837: IF (l_hdr_info_tbl.count = 0) THEN
1838: l_match := '0';

Line 1872: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INVOICE_NUMBER',

1868: elsif l_invoice_num is not null then
1869: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InvoiceNum');
1870:
1871: --call anand lookup to search for invoice num
1872: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INVOICE_NUMBER',
1873: p_skey_value => l_invoice_num,
1874: x_hdr_info_tbl => l_hdr_info_tbl);
1875: IF (l_hdr_info_tbl.count = 0) THEN
1876: l_match := '0';