1 PACKAGE CSC_SERVICE_KEY_CUHK AUTHID CURRENT_USER AS
2 /* $Header: cscppsks.pls 115.3 2003/08/18 05:41:32 akalidin 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
6 -- value.
7 -- PARAMTERS:
8 ----------
9 -- p_skey_name { Service Key Name is passed to this parameter }
10 -- p_skey_value { Service Key Value is passed to this parameter }
11 -- x_hdr_info_tbl { is Table of records. The record has the following columns }
12 -- { 1) cust_party_id NUMBER,
13 -- 2) cust_phone_id NUMBER,
14 -- 3) cust_email_id NUMBER,
15 -- 4) rel_party_id NUMBER,
16 -- 5) per_party_id NUMBER,
17 -- 6) rel_phone_id NUMBER,
18 -- 7) rel_email_id NUMBER,
19 -- 8) Account_id NUMBER }
20
21 PROCEDURE Service_Key_Search_Pre (
22 p_skey_name IN VARCHAR2,
23 p_skey_value IN VARCHAR2,
24 x_hdr_info_tbl OUT NOCOPY CSC_SERVICE_KEY_PVT.hdr_info_tbl_type );
25
26 END CSC_SERVICE_KEY_CUHK;