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 635: -- check the wf_items table

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

Line 639: from wf_items

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

Line 671: lv_item_key wf_items.item_key%type;

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

Line 737: lv_item_type wf_items.item_type%type;

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

Line 738: lv_item_key wf_items.item_type%type;

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

Line 740: lv_process_name wf_items.root_activity%type;

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

Line 990: WF_ITEMS WI

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

Line 1058: lv_sfl_item_type wf_items.item_type%type;

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

Line 1059: lv_sfl_item_key wf_items.item_key%type;

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

Line 1073: from wf_items

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

Line 1112: lv_sfl_item_type wf_items.item_type%type;

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

Line 1113: lv_sfl_item_key wf_items.item_key%type;

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

Line 1129: from wf_items

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