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_PUB dependencies on PA_ADVERTISEMENTS_PVT

Line 176: --dbms_output.put_line('calling PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines');

172: l_adv_action_set_start_date;
173: CLOSE get_req_action_set_info;
174: END IF;
175:
176: --dbms_output.put_line('calling PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines');
177:
178: --
179: -- order the action lines
180: --

Line 181: PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines (

177:
178: --
179: -- order the action lines
180: --
181: PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines (
182: p_action_set_id => p_action_set_id
183: , p_action_set_template_flag => p_action_set_template_flag
184: , p_object_start_date => l_start_date
185: , p_action_set_status_code => l_adv_action_set_status_code

Line 419: PA_ADVERTISEMENTS_PVT.Publish_To_all(

415:
416: -- CASE 1: Publish to All
417: IF p_action_set_line_rec.action_code = 'ADVERTISEMENT_PUB_TO_ALL' THEN
418:
419: PA_ADVERTISEMENTS_PVT.Publish_To_all(
420: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
421: , p_object_id => l_object_id
422: , p_action_code => p_action_set_line_rec.action_code
423: , p_action_status_code => p_action_set_line_rec.status_code

Line 430: PA_ADVERTISEMENTS_PVT.Publish_To_Organizations(

426:
427: -- CASE 2: Publish to Starting Organization
428: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_PUB_TO_START_ORG' THEN
429:
430: PA_ADVERTISEMENTS_PVT.Publish_To_Organizations(
431: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
432: , p_object_id => l_object_id
433: , p_action_code => p_action_set_line_rec.action_code
434: , p_action_status_code => p_action_set_line_rec.status_code

Line 443: PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers(

439:
440: -- CASE 3: Publish to Staffing Manager
441: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_PUB_TO_SM' THEN
442:
443: PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers(
444: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
445: , p_object_id => l_object_id
446: , p_action_code => p_action_set_line_rec.action_code
447: , p_action_status_code => p_action_set_line_rec.status_code

Line 455: PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level(

451:
452: -- CASE 4: Escalate to Next Level
453: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_ESC_TO_NEXT_LVL' THEN
454:
455: PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level(
456: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
457: , p_action_set_line_number => p_action_set_line_rec.action_set_line_number
458: , p_action_set_id => p_action_set_line_rec.action_set_id
459: , p_action_set_line_rec_ver_num => p_action_set_line_rec.record_version_number

Line 470: PA_ADVERTISEMENTS_PVT.Send_Email(

466:
467: -- CASE 5: Send Email
468: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_EMAIL' THEN
469:
470: PA_ADVERTISEMENTS_PVT.Send_Email(
471: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
472: , p_object_id => l_object_id
473: , p_action_code => p_action_set_line_rec.action_code
474: , p_action_status_code => p_action_set_line_rec.status_code

Line 483: PA_ADVERTISEMENTS_PVT.Send_Notification(

479:
480: -- CASE 6: Send Notification to Person
481: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' THEN
482:
483: PA_ADVERTISEMENTS_PVT.Send_Notification(
484: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
485: , p_object_id => l_object_id
486: , p_action_code => p_action_set_line_rec.action_code
487: , p_action_status_code => p_action_set_line_rec.status_code

Line 498: PA_ADVERTISEMENTS_PVT.Send_Notification(

494:
495: -- CASE 7: Send Notification to Project Role
496: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE' THEN
497:
498: PA_ADVERTISEMENTS_PVT.Send_Notification(
499: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
500: , p_object_id => l_object_id
501: , p_action_code => p_action_set_line_rec.action_code
502: , p_action_status_code => p_action_set_line_rec.status_code

Line 514: PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority(

510:
511: -- CASE 8: Update Staffing Priority
512: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_UPDATE_SP' THEN
513:
514: PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority(
515: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
516: , p_object_id => l_object_id
517: , p_action_code => p_action_set_line_rec.action_code
518: , p_action_status_code => p_action_set_line_rec.status_code

Line 527: PA_ADVERTISEMENTS_PVT.Remove_Advertisement(

523:
524: -- CASE 9: Remove Advertisement
525: ELSIF p_action_set_line_rec.action_code = 'ADVERTISEMENT_REMOVE_ADV' THEN
526:
527: PA_ADVERTISEMENTS_PVT.Remove_Advertisement(
528: p_action_set_line_id => p_action_set_line_rec.action_set_line_id
529: , p_object_id => l_object_id
530: , p_action_code => p_action_set_line_rec.action_code
531: , p_action_status_code => p_action_set_line_rec.status_code

Line 680: PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines (

676: AND l_adv_action_set_status_code <> 'CLOSED')
677: AND l_adv_action_set_start_date IS NOT NULL THEN
678:
679: -- re-order the action lines and generate the new condition dates
680: PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines (
681: p_action_set_id => l_action_set_id
682: , p_action_set_template_flag => l_action_Set_template_flag
683: , p_object_start_date => p_new_object_start_date
684: , p_action_set_status_code => l_adv_action_set_status_code