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_CANDIDATE_PUB dependencies on WF_ENGINE

Line 2402: wf_engine.CreateProcess ( ItemType => p_wf_item_type,

2398: -- We now have all the values in local variables
2399: -- Create the WF process
2400:
2401: --dbms_output.put_line('Process: ' || p_wf_process);
2402: wf_engine.CreateProcess ( ItemType => p_wf_item_type,
2403: ItemKey => l_itemkey,
2404: process => p_wf_process
2405: );
2406:

Line 2411: wf_engine.SetItemAttrText

2407: -- Now set the values as appropriate in the WF attributes
2408:
2409: /* Commented for Bug 6144224
2410: -- Set Role details attributes
2411: wf_engine.SetItemAttrText
2412: ( itemtype => p_wf_item_type,
2413: itemkey => l_itemkey,
2414: aname => 'ATTR_NOMINATE_ROLE',
2415: avalue => l_role_name

Line 2418: wf_engine.SetItemAttrText

2414: aname => 'ATTR_NOMINATE_ROLE',
2415: avalue => l_role_name
2416: );
2417:
2418: wf_engine.SetItemAttrText
2419: ( itemtype => p_wf_item_type,
2420: itemkey => l_itemkey,
2421: aname => 'ATTR_DECLINED_ROLE',
2422: avalue => l_role_name

Line 2425: wf_engine.SetItemAttrText

2421: aname => 'ATTR_DECLINED_ROLE',
2422: avalue => l_role_name
2423: );
2424:
2425: wf_engine.SetItemAttrText
2426: ( itemtype => p_wf_item_type,
2427: itemkey => l_itemkey,
2428: aname => 'ATTR_CANDIDATE_ROLE',
2429: avalue => l_role_name

Line 2433: wf_engine.SetItemAttrText

2429: avalue => l_role_name
2430: );
2431: */
2432: --Added for bug 6144224 to set the Adhoc role
2433: wf_engine.SetItemAttrText
2434: ( itemtype => p_wf_item_type,
2435: itemkey => l_itemkey,
2436: aname => 'ATTR_ADHOC_ROLE',
2437: avalue => l_role_name

Line 2441: wf_engine.SetItemAttrText

2437: avalue => l_role_name
2438: );
2439:
2440: --Added for bug 6144224 to set the final number of recipients
2441: wf_engine.SetItemAttrText
2442: ( itemtype => p_wf_item_type,
2443: itemkey => l_itemkey,
2444: aname => 'NUMBER_OF_RECIPIENTS',
2445: avalue => l_count_recipients

Line 2449: wf_engine.SetItemAttrText

2445: avalue => l_count_recipients
2446: );
2447:
2448: --Added for bug 6144224 to set the loop counter
2449: wf_engine.SetItemAttrText
2450: ( itemtype => p_wf_item_type,
2451: itemkey => l_itemkey,
2452: aname => 'NF_LOOP_COUNTER',
2453: avalue => 0

Line 2458: wf_engine.SetItemAttrText

2454: );
2455:
2456: -- Set Project details attributes
2457:
2458: wf_engine.SetItemAttrText
2459: ( itemtype => p_wf_item_type,
2460: itemkey => l_itemkey,
2461: aname => 'ATTR_PROJ_NUMBER',
2462: avalue => l_projects_rec.segment1

Line 2465: wf_engine.SetItemAttrText

2461: aname => 'ATTR_PROJ_NUMBER',
2462: avalue => l_projects_rec.segment1
2463: );
2464:
2465: wf_engine.SetItemAttrText
2466: ( itemtype => p_wf_item_type,
2467: itemkey => l_itemkey,
2468: aname => 'ATTR_PROJ_NAME',
2469: avalue => l_projects_rec.name

Line 2472: wf_engine.SetItemAttrText

2468: aname => 'ATTR_PROJ_NAME',
2469: avalue => l_projects_rec.name
2470: );
2471:
2472: wf_engine.SetItemAttrText
2473: ( itemtype => p_wf_item_type,
2474: itemkey => l_itemkey,
2475: aname => 'ATTR_PROJ_ORGANIZATION',
2476: avalue => l_projects_rec.organization_name

Line 2480: wf_engine.SetItemAttrText

2476: avalue => l_projects_rec.organization_name
2477: );
2478:
2479: IF l_customer_name IS NOT NULL THEN
2480: wf_engine.SetItemAttrText
2481: ( itemtype => p_wf_item_type,
2482: itemkey => l_itemkey,
2483: aname => 'ATTR_PROJ_CUSTOMER',
2484: avalue => l_customer_name

Line 2492: wf_engine.SetItemAttrText

2488:
2489:
2490: -- Set Assignment related attributes
2491:
2492: wf_engine.SetItemAttrText
2493: ( itemtype => p_wf_item_type,
2494: itemkey => l_itemkey,
2495: aname => 'ATTR_ASGMT_NAME',
2496: avalue => l_assignments_rec.assignment_name

Line 2499: wf_engine.SetItemAttrText

2495: aname => 'ATTR_ASGMT_NAME',
2496: avalue => l_assignments_rec.assignment_name
2497: );
2498:
2499: wf_engine.SetItemAttrText
2500: ( itemtype => p_wf_item_type,
2501: itemkey => l_itemkey,
2502: aname => 'ATTR_ASGMT_NAME',
2503: avalue => l_assignments_rec.assignment_name

Line 2506: wf_engine.SetItemAttrText

2502: aname => 'ATTR_ASGMT_NAME',
2503: avalue => l_assignments_rec.assignment_name
2504: );
2505:
2506: wf_engine.SetItemAttrText
2507: ( itemtype => p_wf_item_type,
2508: itemkey => l_itemkey,
2509: aname => 'ATTR_ASGMT_DESCRIPTION',
2510: avalue => l_assignments_rec.description

Line 2513: wf_engine.SetItemAttrText

2509: aname => 'ATTR_ASGMT_DESCRIPTION',
2510: avalue => l_assignments_rec.description
2511: );
2512:
2513: wf_engine.SetItemAttrText
2514: ( itemtype => p_wf_item_type,
2515: itemkey => l_itemkey,
2516: aname => 'ATTR_ADDITIONAL_INFORMATION',
2517: avalue => l_assignments_rec.additional_information

Line 2520: wf_engine.SetItemAttrNumber

2516: aname => 'ATTR_ADDITIONAL_INFORMATION',
2517: avalue => l_assignments_rec.additional_information
2518: );
2519:
2520: wf_engine.SetItemAttrNumber
2521: ( itemtype => p_wf_item_type,
2522: itemkey => l_itemkey,
2523: aname => 'ATTR_ASGMT_DURATION',
2524: avalue => (trunc(l_assignments_rec.end_date) -

Line 2528: wf_engine.SetItemAttrNumber

2524: avalue => (trunc(l_assignments_rec.end_date) -
2525: trunc(l_assignments_rec.start_date)+1)
2526: );
2527:
2528: wf_engine.SetItemAttrNumber
2529: ( itemtype => p_wf_item_type,
2530: itemkey => l_itemkey,
2531: aname => 'ATTR_ASGMT_EFFORT',
2532: avalue => l_assignments_rec.assignment_effort

Line 2537: wf_engine.SetItemAttrText

2533: );
2534:
2535: -- Set resource related attributes
2536:
2537: wf_engine.SetItemAttrText
2538: ( itemtype => p_wf_item_type,
2539: itemkey => l_itemkey,
2540: aname => 'ATTR_CAND_NUMBER',
2541: avalue => p_candidate_number

Line 2546: wf_engine.SetItemAttrText

2542: );
2543:
2544: --dbms_output.put_line('p_status_name' || p_status_name);
2545:
2546: wf_engine.SetItemAttrText
2547: ( itemtype => p_wf_item_type,
2548: itemkey => l_itemkey,
2549: aname => 'ATTR_CAND_STATUS',
2550: avalue => p_status_name

Line 2553: wf_engine.SetItemAttrText

2549: aname => 'ATTR_CAND_STATUS',
2550: avalue => p_status_name
2551: );
2552:
2553: wf_engine.SetItemAttrText
2554: ( itemtype => p_wf_item_type,
2555: itemkey => l_itemkey,
2556: aname => 'ATTR_RESOURCE_NAME',
2557: avalue => l_resource_rec.resource_name

Line 2560: wf_engine.SetItemAttrText

2556: aname => 'ATTR_RESOURCE_NAME',
2557: avalue => l_resource_rec.resource_name
2558: );
2559:
2560: wf_engine.SetItemAttrText
2561: ( itemtype => p_wf_item_type,
2562: itemkey => l_itemkey,
2563: aname => 'ATTR_RESOURCE_ORG',
2564: avalue => l_resource_rec.resource_organization_name

Line 2570: wf_engine.SetItemAttrText

2566:
2567:
2568: -- Set project manager attributes
2569:
2570: wf_engine.SetItemAttrText
2571: ( itemtype => p_wf_item_type,
2572: itemkey => l_itemkey,
2573: aname => 'ATTR_PROJ_MANAGER',
2574: avalue => l_proj_mgr_name

Line 2583: wf_engine.SetItemAttrText

2579:
2580: l_resource_details_url :=
2581: 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode=PA_VIEW_RESOURCE_LAYOUT&addBreadCrumb=RP&paResourceId='||p_resource_id;
2582:
2583: wf_engine.SetItemAttrText
2584: ( itemtype => p_wf_item_type
2585: , itemkey => l_itemkey
2586: , aname => 'ATTR_ASGMT_DETAILS_URL_INFO'
2587: , avalue => l_asgmt_details_url

Line 2590: wf_engine.SetItemAttrText

2586: , aname => 'ATTR_ASGMT_DETAILS_URL_INFO'
2587: , avalue => l_asgmt_details_url
2588: );
2589:
2590: wf_engine.SetItemAttrText
2591: ( itemtype => p_wf_item_type
2592: , itemkey => l_itemkey
2593: , aname => 'ATTR_RESOURCE_DETAILS_URL'
2594: , avalue => l_resource_details_url

Line 2598: wf_engine.StartProcess

2594: , avalue => l_resource_details_url
2595: );
2596:
2597: -- Now start the WF process
2598: wf_engine.StartProcess
2599: ( itemtype => p_wf_item_type,
2600: itemkey => l_itemkey );
2601:
2602: -- Insert to PA tables wf process information.

Line 3282: IF (funcmode <> wf_engine.eng_run) THEN

3278: end
3279: */
3280:
3281: -- Return if WF Not Running
3282: IF (funcmode <> wf_engine.eng_run) THEN
3283: resultout := wf_engine.eng_null;
3284: RETURN;
3285: END IF;
3286:

Line 3283: resultout := wf_engine.eng_null;

3279: */
3280:
3281: -- Return if WF Not Running
3282: IF (funcmode <> wf_engine.eng_run) THEN
3283: resultout := wf_engine.eng_null;
3284: RETURN;
3285: END IF;
3286:
3287: -- Get total number of recipients

Line 3288: l_number_of_nf_rects := wf_engine.GetItemAttrNumber

3284: RETURN;
3285: END IF;
3286:
3287: -- Get total number of recipients
3288: l_number_of_nf_rects := wf_engine.GetItemAttrNumber
3289: ( itemtype => itemtype
3290: , itemkey => itemkey
3291: , aname => 'NUMBER_OF_RECIPIENTS'
3292: );

Line 3295: l_nf_loop_counter := wf_engine.getItemAttrNumber

3291: , aname => 'NUMBER_OF_RECIPIENTS'
3292: );
3293:
3294: -- Get loop counter value
3295: l_nf_loop_counter := wf_engine.getItemAttrNumber
3296: ( itemtype => itemtype
3297: , itemkey => itemkey
3298: , aname => 'NF_LOOP_COUNTER'
3299: );

Line 3302: l_role_name := wf_engine.getItemAttrText

3298: , aname => 'NF_LOOP_COUNTER'
3299: );
3300:
3301: -- Get adhoc role created for nitifications
3302: l_role_name := wf_engine.getItemAttrText
3303: ( itemtype => itemtype
3304: , itemkey => itemkey
3305: , aname => 'ATTR_ADHOC_ROLE'
3306: );

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

3309: l_nf_loop_counter := l_nf_loop_counter + 1;
3310:
3311: IF l_nf_loop_counter > l_number_of_nf_rects THEN
3312:
3313: resultout := wf_engine.eng_completed||':'||'F';
3314: RETURN;
3315: END IF;
3316:
3317: -- Get all users attached to Adhoc role

Line 3330: wf_engine.SetItemAttrText

3326: AND ROLE_ORIG_SYSTEM = 'PER'
3327: AND ROWNUM = 1;
3328:
3329: -- Set the notification roles for the 'nth' user
3330: wf_engine.SetItemAttrText
3331: ( itemtype => itemtype,
3332: itemkey => itemkey,
3333: aname => 'ATTR_NOMINATE_ROLE',
3334: avalue => l_role_name_temp

Line 3337: wf_engine.SetItemAttrText

3333: aname => 'ATTR_NOMINATE_ROLE',
3334: avalue => l_role_name_temp
3335: );
3336:
3337: wf_engine.SetItemAttrText
3338: ( itemtype => itemtype,
3339: itemkey => itemkey,
3340: aname => 'ATTR_DECLINED_ROLE',
3341: avalue => l_role_name_temp

Line 3344: wf_engine.SetItemAttrText

3340: aname => 'ATTR_DECLINED_ROLE',
3341: avalue => l_role_name_temp
3342: );
3343:
3344: wf_engine.SetItemAttrText
3345: ( itemtype => itemtype,
3346: itemkey => itemkey,
3347: aname => 'ATTR_CANDIDATE_ROLE',
3348: avalue => l_role_name_temp

Line 3352: wf_engine.SetItemAttrText

3348: avalue => l_role_name_temp
3349: );
3350:
3351: -- Set the incremented loop counter value
3352: wf_engine.SetItemAttrText
3353: ( itemtype => itemtype,
3354: itemkey => itemkey,
3355: aname => 'NF_LOOP_COUNTER',
3356: avalue => l_nf_loop_counter

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

3354: itemkey => itemkey,
3355: aname => 'NF_LOOP_COUNTER',
3356: avalue => l_nf_loop_counter
3357: );
3358: resultout := wf_engine.eng_completed||':'||'S';
3359:
3360:
3361: EXCEPTION
3362: WHEN OTHERS THEN