PACKAGE: APPS.CSC_SERVICE_KEY_CUHK

Source

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;