APPS.HR_TRANSACTION_SWI dependencies on WF_NOTIFICATIONS

Line 1221: ln_notification_id wf_notifications.notification_id%type;

1217: --
1218: -- local variables
1219: c_proc constant varchar2(30) := 'setTransactionStatus';
1220: c_updateStatus hr_api_transactions.status%type;
1221: ln_notification_id wf_notifications.notification_id%type;
1222: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1223:
1224: begin
1225: -- check if debug enabled

Line 1258: from wf_notifications wn, wf_message_attributes mat

1254: l_exists := 'N';
1255: select 'Y' into l_exists
1256: from dual
1257: where exists (select 'e'
1258: from wf_notifications wn, wf_message_attributes mat
1259: where wn.notification_id = p_ntfId
1260: and wn.message_name = mat.message_name
1261: and wn.message_type = mat.message_type
1262: and mat.name = 'RESULT');

Line 1545: ln_notification_id wf_notifications.notification_id%type;

1541: p_item_type in varchar2,
1542: p_item_key in varchar2)
1543: is
1544: lv_result varchar2(100);
1545: ln_notification_id wf_notifications.notification_id%type;
1546: ln_activity_id wf_item_activity_statuses.process_activity%type;
1547: begin
1548:
1549: -- check on high level if the owner can delete it

Line 1648: ln_notification_id wf_notifications.notification_id%type;

1644: p_item_key in varchar2)
1645: is
1646: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1647: lv_result varchar2(100);
1648: ln_notification_id wf_notifications.notification_id%type;
1649: ln_activity_id wf_item_activity_statuses.process_activity%type;
1650: begin
1651:
1652: if(p_currentTxnStatus in ('Y','YS','RO','ROS')) then

Line 2271: ln_notification_id wf_notifications.notification_id%type;

2267: --
2268: -- local variables
2269: c_proc constant varchar2(30) := 'setTransactionStatus';
2270: c_updateStatus hr_api_transactions.status%type;
2271: ln_notification_id wf_notifications.notification_id%type;
2272: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2273: lv_item_key wf_items.item_key%type;
2274: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2275: lv_error_message varchar2(4000);

Line 2431: ln_notification_id wf_notifications.notification_id%type;

2427: --
2428: -- local variables
2429: c_proc constant varchar2(30) := 'setTransactionStatus';
2430: c_updateStatus hr_api_transactions.status%type;
2431: ln_notification_id wf_notifications.notification_id%type;
2432: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2433: lv_item_key wf_items.item_key%type;
2434: lv_item_type wf_items.item_type%type;
2435: lt_additional_wf_attributes HR_WF_ATTR_TABLE;