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 1207: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;

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

Line 1208: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;

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

Line 1209: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;

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

Line 1210: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;

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

Line 1211: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;

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

Line 1212: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;

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

Line 1346: l_save_threshold := wf_engine.threshold;

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

Line 1347: wf_engine.threshold := -1;

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

Line 1447: wf_engine.CreateProcess

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

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

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

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

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

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

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

Line 1570: wf_engine.StartProcess ( itemtype => p_wf_item_type

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

Line 1606: wf_engine.threshold := l_save_threshold;

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

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

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

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

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

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

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