eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SFLUTIL_SS dependencies on WF_ITEMS

Line 34: from wf_items

30: end if;
31:
32: select item_type, item_key
33: into p_item_type,p_item_key
34: from wf_items
35: where user_key=to_char(p_transaction_id)
36: and rownum<2;
37: if g_debug then
38: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 3);

Line 634: -- check the wf_items table

630: if g_debug then
631: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
632: end if;
633:
634: -- check the wf_items table
635: begin
636: select item_type,item_key
637: into p_itemType,p_itemKey
638: from wf_items

Line 638: from wf_items

634: -- check the wf_items table
635: begin
636: select item_type,item_key
637: into p_itemType,p_itemKey
638: from wf_items
639: where user_key=to_char(p_transaction_id)
640: and item_type=nvl(p_itemType,'HRSFL')
641: and end_date is null
642: and rownum<2;

Line 670: lv_item_key wf_items.item_key%type;

666: ,p_itemType IN OUT NOCOPY VARCHAR2
667: ,p_process_name IN VARCHAR2
668: ,p_itemKey OUT NOCOPY VARCHAR2 )
669: IS
670: lv_item_key wf_items.item_key%type;
671: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
672: BEGIN
673: -- get the item key from sequence
674: -- Get the next item key from the sequence

Line 736: lv_item_type wf_items.item_type%type;

732: --
733: PRAGMA AUTONOMOUS_TRANSACTION;
734: --
735: c_proc constant varchar2(30) := 'getSFLTransactionDetails';
736: lv_item_type wf_items.item_type%type;
737: lv_item_key wf_items.item_type%type;
738: ln_notification_id wf_notifications.notification_id%type;
739: lv_process_name wf_items.root_activity%type;
740: ln_sfl_block_activity_id number;

Line 737: lv_item_key wf_items.item_type%type;

733: PRAGMA AUTONOMOUS_TRANSACTION;
734: --
735: c_proc constant varchar2(30) := 'getSFLTransactionDetails';
736: lv_item_type wf_items.item_type%type;
737: lv_item_key wf_items.item_type%type;
738: ln_notification_id wf_notifications.notification_id%type;
739: lv_process_name wf_items.root_activity%type;
740: ln_sfl_block_activity_id number;
741: lv_relaunchSFLLink varchar2(2000);

Line 739: lv_process_name wf_items.root_activity%type;

735: c_proc constant varchar2(30) := 'getSFLTransactionDetails';
736: lv_item_type wf_items.item_type%type;
737: lv_item_key wf_items.item_type%type;
738: ln_notification_id wf_notifications.notification_id%type;
739: lv_process_name wf_items.root_activity%type;
740: ln_sfl_block_activity_id number;
741: lv_relaunchSFLLink varchar2(2000);
742: begin
743: hr_sflutil_ss.getsfltransactiondetails(p_transaction_id,

Line 989: WF_ITEMS WI

985: select wpa.instance_id
986: FROM WF_PROCESS_ACTIVITIES WPA,
987: WF_ACTIVITY_ATTRIBUTES WAA,
988: WF_ACTIVITIES WA,
989: WF_ITEMS WI
990: WHERE wpa.process_item_type = ias.item_type
991: and wa.item_type = wpa.process_item_type
992: and wa.name = wpa.activity_name
993: and wi.item_type = ias.item_type

Line 1057: lv_sfl_item_type wf_items.item_type%type;

1053: ,p_approvalItemKey in varchar2)
1054: is
1055: -- local variables
1056: c_proc constant varchar2(30) := 'closeSFLNotifications';
1057: lv_sfl_item_type wf_items.item_type%type;
1058: lv_sfl_item_key wf_items.item_key%type;
1059: ln_sfl_block_activity_id number;
1060:
1061: begin

Line 1058: lv_sfl_item_key wf_items.item_key%type;

1054: is
1055: -- local variables
1056: c_proc constant varchar2(30) := 'closeSFLNotifications';
1057: lv_sfl_item_type wf_items.item_type%type;
1058: lv_sfl_item_key wf_items.item_key%type;
1059: ln_sfl_block_activity_id number;
1060:
1061: begin
1062: if g_debug then

Line 1072: from wf_items

1068:
1069: -- check if there are any SFL transaction associated
1070: select item_type, item_key
1071: into lv_sfl_item_type,lv_sfl_item_key
1072: from wf_items
1073: where user_key=to_char(p_transaction_id)
1074: --and parent_item_type=nvl(p_approvalItemType,parent_item_type)
1075: --and parent_item_key=nvl(p_approvalItemKey,parent_item_key)
1076: and rownum<2;

Line 1111: lv_sfl_item_type wf_items.item_type%type;

1107: procedure closeOpenSFLNotification(p_transaction_id IN NUMBER)
1108: is
1109: -- local variables
1110: c_proc constant varchar2(40) := 'closeOpenSFLNotification';
1111: lv_sfl_item_type wf_items.item_type%type;
1112: lv_sfl_item_key wf_items.item_key%type;
1113: ln_sfl_block_activity_id number;
1114: ln_notification_id wf_notifications.notification_id%type;
1115:

Line 1112: lv_sfl_item_key wf_items.item_key%type;

1108: is
1109: -- local variables
1110: c_proc constant varchar2(40) := 'closeOpenSFLNotification';
1111: lv_sfl_item_type wf_items.item_type%type;
1112: lv_sfl_item_key wf_items.item_key%type;
1113: ln_sfl_block_activity_id number;
1114: ln_notification_id wf_notifications.notification_id%type;
1115:
1116: begin

Line 1128: from wf_items

1124:
1125: begin
1126: select item_type, item_key
1127: into lv_sfl_item_type,lv_sfl_item_key
1128: from wf_items
1129: where user_key=to_char(p_transaction_id)
1130: and rownum<2;
1131: exception
1132: when no_data_found then