APPS.HR_TRANSACTION_SWI dependencies on WF_NOTIFICATION

Line 1108: ln_notification_id wf_notifications.notification_id%type;

1104: --
1105: -- local variables
1106: c_proc constant varchar2(30) := 'setTransactionStatus';
1107: c_updateStatus hr_api_transactions.status%type;
1108: ln_notification_id wf_notifications.notification_id%type;
1109: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1110:
1111: begin
1112: -- check if debug enabled

Line 1145: from wf_notifications wn, wf_message_attributes mat

1141: l_exists := 'N';
1142: select 'Y' into l_exists
1143: from dual
1144: where exists (select 'e'
1145: from wf_notifications wn, wf_message_attributes mat
1146: where wn.notification_id = p_ntfId
1147: and wn.message_name = mat.message_name
1148: and wn.message_type = mat.message_type
1149: and mat.name = 'RESULT');

Line 1387: ln_notification_id wf_notifications.notification_id%type;

1383: p_item_type in varchar2,
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

Line 1431: wf_notification.setattrtext(

1427: , p_item_Key
1428: , wf_engine.getactivitylabel(ln_activity_id)
1429: , 'DEL') ; */
1430: -- fix for bug 5328872
1431: wf_notification.setattrtext(
1432: ln_notification_id
1433: ,'RESULT'
1434: ,'DEL');
1435: wf_notification.respond(

Line 1435: wf_notification.respond(

1431: wf_notification.setattrtext(
1432: ln_notification_id
1433: ,'RESULT'
1434: ,'DEL');
1435: wf_notification.respond(
1436: ln_notification_id
1437: ,null
1438: ,fnd_global.user_name
1439: ,null);

Line 1490: ln_notification_id wf_notifications.notification_id%type;

1486: p_item_key in varchar2)
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

Line 1519: wf_notification.setattrtext(

1515: , p_item_Key
1516: , wf_engine.getactivitylabel(ln_activity_id)
1517: , 'REJECTED') ; */
1518: -- fix for bug 5328872
1519: wf_notification.setattrtext(
1520: ln_notification_id
1521: ,'RESULT'
1522: ,'REJECTED');
1523: wf_notification.respond(

Line 1523: wf_notification.respond(

1519: wf_notification.setattrtext(
1520: ln_notification_id
1521: ,'RESULT'
1522: ,'REJECTED');
1523: wf_notification.respond(
1524: ln_notification_id
1525: ,null
1526: ,fnd_global.user_name
1527: ,null);

Line 2047: ln_notification_id wf_notifications.notification_id%type;

2043: --
2044: -- local variables
2045: c_proc constant varchar2(30) := 'setTransactionStatus';
2046: c_updateStatus hr_api_transactions.status%type;
2047: ln_notification_id wf_notifications.notification_id%type;
2048: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2049: lv_item_key wf_items.item_key%type;
2050: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2051: lv_error_message varchar2(4000);