[Home] [Help]
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
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
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