PACKAGE: APPS.PV_REFERRAL_STATUS_MAPS_PKG

Source

1 package PV_REFERRAL_STATUS_MAPS_PKG as
2 /* $Header: pvxtrfms.pls 120.0 2005/07/11 23:13:06 appldev noship $ */
3 
4 
5 procedure INSERT_ROW (
6   px_referral_status_map_id	IN OUT NOCOPY NUMBER,
7   px_object_version_number	IN OUT NOCOPY NUMBER,
8   p_benefit_type		IN VARCHAR2,
9   p_status_code			IN VARCHAR2,
10   p_map_status_code		IN VARCHAR2,
11   p_creation_date		IN DATE,
12   p_created_by			IN NUMBER,
13   p_last_update_date		IN DATE,
14   p_last_updated_by		IN NUMBER,
15   p_last_update_login		IN NUMBER);
16 
17 
18 procedure LOCK_ROW (
19   p_referral_status_map_id IN NUMBER,
20   p_object_version_number  IN NUMBER,
21   p_benefit_type	   IN VARCHAR2,
22   p_status_code            IN VARCHAR2,
23   p_map_status_code        IN VARCHAR2
24 );
25 
26 procedure UPDATE_ROW (
27   p_referral_status_map_id IN NUMBER,
28   p_object_version_number  IN NUMBER,
29   p_benefit_type	   IN VARCHAR2,
30   p_status_code		   IN VARCHAR2,
31   p_map_status_code	   IN VARCHAR2,
32   p_last_update_date	   IN DATE,
33   p_last_updated_by	   IN NUMBER,
34   p_last_update_login	   IN NUMBER
35 );
36 
37 procedure DELETE_ROW (
38   p_referral_status_map_id in NUMBER
39 );
40 
41 procedure LOAD_ROW (
42   p_upload_mode            IN VARCHAR2,
43   p_referral_status_map_id IN NUMBER,
44   p_object_version_number  IN NUMBER,
45   p_benefit_type	   IN VARCHAR2,
46   p_status_code		   IN VARCHAR2,
47   p_map_status_code	   IN VARCHAR2,
48   p_owner		   IN VARCHAR2
49 );
50 end PV_REFERRAL_STATUS_MAPS_PKG;