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_WORKFLOW_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1210: ln_activityId wf_item_activity_statuses.process_activity%type;

1206: p_page_applicationId out nocopy varchar2,
1207: p_additional_params out nocopy varchar2 )is
1208: -- local variables
1209: lv_procedure_name varchar2(30) default 'getPageDetails';
1210: ln_activityId wf_item_activity_statuses.process_activity%type;
1211: lv_page wf_item_attribute_values.text_value%type;
1212: lv_page_type wf_item_attribute_values.text_value%type;
1213: ln_page_applicationId wf_item_attribute_values.number_value%type;
1214: lv_additional_params wf_item_attribute_values.text_value%type;

Line 1228: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity of type FORM'||lv_procedure_name||'with itemtype:', 3);

1224: -- of type 'FORM'
1225: begin
1226: if(hr_utility.debug_enabled) then
1227: -- write debug statements
1228: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity of type FORM'||lv_procedure_name||'with itemtype:', 3);
1229: end if;
1230:
1231: -- Fix for bug 3719338
1232: SELECT process_activity

Line 1236: FROM WF_ITEM_ACTIVITY_STATUSES IAS

1232: SELECT process_activity
1233: into ln_activityId
1234: from
1235: (select process_activity
1236: FROM WF_ITEM_ACTIVITY_STATUSES IAS
1237: WHERE ias.item_type = p_item_type
1238: and ias.item_key = p_item_key
1239: and ias.activity_status = 'NOTIFIED'
1240: and ias.process_activity in (

Line 1265: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES of type FORM for itemtype:'|| p_item_type||' and item key:'||p_item_key, 4);

1261: exception
1262: when no_data_found then
1263: if(hr_utility.debug_enabled) then
1264: -- write debug statements
1265: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES of type FORM for itemtype:'|| p_item_type||' and item key:'||p_item_key, 4);
1266: end if;
1267: ln_activityId := null;
1268: when others then
1269: ln_activityId := null;

Line 1380: lv_item_type wf_item_activity_statuses.item_type%type;

1376: p_ntfId IN NUMBER
1377: ,p_itemType OUT NOCOPY VARCHAR2
1378: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
1379: c_proc varchar2(30) default 'get_item_type_and_key';
1380: lv_item_type wf_item_activity_statuses.item_type%type;
1381: lv_item_key wf_item_activity_statuses.item_key%type;
1382: lv_activity_id wf_item_activity_statuses.process_activity%type;
1383: begin
1384: g_debug := hr_utility.debug_enabled;

Line 1381: lv_item_key wf_item_activity_statuses.item_key%type;

1377: ,p_itemType OUT NOCOPY VARCHAR2
1378: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
1379: c_proc varchar2(30) default 'get_item_type_and_key';
1380: lv_item_type wf_item_activity_statuses.item_type%type;
1381: lv_item_key wf_item_activity_statuses.item_key%type;
1382: lv_activity_id wf_item_activity_statuses.process_activity%type;
1383: begin
1384: g_debug := hr_utility.debug_enabled;
1385: if g_debug then

Line 1382: lv_activity_id wf_item_activity_statuses.process_activity%type;

1378: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
1379: c_proc varchar2(30) default 'get_item_type_and_key';
1380: lv_item_type wf_item_activity_statuses.item_type%type;
1381: lv_item_key wf_item_activity_statuses.item_key%type;
1382: lv_activity_id wf_item_activity_statuses.process_activity%type;
1383: begin
1384: g_debug := hr_utility.debug_enabled;
1385: if g_debug then
1386: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1393: from wf_item_activity_statuses

1389: -- get the itemtype and item key for the notification id
1390: begin
1391: select item_type, item_key, process_activity
1392: into lv_item_type, lv_item_key,lv_activity_id
1393: from wf_item_activity_statuses
1394: where notification_id = p_ntfid;
1395: exception
1396: when no_data_found then
1397: begin

Line 1430: lv_item_type wf_item_activity_statuses.item_type%type;

1426: display_type IN Varchar2,
1427: document IN OUT NOCOPY varchar2,
1428: document_type IN OUT NOCOPY Varchar2) is
1429: c_proc varchar2(30) default 'GetItemAttrText';
1430: lv_item_type wf_item_activity_statuses.item_type%type;
1431: lv_item_key wf_item_activity_statuses.item_key%type;
1432: lv_checkProfile VARCHAR2(10);
1433: lv_profileValue VARCHAR2(1);
1434: lv_status hr_api_transactions.status%type;

Line 1431: lv_item_key wf_item_activity_statuses.item_key%type;

1427: document IN OUT NOCOPY varchar2,
1428: document_type IN OUT NOCOPY Varchar2) is
1429: c_proc varchar2(30) default 'GetItemAttrText';
1430: lv_item_type wf_item_activity_statuses.item_type%type;
1431: lv_item_key wf_item_activity_statuses.item_key%type;
1432: lv_checkProfile VARCHAR2(10);
1433: lv_profileValue VARCHAR2(1);
1434: lv_status hr_api_transactions.status%type;
1435: lv_link_label wf_message_attributes_vl.display_name%type;

Line 1865: lv_item_type wf_item_activity_statuses.item_type%type;

1861: document IN OUT NOCOPY varchar2,
1862: document_type IN OUT NOCOPY Varchar2)
1863: is
1864: c_proc varchar2(30) default 'getProcessDisplayName';
1865: lv_item_type wf_item_activity_statuses.item_type%type;
1866: lv_item_key wf_item_activity_statuses.item_key%type;
1867:
1868: begin
1869: g_debug := hr_utility.debug_enabled;

Line 1866: lv_item_key wf_item_activity_statuses.item_key%type;

1862: document_type IN OUT NOCOPY Varchar2)
1863: is
1864: c_proc varchar2(30) default 'getProcessDisplayName';
1865: lv_item_type wf_item_activity_statuses.item_type%type;
1866: lv_item_key wf_item_activity_statuses.item_key%type;
1867:
1868: begin
1869: g_debug := hr_utility.debug_enabled;
1870: if g_debug then

Line 1908: lv_item_type wf_item_activity_statuses.item_type%type;

1904: document IN OUT NOCOPY varchar2,
1905: document_type IN OUT NOCOPY Varchar2)
1906: is
1907: c_proc varchar2(30) default 'getApprovalMsgSubject';
1908: lv_item_type wf_item_activity_statuses.item_type%type;
1909: lv_item_key wf_item_activity_statuses.item_key%type;
1910: l_creator_person_id per_people_f.person_id%type;
1911: l_creator_disp_name wf_users.display_name%type;
1912: l_creator_username wf_users.name%type;

Line 1909: lv_item_key wf_item_activity_statuses.item_key%type;

1905: document_type IN OUT NOCOPY Varchar2)
1906: is
1907: c_proc varchar2(30) default 'getApprovalMsgSubject';
1908: lv_item_type wf_item_activity_statuses.item_type%type;
1909: lv_item_key wf_item_activity_statuses.item_key%type;
1910: l_creator_person_id per_people_f.person_id%type;
1911: l_creator_disp_name wf_users.display_name%type;
1912: l_creator_username wf_users.name%type;
1913: l_current_person_id per_people_f.person_id%type;