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.MSD_SR_UTIL dependencies on MSD_SR_UTIL

Line 1: PACKAGE BODY MSD_SR_UTIL AS

1: PACKAGE BODY MSD_SR_UTIL AS
2: /* $Header: msdutilb.pls 120.8 2006/07/04 12:17:38 sjagathe noship $ */
3:
4: /* Public Constants */
5: NULL_VALUE_CONST constant varchar2(10) := 'Other';

Line 1084: nvl(cia.account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)

1080: cust.attribute6, 'attribute7', cust.attribute7, 'attribute8', cust.attribute8,
1081: 'attribute9', cust.attribute9, 'attribute10', cust.attribute10, 'attribute11',
1082: cust.attribute11, 'attribute12', cust.attribute12, 'attribute13',cust.attribute13,
1083: 'attribute14', cust.attribute14, 'attribute15', cust.attribute15, '2'), '1',
1084: nvl(cia.account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1085: from cs_incidents_all_b cia,
1086: hz_cust_accounts cust,
1087: csd_repairs crp
1088: where crp.repair_line_id = p_repair_line_id

Line 1230: , '1', nvl(cust.cust_account_id,msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)

1226: 'attribute12', cust.attribute12,
1227: 'attribute13',cust.attribute13,
1228: 'attribute14', cust.attribute14,
1229: 'attribute15', cust.attribute15, '2')
1230: , '1', nvl(cust.cust_account_id,msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1231: from
1232: hz_cust_accounts cust,
1233: (select parameter_value from msd_setup_parameters where parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust
1234: where cust.party_id = p_party_id

Line 1394: return msd_sr_util.get_null_pk;

1390:
1391: begin
1392:
1393: if ((p_location_id is null) or (p_zone_attr is null)) then
1394: return msd_sr_util.get_null_pk;
1395: else
1396:
1397: l_sql_stmt := ' select wrv.region_id ' ||
1398: ' from wsh_region_locations wrl, ' ||

Line 1419: return msd_sr_util.get_null_pk;

1415:
1416: if (x_region_id is not null) then
1417: return to_char(p_customer_id) || ':' || to_char(x_region_id);
1418: else
1419: return msd_sr_util.get_null_pk;
1420: end if;
1421: end if;
1422: EXCEPTION
1423: when no_data_found then return msd_sr_util.get_null_pk;

Line 1423: when no_data_found then return msd_sr_util.get_null_pk;

1419: return msd_sr_util.get_null_pk;
1420: end if;
1421: end if;
1422: EXCEPTION
1423: when no_data_found then return msd_sr_util.get_null_pk;
1424: end get_sr_custzone_pk;
1425:
1426: /* This function is used in Zone hierarchy views
1427: * to return description for Customer Zone Level Values.

Line 1441: return msd_sr_util.get_null_desc;

1437:
1438: begin
1439:
1440: if ((p_location_id is null) or (p_zone_attr is null)) then
1441: return msd_sr_util.get_null_desc;
1442: else
1443:
1444: l_sql_stmt := ' select wrv.zone ' ||
1445: ' from wsh_region_locations wrl, ' ||

Line 1466: return msd_sr_util.get_null_desc;

1462:
1463: if (x_region_id is not null) then
1464: return p_customer_name || ':' || x_region_id;
1465: else
1466: return msd_sr_util.get_null_desc;
1467: end if;
1468: end if;
1469: EXCEPTION
1470: when no_data_found then return msd_sr_util.get_null_desc;

Line 1470: when no_data_found then return msd_sr_util.get_null_desc;

1466: return msd_sr_util.get_null_desc;
1467: end if;
1468: end if;
1469: EXCEPTION
1470: when no_data_found then return msd_sr_util.get_null_desc;
1471: end get_sr_custzone_desc;
1472:
1473: /* This function is used in Zone hierarchy views
1474: * to return Source Level Value Pks for Zone Level Values.

Line 1488: return msd_sr_util.get_null_pk;

1484:
1485: begin
1486:
1487: if ((p_location_id is null) or (p_zone_attr is null)) then
1488: return msd_sr_util.get_null_pk;
1489: else
1490:
1491: l_sql_stmt := ' select wrv.region_id ' ||
1492: ' from wsh_region_locations wrl, ' ||

Line 1513: return msd_sr_util.get_null_pk;

1509:
1510: if (x_region_id is not null) then
1511: return x_region_id;
1512: else
1513: return msd_sr_util.get_null_pk;
1514: end if;
1515: end if;
1516: EXCEPTION
1517: when others then return msd_sr_util.get_null_pk;

Line 1517: when others then return msd_sr_util.get_null_pk;

1513: return msd_sr_util.get_null_pk;
1514: end if;
1515: end if;
1516: EXCEPTION
1517: when others then return msd_sr_util.get_null_pk;
1518: end get_sr_zone_pk1;
1519:
1520:
1521: /* This function is used in Zone hierarchy views

Line 1535: return msd_sr_util.get_null_desc;

1531:
1532: begin
1533:
1534: if ((p_location_id is null) or (p_zone_attr is null)) then
1535: return msd_sr_util.get_null_desc;
1536: else
1537:
1538: l_sql_stmt := ' select wrv.zone ' ||
1539: ' from wsh_region_locations wrl, ' ||

Line 1560: return msd_sr_util.get_null_desc;

1556:
1557: if (x_region_id is not null) then
1558: return x_region_id;
1559: else
1560: return msd_sr_util.get_null_desc;
1561: end if;
1562: end if;
1563: EXCEPTION
1564: when others then return msd_sr_util.get_null_desc;

Line 1564: when others then return msd_sr_util.get_null_desc;

1560: return msd_sr_util.get_null_desc;
1561: end if;
1562: end if;
1563: EXCEPTION
1564: when others then return msd_sr_util.get_null_desc;
1565: end get_sr_zone_desc;
1566:
1567: END MSD_SR_UTIL;

Line 1567: END MSD_SR_UTIL;

1563: EXCEPTION
1564: when others then return msd_sr_util.get_null_desc;
1565: end get_sr_zone_desc;
1566:
1567: END MSD_SR_UTIL;