PACKAGE: APPS.CSC_SERVICE_KEY_PVT

Source

1 PACKAGE CSC_SERVICE_KEY_PVT AUTHID CURRENT_USER AS
2 /* $Header: cscvpsks.pls 120.2 2005/11/29 14:33:07 akalidin noship $ */
3 
4  -- This record type stores all the ID's that found when search is made on
5  -- service key. It is used in defining table of records.
6  TYPE hdr_info_rec_type IS RECORD (
7 	service_key_id	NUMBER,
8  	cust_party_id   NUMBER,
9 	cust_phone_id   NUMBER,
10 	cust_email_id   NUMBER,
11 	rel_party_id    NUMBER,
12 	per_party_id    NUMBER,
13 	rel_phone_id    NUMBER,
14 	rel_email_id    NUMBER,
15 	org_id    NUMBER,
16 	Account_id      NUMBER,
17 	Employee_Id	NUMBER
18  );
19 
20  -- This table of record stores all ID's when multiple records are found
21  -- when search is made on service key.
22  TYPE hdr_info_tbl_type IS TABLE OF hdr_info_rec_type INDEX BY BINARY_INTEGER;
23 
24  -- This procedure accepts service key name, service key value and returns all
25  -- ID information that are found when search is made on a servcie key name and
26  -- value.
27  PROCEDURE Service_Key_Search (
28 				p_skey_name IN VARCHAR2,
29 				p_skey_value IN VARCHAR2,
30 				x_hdr_info_tbl OUT NOCOPY HDR_INFO_TBL_TYPE );
31 
32 END CSC_SERVICE_KEY_PVT;