DBA Data[Home] [Help]

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.11 2011/12/09 11:46:09 rissingh ship $ */
3:
4: /* Public Constants */
5: NULL_VALUE_CONST constant varchar2(10) := 'Other';

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

1148: cust.attribute6, 'attribute7', cust.attribute7, 'attribute8', cust.attribute8,
1149: 'attribute9', cust.attribute9, 'attribute10', cust.attribute10, 'attribute11',
1150: cust.attribute11, 'attribute12', cust.attribute12, 'attribute13',cust.attribute13,
1151: 'attribute14', cust.attribute14, 'attribute15', cust.attribute15, '2'), '1',
1152: nvl(cia.account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1153: from cs_incidents_all_b cia,
1154: hz_cust_accounts cust,
1155: csd_repairs crp
1156: where crp.repair_line_id = p_repair_line_id

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

1294: 'attribute12', cust.attribute12,
1295: 'attribute13',cust.attribute13,
1296: 'attribute14', cust.attribute14,
1297: 'attribute15', cust.attribute15, '2')
1298: , '1', nvl(cust.cust_account_id,msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1299: from
1300: hz_cust_accounts cust,
1301: (select parameter_value from msd_setup_parameters where parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust
1302: where cust.party_id = p_party_id

Line 1469: return msd_sr_util.get_null_pk;

1465:
1466: begin
1467:
1468: if ((p_location_id is null) or (p_zone_attr is null)) then
1469: return msd_sr_util.get_null_pk;
1470: else
1471:
1472: l_sql_stmt := ' select wrv.region_id ' ||
1473: ' from wsh_region_locations wrl, ' ||

Line 1494: return msd_sr_util.get_null_pk;

1490:
1491: if (x_region_id is not null) then
1492: return to_char(p_customer_id) || ':' || to_char(x_region_id);
1493: else
1494: return msd_sr_util.get_null_pk;
1495: end if;
1496: end if;
1497: EXCEPTION
1498: when no_data_found then return msd_sr_util.get_null_pk;

Line 1498: when no_data_found then return msd_sr_util.get_null_pk;

1494: return msd_sr_util.get_null_pk;
1495: end if;
1496: end if;
1497: EXCEPTION
1498: when no_data_found then return msd_sr_util.get_null_pk;
1499: end get_sr_custzone_pk;
1500:
1501: /* This function is used in Zone hierarchy views
1502: * to return description for Customer Zone Level Values.

Line 1516: return msd_sr_util.get_null_desc;

1512:
1513: begin
1514:
1515: if ((p_location_id is null) or (p_zone_attr is null)) then
1516: return msd_sr_util.get_null_desc;
1517: else
1518:
1519: l_sql_stmt := ' select wrv.zone ' ||
1520: ' from wsh_region_locations wrl, ' ||

Line 1541: return msd_sr_util.get_null_desc;

1537:
1538: if (x_region_id is not null) then
1539: return p_customer_name || ':' || x_region_id;
1540: else
1541: return msd_sr_util.get_null_desc;
1542: end if;
1543: end if;
1544: EXCEPTION
1545: when no_data_found then return msd_sr_util.get_null_desc;

Line 1545: when no_data_found then return msd_sr_util.get_null_desc;

1541: return msd_sr_util.get_null_desc;
1542: end if;
1543: end if;
1544: EXCEPTION
1545: when no_data_found then return msd_sr_util.get_null_desc;
1546: end get_sr_custzone_desc;
1547:
1548: /* This function is used in Zone hierarchy views
1549: * to return Source Level Value Pks for Zone Level Values.

Line 1563: return msd_sr_util.get_null_pk;

1559:
1560: begin
1561:
1562: if ((p_location_id is null) or (p_zone_attr is null)) then
1563: return msd_sr_util.get_null_pk;
1564: else
1565:
1566: l_sql_stmt := ' select wrv.region_id ' ||
1567: ' from wsh_region_locations wrl, ' ||

Line 1588: return msd_sr_util.get_null_pk;

1584:
1585: if (x_region_id is not null) then
1586: return x_region_id;
1587: else
1588: return msd_sr_util.get_null_pk;
1589: end if;
1590: end if;
1591: EXCEPTION
1592: when others then return msd_sr_util.get_null_pk;

Line 1592: when others then return msd_sr_util.get_null_pk;

1588: return msd_sr_util.get_null_pk;
1589: end if;
1590: end if;
1591: EXCEPTION
1592: when others then return msd_sr_util.get_null_pk;
1593: end get_sr_zone_pk1;
1594:
1595:
1596: /* This function is used in Zone hierarchy views

Line 1610: return msd_sr_util.get_null_desc;

1606:
1607: begin
1608:
1609: if ((p_location_id is null) or (p_zone_attr is null)) then
1610: return msd_sr_util.get_null_desc;
1611: else
1612:
1613: l_sql_stmt := ' select wrv.zone ' ||
1614: ' from wsh_region_locations wrl, ' ||

Line 1635: return msd_sr_util.get_null_desc;

1631:
1632: if (x_region_id is not null) then
1633: return x_region_id;
1634: else
1635: return msd_sr_util.get_null_desc;
1636: end if;
1637: end if;
1638: EXCEPTION
1639: when others then return msd_sr_util.get_null_desc;

Line 1639: when others then return msd_sr_util.get_null_desc;

1635: return msd_sr_util.get_null_desc;
1636: end if;
1637: end if;
1638: EXCEPTION
1639: when others then return msd_sr_util.get_null_desc;
1640: end get_sr_zone_desc;
1641:
1642: END MSD_SR_UTIL;

Line 1642: END MSD_SR_UTIL;

1638: EXCEPTION
1639: when others then return msd_sr_util.get_null_desc;
1640: end get_sr_zone_desc;
1641:
1642: END MSD_SR_UTIL;