513: c_proc constant varchar2(30) := 'hasSupportingDocuments';
514: lv_item_type wf_item_activity_statuses.item_type%type;
515: lv_item_key wf_item_activity_statuses.item_key%type;
516: lv_entity_name constant varchar2(50) := 'PER_ABSENCE_ATTENDANCES';
517: lv_pkey1 fnd_attached_documents.pk1_value%type;
518: l_exists VARCHAR2(1);
519:
520: begin
521: g_debug := hr_utility.debug_enabled;
531:
532: begin
533: SELECT 'Y'
534: INTO l_exists
535: from fnd_attached_documents
536: where entity_name=lv_entity_name
537: and pk1_value=lv_pkey1
538: AND ROWNUM = 1;
539: exception