DBA Data[Home] [Help]

APPS.AZW_PROC dependencies on WF_ACTIVITY_ATTRIBUTES_VL

Line 497: FROM wf_activity_attributes_vl waav

493:
494: IF (p_context_id > -1) THEN
495: SELECT waav.text_default
496: INTO v_ctxt_type
497: FROM wf_activity_attributes_vl waav
498: WHERE waav.activity_item_type = p_item_type
499: AND waav.activity_name = p_process_name
500: AND waav.name = 'AZW_IA_CTXTYP'
501: AND waav.activity_version =

Line 503: FROM wf_activity_attributes_vl

499: AND waav.activity_name = p_process_name
500: AND waav.name = 'AZW_IA_CTXTYP'
501: AND waav.activity_version =
502: (SELECT MAX(activity_version)
503: FROM wf_activity_attributes_vl
504: WHERE activity_item_type = p_item_type
505: AND activity_name = p_process_name
506: AND name = 'AZW_IA_CTXTYP');
507: END IF;

Line 517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');

513: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
514: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
515: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
516: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_type');
517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');
518: APP_EXCEPTION.RAISE_EXCEPTION;
519:
520: END get_context_type;
521: