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.CSD_SC_DOMAINS_PVT dependencies on CSD_SC_DOMAINS

Line 1: PACKAGE BODY CSD_SC_DOMAINS_PVT as

1: PACKAGE BODY CSD_SC_DOMAINS_PVT as
2: /* $Header: csdvscdb.pls 115.6 2004/02/16 03:20:57 gilam noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_SC_DOMAINS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvscdb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_SC_DOMAINS_PVT';

1: PACKAGE BODY CSD_SC_DOMAINS_PVT as
2: /* $Header: csdvscdb.pls 115.6 2004/02/16 03:20:57 gilam noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_SC_DOMAINS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvscdb.pls';
6:
7: /*--------------------------------------------------*/
8: /* procedure name: Create_SC_Domain */

Line 34: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.create_sc_domain';

30: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
31: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
33: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
34: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.create_sc_domain';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_SC_Domain';
36: lc_api_version CONSTANT NUMBER := 1.0;
37:
38: -- VARIABLES --

Line 149: from csd_sc_domains

145:
146: /* gilam: bug 3445684 - changed query to include service code id in the each or condition
147: select 'X'
148: into l_dummy
149: from csd_sc_domains
150: where service_code_id = p_sc_domain_rec.service_code_id
151: and (domain_type_code = p_sc_domain_rec.domain_type_code
152: and inventory_item_id = p_sc_domain_rec.inventory_item_id)
153: or (domain_type_code = p_sc_domain_rec.domain_type_code

Line 159: from csd_sc_domains

155: and category_id = p_sc_domain_rec.category_id);
156: */
157: select 'X'
158: into l_dummy
159: from csd_sc_domains
160: where (service_code_id = p_sc_domain_rec.service_code_id
161: and domain_type_code = p_sc_domain_rec.domain_type_code
162: and inventory_item_id = p_sc_domain_rec.inventory_item_id)
163: or (service_code_id = p_sc_domain_rec.service_code_id

Line 383: CSD_SC_DOMAINS_PKG.Insert_Row

379:
380: BEGIN
381:
382: -- Insert the new domain
383: CSD_SC_DOMAINS_PKG.Insert_Row
384: (px_sc_domain_id => x_sc_domain_id,
385: p_object_version_number => l_obj_ver_num,
386: p_service_code_id => p_sc_domain_rec.service_code_id,
387: p_inventory_item_id => l_inventory_item_id,

Line 417: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: IF ( lc_excep_level >= lc_debug_level) THEN
417: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
418: END IF;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: END;
421:

Line 753: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.update_sc_domain';

749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
751: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
752: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
753: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.update_sc_domain';
754: lc_api_name CONSTANT VARCHAR2(30) := 'Update_SC_Domain';
755: lc_api_version CONSTANT NUMBER := 1.0;
756:
757: -- VARIABLES --

Line 875: from csd_sc_domains

871: -- Validate the service code domain id
872: Begin
873: select 'X'
874: into l_dummy
875: from csd_sc_domains
876: where sc_domain_id = p_sc_domain_rec.sc_domain_id;
877:
878: Exception
879: WHEN others THEN

Line 904: from csd_sc_domains

900: -- Get object version number for service code domain
901: Begin
902: select object_version_number
903: into l_obj_ver_num
904: from csd_sc_domains
905: where sc_domain_id = p_sc_domain_rec.sc_domain_id;
906:
907: Exception
908:

Line 953: from csd_sc_domains

949:
950: /* gilam: bug 3445684 - changed query to include service code id in the each or condition
951: select 'X'
952: into l_dummy
953: from csd_sc_domains
954: where sc_domain_id <> p_sc_domain_rec.sc_domain_id
955: and service_code_id = p_sc_domain_rec.service_code_id
956: and domain_type_code = p_sc_domain_rec.domain_type_code
957: and inventory_item_id = p_sc_domain_rec.inventory_item_id

Line 963: from csd_sc_domains

959: and category_id = p_sc_domain_rec.category_id;
960: */
961: select 'X'
962: into l_dummy
963: from csd_sc_domains
964: where sc_domain_id <> p_sc_domain_rec.sc_domain_id
965: and (service_code_id = p_sc_domain_rec.service_code_id
966: and domain_type_code = p_sc_domain_rec.domain_type_code
967: and inventory_item_id = p_sc_domain_rec.inventory_item_id)

Line 1014: from csd_sc_domains_v

1010:
1011: Begin
1012: select inventory_item_id
1013: into l_inventory_item_id
1014: from csd_sc_domains_v
1015: where sc_domain_id = p_sc_domain_rec.sc_domain_id
1016: and domain_type_code = p_sc_domain_rec.domain_type_code;
1017:
1018: Exception

Line 1091: from csd_sc_domains_v

1087:
1088: Begin
1089: select category_set_id
1090: into l_category_set_id
1091: from csd_sc_domains_v
1092: where sc_domain_id = p_sc_domain_rec.sc_domain_id
1093: and domain_type_code = p_sc_domain_rec.domain_type_code;
1094:
1095: Exception

Line 1187: from csd_sc_domains_v

1183:
1184: Begin
1185: select category_id
1186: into l_category_id
1187: from csd_sc_domains_v
1188: where sc_domain_id = p_sc_domain_rec.sc_domain_id
1189: and domain_type_code = p_sc_domain_rec.domain_type_code;
1190:
1191: Exception

Line 1303: CSD_SC_DOMAINS_PKG.Update_Row

1299:
1300: BEGIN
1301:
1302: -- Update the service code domain
1303: CSD_SC_DOMAINS_PKG.Update_Row
1304: (p_sc_domain_id => p_sc_domain_rec.sc_domain_id,
1305: p_object_version_number => l_obj_ver_num + 1,
1306: p_service_code_id => p_sc_domain_rec.service_code_id,
1307: p_inventory_item_id => l_inventory_item_id,

Line 1339: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1335:
1336: EXCEPTION
1337: WHEN OTHERS THEN
1338: IF ( lc_excep_level >= lc_debug_level) THEN
1339: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: END;
1343:

Line 1796: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.delete_sc_domain';

1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1794: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1795: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1796: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.delete_sc_domain';
1797: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_SC_Domain';
1798: lc_api_version CONSTANT NUMBER := 1.0;
1799:
1800: -- VARIABLES --

Line 1854: CSD_SC_DOMAINS_PKG.Delete_Row

1850:
1851: BEGIN
1852:
1853: -- Delete the service code domain
1854: CSD_SC_DOMAINS_PKG.Delete_Row
1855: (p_sc_domain_id => p_sc_domain_id );
1856:
1857: EXCEPTION
1858: WHEN OTHERS THEN

Line 1860: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1856:
1857: EXCEPTION
1858: WHEN OTHERS THEN
1859: IF ( lc_excep_level >= lc_debug_level) THEN
1860: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END;
1864:

Line 1992: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.lock_sc_domain';

1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1990: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1991: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1992: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.lock_sc_domain';
1993: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_SC_Domain';
1994: lc_api_version CONSTANT NUMBER := 1.0;
1995:
1996: -- VARIABLES --

Line 2056: CSD_SC_DOMAINS_PKG.Lock_Row

2052:
2053: BEGIN
2054:
2055: -- Lock the sc domain
2056: CSD_SC_DOMAINS_PKG.Lock_Row
2057: (p_sc_domain_id => p_sc_domain_rec.sc_domain_id,
2058: p_object_version_number => p_sc_domain_rec.object_version_number
2059:
2060: --commented out the rest of the record

Line 2095: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: IF ( lc_excep_level >= lc_debug_level) THEN
2095: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
2096: END IF;
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END;
2099:

Line 2201: End CSD_SC_DOMAINS_PVT;

2197: END IF;
2198:
2199: END Lock_SC_Domain;
2200:
2201: End CSD_SC_DOMAINS_PVT;
2202: