[Home] [Help]
32: IS
33:
34: cursor is_global_cur(p_ptr_id NUMBER) IS
35: SELECT decode ( attr_value,'GLOBAL','Y','N')
36: FROM pv_enty_attr_values
37: WHERE entity='PARTNER'
38: AND entity_id=p_ptr_id
39: AND attribute_id=6
40: AND latest_flag='Y';
255: ) IS
256:
257: CURSOR memb_type_cur( p_ptr_id NUMBER) IS
258: SELECT attr_value,version
259: FROM pv_enty_attr_values
260: WHERE entity='PARTNER'
261: AND entity_id=p_ptr_id
262: AND attribute_id=6
263: AND latest_flag='Y';
263: AND latest_flag='Y';
264:
265: CURSOR attr_version_cur( p_ptr_id NUMBER) IS
266: SELECT version
267: FROM pv_enty_attr_values
268: WHERE entity='PARTNER'
269: AND entity_id=p_ptr_id
270: AND attribute_id=6
271: AND latest_flag='Y';
285: , rel.status
286: , rel.start_date
287: FROM pv_partner_profiles subs_prof
288: , pv_partner_profiles global_prof
289: , pv_enty_attr_values subs_enty_val
290: , hz_relationships rel
291: WHERE
292: global_prof.partner_id = p_ptr_id
293: AND global_prof.partner_party_id = rel.subject_id
315: , rel.status
316: , rel.start_date
317: FROM pv_partner_profiles subs_prof
318: , pv_partner_profiles global_prof
319: , pv_enty_attr_values subs_enty_val
320: , pv_enty_attr_values global_enty_val
321: , hz_relationships rel
322: WHERE global_enty_val.entity = 'PARTNER'
323: AND global_enty_val.entity_id = global_prof.partner_id
316: , rel.start_date
317: FROM pv_partner_profiles subs_prof
318: , pv_partner_profiles global_prof
319: , pv_enty_attr_values subs_enty_val
320: , pv_enty_attr_values global_enty_val
321: , hz_relationships rel
322: WHERE global_enty_val.entity = 'PARTNER'
323: AND global_enty_val.entity_id = global_prof.partner_id
324: AND global_enty_val.attribute_id = 6
364: , rel.object_version_number object_version_number
365: , subs_prof.partner_party_id partner_party_id
366: , subs_enty_val.version version
367: FROM pv_partner_profiles subs_prof
368: , pv_enty_attr_values subs_enty_val
369: , hz_relationships rel
370: WHERE rel.subject_id=subs_prof.partner_party_id
371: AND rel.relationship_code = 'SUBSIDIARY_OF'
372: AND rel.relationship_type = 'PARTNER_HIERARCHY'
960: ) IS
961:
962: CURSOR memb_type_cur( p_ptr_id NUMBER) IS
963: SELECT attr_value
964: FROM pv_enty_attr_values
965: WHERE entity='PARTNER'
966: AND entity_id=p_ptr_id
967: AND attribute_id=6
968: AND latest_flag='Y';
1187: IS
1188:
1189: cursor cv_validate_global_orgzn(cv_orgzn_number VARCHAR2) IS
1190: select 1 from dual where exists
1191: (select 1 from hz_parties hzp, pv_partner_profiles pvpp, pv_enty_attr_values pvev
1192: where hzp.party_number= cv_orgzn_number
1193: and hzp.party_id = pvpp.partner_party_id
1194: and pvpp.status = 'A'
1195: and pvpp.partner_id = pvev.entity_id
1225: IS
1226: l_global_prtnr_id NUMBER := NULL ;
1227:
1228: cursor cv_get_global_prtnr_id(cv_orgzn_number VARCHAR2) IS
1229: select pvpp.partner_id from hz_parties hzp, pv_partner_profiles pvpp, pv_enty_attr_values pvev
1230: where hzp.party_number= cv_orgzn_number
1231: and hzp.party_id = pvpp.partner_party_id
1232: and pvpp.status = 'A'
1233: and pvpp.partner_id = pvev.entity_id
1301: SELECT partner_id
1302:
1303: FROM pv_partner_profiles prof
1304: , hz_relationships rel
1305: , pv_enty_attr_values enty
1306: WHERE rel.relationship_id = rel_id
1307: AND rel.relationship_type= 'PARTNER_HIERARCHY'
1308: AND rel.relationship_code= 'SUBSIDIARY_OF'
1309: AND rel.subject_id=prof.partner_party_id
1318: , enty.attr_value attr_value
1319: FROM pv_partner_profiles sprof
1320: , pv_partner_profiles gprof
1321: , hz_relationships rel
1322: , pv_enty_attr_values enty
1323: WHERE rel.relationship_id = rel_id
1324: AND rel.relationship_type= 'PARTNER_HIERARCHY'
1325: AND rel.relationship_code= 'SUBSIDIARY_OF'
1326: AND rel.subject_id=sprof.partner_party_id
1330: AND enty.latest_flag='Y' ;
1331:
1332: CURSOR attr_version_cur( p_ptr_id NUMBER) IS
1333: SELECT version,attr_value
1334: FROM pv_enty_attr_values
1335: WHERE entity='PARTNER'
1336: AND entity_id=p_ptr_id
1337: AND attribute_id=6
1338: AND latest_flag='Y';