APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 287: lv_item_type wf_item_activity_statuses.item_type%type;

283: display_type IN Varchar2,
284: document IN OUT NOCOPY varchar2,
285: document_type IN OUT NOCOPY Varchar2) is
286: c_proc varchar2(30) default 'GetItemAttrText';
287: lv_item_type wf_item_activity_statuses.item_type%type;
288: lv_item_key wf_item_activity_statuses.item_key%type;
289: lv_checkProfile VARCHAR2(10);
290: lv_profileValue VARCHAR2(1);
291: lv_status hr_api_transactions.status%type;

Line 288: lv_item_key wf_item_activity_statuses.item_key%type;

284: document IN OUT NOCOPY varchar2,
285: document_type IN OUT NOCOPY Varchar2) is
286: c_proc varchar2(30) default 'GetItemAttrText';
287: lv_item_type wf_item_activity_statuses.item_type%type;
288: lv_item_key wf_item_activity_statuses.item_key%type;
289: lv_checkProfile VARCHAR2(10);
290: lv_profileValue VARCHAR2(1);
291: lv_status hr_api_transactions.status%type;
292: lv_link_label wf_message_attributes_vl.display_name%type;

Line 810: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity:'||lv_procedure_name||'with itemtype:', 3);

806: ln_appr_particp_block_id:= wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR');
807: begin
808: if(hr_utility.debug_enabled) then
809: -- write debug statements
810: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity:'||lv_procedure_name||'with itemtype:', 3);
811: end if;
812:
813: SELECT process_activity
814: into ln_appr_approval_block_id

Line 815: FROM WF_ITEM_ACTIVITY_STATUSES IAS

811: end if;
812:
813: SELECT process_activity
814: into ln_appr_approval_block_id
815: FROM WF_ITEM_ACTIVITY_STATUSES IAS
816: WHERE ias.item_type = p_itemType
817: and ias.item_key = p_itemKey
818: and ias.activity_status = 'NOTIFIED'
819: and ias.process_activity not in

Line 826: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES for itemtype:'|| p_itemType||' and item key:'||p_itemType, 4);

822: exception
823: when no_data_found then
824: if(hr_utility.debug_enabled) then
825: -- write debug statements
826: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES for itemtype:'|| p_itemType||' and item key:'||p_itemType, 4);
827: end if;
828: ln_appr_approval_block_id := null;
829: when others then
830: ln_appr_approval_block_id := null;

Line 838: FROM WF_ITEM_ACTIVITY_STATUSES IAS

834: -- finally if ln_appr_approval_block_id is null check if we have notified activities
835: if(ln_appr_approval_block_id is null) then
836: SELECT process_activity
837: into ln_appr_approval_block_id
838: FROM WF_ITEM_ACTIVITY_STATUSES IAS
839: WHERE ias.item_type = p_itemType
840: and ias.item_key = p_itemKey
841: and ias.activity_status = 'NOTIFIED'
842: and ias.notification_id is not null;

Line 1124: lv_item_type wf_item_activity_statuses.item_type%type;

1120: display_type IN Varchar2,
1121: document IN OUT NOCOPY varchar2,
1122: document_type IN OUT NOCOPY Varchar2) is
1123: c_proc varchar2(30) default 'build_ma_compl_log_msg';
1124: lv_item_type wf_item_activity_statuses.item_type%type;
1125: lv_item_key wf_item_activity_statuses.item_key%type;
1126: begin
1127: g_debug := hr_utility.debug_enabled;
1128: if g_debug then

Line 1125: lv_item_key wf_item_activity_statuses.item_key%type;

1121: document IN OUT NOCOPY varchar2,
1122: document_type IN OUT NOCOPY Varchar2) is
1123: c_proc varchar2(30) default 'build_ma_compl_log_msg';
1124: lv_item_type wf_item_activity_statuses.item_type%type;
1125: lv_item_key wf_item_activity_statuses.item_key%type;
1126: begin
1127: g_debug := hr_utility.debug_enabled;
1128: if g_debug then
1129: hr_utility.set_location('Entering:'|| gv_package||'.'||c_proc, 1);