[Home] [Help]
2157: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2158: hz_organization_profiles HZOP,
2159: (SELECT rownum idx, column_value
2160: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2161: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))
2162: and pvpp.partner_id = x_partner.column_value
2163: and hzr.party_id = pvpp.partner_id
2164: and hzr.subject_id = hzp.party_id
2165: and hzr.object_id = HZOP.party_id
2773: INTO l_dup_count
2774: FROM (
2775: SELECT COUNT(*)
2776: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2777: FROM dual) a
2778: WHERE ROWNUM < 2
2779: GROUP BY concat_value_str
2780: HAVING COUNT(*) > 1) b;
2781:
2825:
2826: FOR x IN (
2827: SELECT *
2828: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2829: FROM dual) a
2830: ORDER BY concat_value_str DESC)
2831: LOOP
2832: x_partner_tbl(l_index) := x.party_id;
2833: --Debug(x.party_id || ':::' || x.concat_value_str);
2844: -- ------------------------------------------------------------
2845: FOR x IN (
2846: SELECT *
2847: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2848: FROM dual) a
2849: ORDER BY concat_value_str DESC, idx ASC)
2850: LOOP
2851: x_partner_tbl(l_index) := x.party_id;
2852: --Debug(x.party_id || ':::' || x.concat_value_str);
3352: AND LOOKUP_CODE = pc_status;
3353:
3354: CURSOR lc_curr_rank (p_wf_item_key NUMBER) IS
3355: SELECT wf_engine.GetItemAttrNumber( 'PVASGNMT',p_wf_item_key,'PV_SERIAL_RANK_ATTR')
3356: FROM dual;
3357:
3358: l_assign_status VARCHAR2(500) := 'UNASSIGNED';
3359: l_wf_status VARCHAR2(500);
3360: l_routing_status VARCHAR2(500);