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.

[Home] [Help]

APPS.HR_WORKFLOW_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1252: ln_activityId wf_item_activity_statuses.process_activity%type;

1248: p_page_applicationId out nocopy varchar2,
1249: p_additional_params out nocopy varchar2 )is
1250: -- local variables
1251: lv_procedure_name varchar2(30) default 'getPageDetails';
1252: ln_activityId wf_item_activity_statuses.process_activity%type;
1253: lv_page wf_item_attribute_values.text_value%type;
1254: lv_page_type wf_item_attribute_values.text_value%type;
1255: ln_page_applicationId wf_item_attribute_values.number_value%type;
1256: lv_additional_params wf_item_attribute_values.text_value%type;

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

1266: -- of type 'FORM'
1267: begin
1268: if(hr_utility.debug_enabled) then
1269: -- write debug statements
1270: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity of type FORM'||lv_procedure_name||'with itemtype:', 3);
1271: end if;
1272:
1273: -- Fix for bug 3719338
1274: SELECT process_activity

Line 1278: FROM WF_ITEM_ACTIVITY_STATUSES IAS

1274: SELECT process_activity
1275: into ln_activityId
1276: from
1277: (select process_activity
1278: FROM WF_ITEM_ACTIVITY_STATUSES IAS
1279: WHERE ias.item_type = p_item_type
1280: and ias.item_key = p_item_key
1281: and ias.activity_status = 'NOTIFIED'
1282: and ias.process_activity in (

Line 1307: 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);

1303: exception
1304: when no_data_found then
1305: if(hr_utility.debug_enabled) then
1306: -- write debug statements
1307: 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);
1308: end if;
1309: ln_activityId := null;
1310: when others then
1311: ln_activityId := null;

Line 1422: lv_item_type wf_item_activity_statuses.item_type%type;

1418: p_ntfId IN NUMBER
1419: ,p_itemType OUT NOCOPY VARCHAR2
1420: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
1421: c_proc varchar2(30) default 'get_item_type_and_key';
1422: lv_item_type wf_item_activity_statuses.item_type%type;
1423: lv_item_key wf_item_activity_statuses.item_key%type;
1424: lv_activity_id wf_item_activity_statuses.process_activity%type;
1425: begin
1426: g_debug := hr_utility.debug_enabled;

Line 1423: lv_item_key wf_item_activity_statuses.item_key%type;

1419: ,p_itemType OUT NOCOPY VARCHAR2
1420: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
1421: c_proc varchar2(30) default 'get_item_type_and_key';
1422: lv_item_type wf_item_activity_statuses.item_type%type;
1423: lv_item_key wf_item_activity_statuses.item_key%type;
1424: lv_activity_id wf_item_activity_statuses.process_activity%type;
1425: begin
1426: g_debug := hr_utility.debug_enabled;
1427: if g_debug then

Line 1424: lv_activity_id wf_item_activity_statuses.process_activity%type;

1420: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
1421: c_proc varchar2(30) default 'get_item_type_and_key';
1422: lv_item_type wf_item_activity_statuses.item_type%type;
1423: lv_item_key wf_item_activity_statuses.item_key%type;
1424: lv_activity_id wf_item_activity_statuses.process_activity%type;
1425: begin
1426: g_debug := hr_utility.debug_enabled;
1427: if g_debug then
1428: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1435: from wf_item_activity_statuses

1431: -- get the itemtype and item key for the notification id
1432: begin
1433: select item_type, item_key, process_activity
1434: into lv_item_type, lv_item_key,lv_activity_id
1435: from wf_item_activity_statuses
1436: where notification_id = p_ntfid;
1437: exception
1438: when no_data_found then
1439: begin

Line 1472: lv_item_type wf_item_activity_statuses.item_type%type;

1468: display_type IN Varchar2,
1469: document IN OUT NOCOPY varchar2,
1470: document_type IN OUT NOCOPY Varchar2) is
1471: c_proc varchar2(30) default 'GetItemAttrText';
1472: lv_item_type wf_item_activity_statuses.item_type%type;
1473: lv_item_key wf_item_activity_statuses.item_key%type;
1474: lv_checkProfile VARCHAR2(10);
1475: lv_profileValue VARCHAR2(1);
1476: lv_status hr_api_transactions.status%type;

Line 1473: lv_item_key wf_item_activity_statuses.item_key%type;

1469: document IN OUT NOCOPY varchar2,
1470: document_type IN OUT NOCOPY Varchar2) is
1471: c_proc varchar2(30) default 'GetItemAttrText';
1472: lv_item_type wf_item_activity_statuses.item_type%type;
1473: lv_item_key wf_item_activity_statuses.item_key%type;
1474: lv_checkProfile VARCHAR2(10);
1475: lv_profileValue VARCHAR2(1);
1476: lv_status hr_api_transactions.status%type;
1477: lv_link_label wf_message_attributes_vl.display_name%type;

Line 1907: lv_item_type wf_item_activity_statuses.item_type%type;

1903: document IN OUT NOCOPY varchar2,
1904: document_type IN OUT NOCOPY Varchar2)
1905: is
1906: c_proc varchar2(30) default 'getProcessDisplayName';
1907: lv_item_type wf_item_activity_statuses.item_type%type;
1908: lv_item_key wf_item_activity_statuses.item_key%type;
1909:
1910: begin
1911: g_debug := hr_utility.debug_enabled;

Line 1908: lv_item_key wf_item_activity_statuses.item_key%type;

1904: document_type IN OUT NOCOPY Varchar2)
1905: is
1906: c_proc varchar2(30) default 'getProcessDisplayName';
1907: lv_item_type wf_item_activity_statuses.item_type%type;
1908: lv_item_key wf_item_activity_statuses.item_key%type;
1909:
1910: begin
1911: g_debug := hr_utility.debug_enabled;
1912: if g_debug then

Line 1950: lv_item_type wf_item_activity_statuses.item_type%type;

1946: document IN OUT NOCOPY varchar2,
1947: document_type IN OUT NOCOPY Varchar2)
1948: is
1949: c_proc varchar2(30) default 'getApprovalMsgSubject';
1950: lv_item_type wf_item_activity_statuses.item_type%type;
1951: lv_item_key wf_item_activity_statuses.item_key%type;
1952: l_creator_person_id per_people_f.person_id%type;
1953: l_creator_disp_name wf_users.display_name%type;
1954: l_creator_username wf_users.name%type;

Line 1951: lv_item_key wf_item_activity_statuses.item_key%type;

1947: document_type IN OUT NOCOPY Varchar2)
1948: is
1949: c_proc varchar2(30) default 'getApprovalMsgSubject';
1950: lv_item_type wf_item_activity_statuses.item_type%type;
1951: lv_item_key wf_item_activity_statuses.item_key%type;
1952: l_creator_person_id per_people_f.person_id%type;
1953: l_creator_disp_name wf_users.display_name%type;
1954: l_creator_username wf_users.name%type;
1955: l_current_person_id per_people_f.person_id%type;