DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on WF_ENGINE

Line 3355: SELECT wf_engine.GetItemAttrNumber( 'PVASGNMT',p_wf_item_key,'PV_SERIAL_RANK_ATTR')

3351: WHERE LOOKUP_TYPE = 'PV_ASN_ASSIGNMENT_STATUS'
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);