APPS.CSC_SERVICE_KEY_PVT dependencies on CSC_SERVICE_KEY_PVT

Line 1: PACKAGE BODY CSC_SERVICE_KEY_PVT AS

1: PACKAGE BODY CSC_SERVICE_KEY_PVT AS
2: /* $Header: cscvpskb.pls 120.6 2006/04/17 21:14:32 kjhamb noship $ */
3:
4: -- This procedure accepts service key name, service key value and returns all
5: -- ID information that are found when search is made on a servcie key name and

Line 21: l_hdr_info_tbl CSC_SERVICE_KEY_PVT.hdr_info_tbl_type;

17: l_incident_id NUMBER;
18: l_contact_point_type VARCHAR2(30);
19: l_contact_type VARCHAR2(100);
20: l_count NUMBER :=0;
21: l_hdr_info_tbl CSC_SERVICE_KEY_PVT.hdr_info_tbl_type;
22: l_sold_to_contact_id NUMBER;
23:
24: -- Cursor declaration for Service Keys
25:

Line 173: IF JTF_USR_HKS.ok_to_Execute('CSC_SERVICE_KEY_PVT', 'SERVICE_KEY_SEARCH', 'B', 'C') THEN

169: BEGIN
170:
171: l_skey_value := p_skey_value;
172: l_skey_name := p_skey_name;
173: IF JTF_USR_HKS.ok_to_Execute('CSC_SERVICE_KEY_PVT', 'SERVICE_KEY_SEARCH', 'B', 'C') THEN
174: CSC_Service_Key_CUHK.Service_Key_Search_Pre(p_skey_name => l_skey_name,
175: p_skey_value => l_skey_value,
176: x_hdr_info_tbl => l_hdr_info_tbl);
177: x_hdr_info_tbl := l_hdr_info_tbl;

Line 453: FND_MSG_PUB.Build_Exc_Msg( p_pkg_name => 'CSC_SERVICE_KEY_PVT',

449: --FND_MESSAGE.Set_Name('CSC', 'CSC_INVALID_NUMBER');
450: --FND_MESSAGE.Set_Token('PARAMETER', 'Order');
451: --APP_EXCEPTION.raise_exception;
452: WHEN OTHERS THEN
453: FND_MSG_PUB.Build_Exc_Msg( p_pkg_name => 'CSC_SERVICE_KEY_PVT',
454: p_procedure_name => 'Service_Key_Search');
455: APP_EXCEPTION.raise_exception;
456: END Service_Key_Search;
457:

Line 458: END CSC_SERVICE_KEY_PVT;

454: p_procedure_name => 'Service_Key_Search');
455: APP_EXCEPTION.raise_exception;
456: END Service_Key_Search;
457:
458: END CSC_SERVICE_KEY_PVT;