1 PACKAGE Pv_ptr_member_type_pvt AUTHID CURRENT_USER AS
2 /* $Header: pvxvmtcs.pls 120.1 2005/06/26 23:16:01 appldev ship $ */
3 -- ===============================================================
4
5 --------------------------------------------------------------------------
6 -- PROCEDURE
7 -- Register_term_ptr_memb_type
8 --
9 -- PURPOSE
10 -- This api can register as well as terminate member type and its corresponding relationships
11 -- IN
12 -- partner_id IN NUMBER.
13 -- for which member type is getting registered/terminated - either created/updated
14 -- p_current_memb_type.IN VARCHAR2 DEFAULT NULL
15 -- The existing member type stored in the db. if its not passed, we will query and get it
16 -- p_new_memb_type IN VARCHAR2.
17 -- pass GLOBAL,SUBSIDIARY or STANDARD if you want to register a new member type(also validated).
18 -- if you want to terminate the relationship pass null.
19 -- p_global_ptr_id. IN NUMBER DEFAULT NULL
20 -- if the new member type is SUBSIDIARY, pass the global's partner id from pv_partner_profiles table
21 -- this is validated only if the new member type is SUBSIDIARY
22
23 -- HISTORY
24 -- 15-SEP-2003 pukken CREATION
25 --------------------------------------------------------------------------
26 PROCEDURE Register_term_ptr_memb_type
27 (
28 p_api_version_number IN NUMBER
29 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
30 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
31 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
32 ,p_partner_id IN NUMBER
33 ,p_current_memb_type IN VARCHAR2 DEFAULT NULL
34 ,p_new_memb_type IN VARCHAR2
35 ,p_global_ptr_id IN NUMBER DEFAULT NULL
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_msg_count OUT NOCOPY NUMBER
38 ,x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 ---------------------------------------------
42
43 -- PROCEDURE
44 -- Pv_ptr_member_type_pvt.Process_ptr_member_type
45 --
46 -- PURPOSE
47 -- Change Membership Type.
48 -- IN
49 -- partner_id IN NUMBER
50 -- partner_id for which member type is getting changed
51 -- p_chg_from_memb_type IN VARCHAR2 := NULL
52 -- if not given, will get from profile, should be 'SUBSIDIARY','GLOBAL','STANDARD'
53 -- p_chg_to_memb_type IN VARCHAR2
54 -- should be 'SUBSIDIARY','GLOBAL','STANDARD'
55 -- p_chg_to_global_ptr_id IN NUMBER DEFAULT NULL
56 -- if p_chg_to_memb_type is 'SUBSIDIARY', this needs to be passed for identifying the global partner_id for the subsidiary
57 -- USED BY
58 -- called from vendor facing UI when member type change is requested by partner
59 --
60 -- HISTORY
61 -- 15-SEP-2003 pukken CREATION
62 --------------------------------------------------------------------------
63
64 PROCEDURE Process_ptr_member_type
65 (
66 p_api_version_number IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
69 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
70 ,p_partner_id IN NUMBER
71 ,p_chg_from_memb_type IN VARCHAR2 DEFAULT NULL
72 ,p_chg_to_memb_type IN VARCHAR2
73 ,p_chg_to_global_ptr_id IN NUMBER DEFAULT NULL
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE update_partner_dtl
80 (
81 p_api_version_number IN NUMBER
82 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83 , p_commit IN VARCHAR2 := FND_API.G_FALSE
84 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
85 , p_partner_id IN NUMBER
86 , p_old_partner_status IN VARCHAR2
87 , p_new_partner_status IN VARCHAR2
88 , p_chg_from_memb_type IN VARCHAR2
89 , p_chg_to_memb_type IN VARCHAR2
90 , p_old_global_ptr_id IN NUMBER DEFAULT NULL
91 , p_new_global_ptr_id IN NUMBER DEFAULT NULL
92 , x_return_status OUT NOCOPY VARCHAR2
93 , x_msg_count OUT NOCOPY NUMBER
94 , x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97 FUNCTION validate_global_partner_orgzn
98 ( p_global_prtnr_org_number IN VARCHAR2
99 )RETURN VARCHAR2;
100
101 FUNCTION get_global_partner_id
102 ( p_global_prtnr_org_number IN VARCHAR2
103 )RETURN NUMBER;
104
105 FUNCTION terminate_partner
106 (
107 p_subscription_guid IN RAW
108 , p_event IN OUT NOCOPY wf_event_t
109 ) RETURN VARCHAR2 ;
110
111
112
113 END Pv_ptr_member_type_pvt;