[Home] [Help]
1384: p_item_key in varchar2)
1385: is
1386: lv_result varchar2(100);
1387: ln_notification_id wf_notifications.notification_id%type;
1388: ln_activity_id wf_item_activity_statuses.process_activity%type;
1389: begin
1390:
1391: -- check on high level if the owner can delete it
1392: -- only case when the pending approvals
1408:
1409: -- get the rfc ntf id
1410: select ias.notification_id,ias.process_activity
1411: into ln_notification_id,ln_activity_id
1412: from wf_item_activity_statuses ias
1413: where ias.item_type = p_item_type
1414: and ias.item_key = p_item_key
1415: and ias.activity_status = 'NOTIFIED'
1416: and notification_id is not null
1487: is
1488: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1489: lv_result varchar2(100);
1490: ln_notification_id wf_notifications.notification_id%type;
1491: ln_activity_id wf_item_activity_statuses.process_activity%type;
1492: begin
1493:
1494: if(p_currentTxnStatus in ('Y','YS','RO','ROS')) then
1495: -- get the notification activity id and complete
1496: -- the process in reject status
1497: -- get the rfc ntf id
1498: select ias.notification_id,ias.process_activity
1499: into ln_notification_id,ln_activity_id
1500: from wf_item_activity_statuses ias
1501: where ias.item_type = p_item_type
1502: and ias.item_key = p_item_key
1503: and ias.activity_status = 'NOTIFIED'
1504: and notification_id is not null
1790: lv_item_type wf_items.item_type%type;
1791: lr_transaction_rec hr_api_transactions%rowtype;
1792: lv_status varchar2(8);
1793: lv_result varchar2(30);
1794: lv_errorActid wf_item_activity_statuses.process_activity%type;
1795: lv_errname VARCHAR2(4000);
1796: l_index binary_integer;
1797: l_temp_item_attribute varchar2(2000);
1798: l_role_name wf_roles.name%type;