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.PA_ADVERTISEMENTS_PVT dependencies on WF_ENGINE

Line 1206: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;

1202: ) IS
1203:
1204: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;
1205: l_wf_item_key NUMBER;
1206: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
1209: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
1210: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;

Line 1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;

1203:
1204: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;
1205: l_wf_item_key NUMBER;
1206: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
1209: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
1210: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
1211: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;

Line 1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;

1204: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;
1205: l_wf_item_key NUMBER;
1206: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
1209: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
1210: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
1211: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
1212: l_err_code fnd_new_messages.message_name%TYPE;

Line 1209: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;

1205: l_wf_item_key NUMBER;
1206: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
1209: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
1210: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
1211: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
1212: l_err_code fnd_new_messages.message_name%TYPE;
1213: l_err_stage VARCHAR2(2000);

Line 1210: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;

1206: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
1209: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
1210: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
1211: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
1212: l_err_code fnd_new_messages.message_name%TYPE;
1213: l_err_stage VARCHAR2(2000);
1214: l_err_stack VARCHAR2(2000);

Line 1211: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;

1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
1209: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
1210: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
1211: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
1212: l_err_code fnd_new_messages.message_name%TYPE;
1213: l_err_stage VARCHAR2(2000);
1214: l_err_stack VARCHAR2(2000);
1215:

Line 1345: l_save_threshold := wf_engine.threshold;

1341: -- Initialize the return status to success
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:
1344: -- Setting thresold value to run the process in background
1345: l_save_threshold := wf_engine.threshold;
1346: wf_engine.threshold := -1;
1347:
1348: -- get the requirement and project information to be displayed
1349: -- in the notifications

Line 1346: wf_engine.threshold := -1;

1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:
1344: -- Setting thresold value to run the process in background
1345: l_save_threshold := wf_engine.threshold;
1346: wf_engine.threshold := -1;
1347:
1348: -- get the requirement and project information to be displayed
1349: -- in the notifications
1350: OPEN get_requirement_info;

Line 1446: wf_engine.CreateProcess

1442: INTO l_wf_item_key
1443: FROM dual;
1444:
1445: -- Create the WF process
1446: wf_engine.CreateProcess
1447: ( ItemType => p_wf_item_type
1448: , ItemKey => l_wf_item_key
1449: , process => p_wf_process );
1450:

Line 1553: WF_ENGINE.SetItemAttrTextArray(itemtype => p_wf_item_type,

1549: to_char(l_tp_percent_applied_override);
1550: END IF;
1551:
1552: --SET the item attributes (these attributes were created at design time)
1553: WF_ENGINE.SetItemAttrTextArray(itemtype => p_wf_item_type,
1554: itemkey => l_wf_item_key,
1555: aname => l_set_text_attr_name_tbl,
1556: avalue => l_set_text_attr_value_tbl);
1557:

Line 1558: WF_ENGINE.SetItemAttrNumberArray(itemtype => p_wf_item_type,

1554: itemkey => l_wf_item_key,
1555: aname => l_set_text_attr_name_tbl,
1556: avalue => l_set_text_attr_value_tbl);
1557:
1558: WF_ENGINE.SetItemAttrNumberArray(itemtype => p_wf_item_type,
1559: itemkey => l_wf_item_key,
1560: aname => l_set_num_attr_name_tbl,
1561: avalue => l_set_num_attr_value_tbl);
1562:

Line 1563: WF_ENGINE.SetItemAttrDateArray(itemtype => p_wf_item_type,

1559: itemkey => l_wf_item_key,
1560: aname => l_set_num_attr_name_tbl,
1561: avalue => l_set_num_attr_value_tbl);
1562:
1563: WF_ENGINE.SetItemAttrDateArray(itemtype => p_wf_item_type,
1564: itemkey => l_wf_item_key,
1565: aname => l_set_date_attr_name_tbl,
1566: avalue => l_set_date_attr_value_tbl);
1567:

Line 1569: wf_engine.StartProcess ( itemtype => p_wf_item_type

1565: aname => l_set_date_attr_name_tbl,
1566: avalue => l_set_date_attr_value_tbl);
1567:
1568: --Start the workflow process
1569: wf_engine.StartProcess ( itemtype => p_wf_item_type
1570: ,itemkey => l_wf_item_key );
1571:
1572: -- Insert into Notifications table
1573: PA_WORKFLOW_UTILS.Insert_WF_Processes

Line 1605: wf_engine.threshold := l_save_threshold;

1601:
1602: END LOOP;--end i loop
1603:
1604: --Setting the original value
1605: wf_engine.threshold := l_save_threshold;
1606: -- 4537865 : Included Exception Block
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2265: v_assig_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2261: v_assig_id pa_project_assignments.assignment_id%type;
2262:
2263: BEGIN
2264:
2265: v_assig_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2266: itemkey => itemkey,
2267: aname => 'ASSIGNMENT_ID' );
2268:
2269: select 'Y' into v_dummy from pa_project_assignments

Line 2275: resultout := wf_engine.eng_completed||':'||'S';

2271: and STATUS_CODE in
2272: (select PROJECT_STATUS_CODE from pa_project_statuses
2273: where PROJECT_SYSTEM_STATUS_CODE = 'OPEN_ASGMT');
2274:
2275: resultout := wf_engine.eng_completed||':'||'S';
2276:
2277: Exception
2278: when others then
2279: resultout := wf_engine.eng_completed||':'||'F';

Line 2279: resultout := wf_engine.eng_completed||':'||'F';

2275: resultout := wf_engine.eng_completed||':'||'S';
2276:
2277: Exception
2278: when others then
2279: resultout := wf_engine.eng_completed||':'||'F';
2280: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
2281: , p_procedure_name => 'Check_Assignment_Open'
2282: , p_error_text => SUBSTRB(SQLERRM,1,240));
2283: --RAISE ; // commented for 7134435