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 PA_ACTION_SET_LINES

Line 12: -- inserted into pa_action_set_lines table.

8: --
9: -- Purpose
10: -- Order the action lines of an advertisement action set
11: -- or an advertisement action lines on a requirement that have been
12: -- inserted into pa_action_set_lines table.
13: ----------------------------------------------------------------------
14: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
15:
16: PROCEDURE Order_Adv_Action_Lines (

Line 115: FROM pa_action_set_lines asl,

111: l_condition_code_tbl,
112: l_condition_attribute1_tbl,
113: l_condition_attribute2_tbl,
114: l_action_line_cond_id_tbl
115: FROM pa_action_set_lines asl,
116: pa_action_set_line_cond aslc,
117: pa_action_sets asets,
118: pa_action_sets asets2
119: WHERE asets2.action_set_id = p_action_set_id

Line 148: FROM pa_action_set_lines asl,

144: l_condition_code_tbl,
145: l_condition_attribute1_tbl,
146: l_condition_attribute2_tbl,
147: l_action_line_cond_id_tbl
148: FROM pa_action_set_lines asl,
149: pa_action_set_line_cond aslc
150: WHERE asl.action_set_id = p_action_set_id
151: AND asl.action_set_line_id = aslc.action_set_line_id;
152:

Line 308: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

304: -- Purpose
305: -- Advertise to everyone
306: ----------------------------------------------------------------------
307: PROCEDURE Publish_To_All (
308: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
309: , p_object_id IN pa_action_sets.object_id%TYPE
310: , p_action_code IN pa_action_set_lines.action_code%TYPE
311: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
312: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 310: , p_action_code IN pa_action_set_lines.action_code%TYPE

306: ----------------------------------------------------------------------
307: PROCEDURE Publish_To_All (
308: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
309: , p_object_id IN pa_action_sets.object_id%TYPE
310: , p_action_code IN pa_action_set_lines.action_code%TYPE
311: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
312: , p_insert_audit_flag IN VARCHAR2 := 'T'
313: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
314: ) IS

Line 311: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

307: PROCEDURE Publish_To_All (
308: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
309: , p_object_id IN pa_action_sets.object_id%TYPE
310: , p_action_code IN pa_action_set_lines.action_code%TYPE
311: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
312: , p_insert_audit_flag IN VARCHAR2 := 'T'
313: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
314: ) IS
315:

Line 375: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

371: -- Advertise to all resources in organizations under the starting
372: -- organization in the organization hierarchy.
373: ----------------------------------------------------------------------
374: PROCEDURE Publish_To_Organizations (
375: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
376: , p_object_id IN pa_action_sets.object_id%TYPE
377: , p_action_code IN pa_action_set_lines.action_code%TYPE
378: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
379: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE

Line 377: , p_action_code IN pa_action_set_lines.action_code%TYPE

373: ----------------------------------------------------------------------
374: PROCEDURE Publish_To_Organizations (
375: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
376: , p_object_id IN pa_action_sets.object_id%TYPE
377: , p_action_code IN pa_action_set_lines.action_code%TYPE
378: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
379: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE
380: , p_starting_organization_id IN hr_organization_units.organization_id%TYPE := NULL
381: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 378: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

374: PROCEDURE Publish_To_Organizations (
375: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
376: , p_object_id IN pa_action_sets.object_id%TYPE
377: , p_action_code IN pa_action_set_lines.action_code%TYPE
378: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
379: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE
380: , p_starting_organization_id IN hr_organization_units.organization_id%TYPE := NULL
381: , p_insert_audit_flag IN VARCHAR2 := 'T'
382: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 507: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

503: -- Advertise to all resources in organizations under a higher starting
504: -- organization in the organization hierarchy.
505: ----------------------------------------------------------------------
506: PROCEDURE Escalate_to_Next_Level (
507: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
508: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE
509: , p_action_set_id IN pa_action_sets.action_set_id%TYPE
510: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
511: , p_object_id IN pa_action_sets.object_id%TYPE

Line 508: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE

504: -- organization in the organization hierarchy.
505: ----------------------------------------------------------------------
506: PROCEDURE Escalate_to_Next_Level (
507: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
508: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE
509: , p_action_set_id IN pa_action_sets.action_set_id%TYPE
510: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
511: , p_object_id IN pa_action_sets.object_id%TYPE
512: , p_action_code IN pa_action_set_lines.action_code%TYPE

Line 510: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE

506: PROCEDURE Escalate_to_Next_Level (
507: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
508: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE
509: , p_action_set_id IN pa_action_sets.action_set_id%TYPE
510: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
511: , p_object_id IN pa_action_sets.object_id%TYPE
512: , p_action_code IN pa_action_set_lines.action_code%TYPE
513: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
514: , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type

Line 512: , p_action_code IN pa_action_set_lines.action_code%TYPE

508: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE
509: , p_action_set_id IN pa_action_sets.action_set_id%TYPE
510: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
511: , p_object_id IN pa_action_sets.object_id%TYPE
512: , p_action_code IN pa_action_set_lines.action_code%TYPE
513: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
514: , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type
515: , p_insert_audit_flag IN VARCHAR2 := 'T'
516: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 513: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

509: , p_action_set_id IN pa_action_sets.action_set_id%TYPE
510: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
511: , p_object_id IN pa_action_sets.object_id%TYPE
512: , p_action_code IN pa_action_set_lines.action_code%TYPE
513: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
514: , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type
515: , p_insert_audit_flag IN VARCHAR2 := 'T'
516: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
517: ) IS

Line 599: FROM pa_action_set_lines

595: -- and action set line number is the maximum number less than the
596: -- current action line number
597: SELECT to_number(action_attribute1), to_number(action_attribute2) into
598: l_org_hierarchy_version_id, l_start_org_id
599: FROM pa_action_set_lines
600: WHERE action_set_id = p_action_set_id
601: AND action_set_line_number = (
602: SELECT MAX(action_set_line_number)
603: FROM pa_action_set_lines

Line 603: FROM pa_action_set_lines

599: FROM pa_action_set_lines
600: WHERE action_set_id = p_action_set_id
601: AND action_set_line_number = (
602: SELECT MAX(action_set_line_number)
603: FROM pa_action_set_lines
604: WHERE (action_code = 'ADVERTISEMENT_PUB_TO_START_ORG'
605: OR action_code = 'ADVERTISEMENT_ESC_TO_NEXT_LVL')
606: AND (status_code = 'PENDING'
607: OR status_code = 'COMPLETE')

Line 720: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

716: -- Purpose
717: -- Advertise to staffing managers of the specified organization.
718: ----------------------------------------------------------------------
719: PROCEDURE Publish_To_Staffing_Managers (
720: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
721: , p_object_id IN pa_action_sets.object_id%TYPE
722: , p_action_code IN pa_action_set_lines.action_code%TYPE
723: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
724: , p_organization_id IN hr_organization_units.organization_id%TYPE

Line 722: , p_action_code IN pa_action_set_lines.action_code%TYPE

718: ----------------------------------------------------------------------
719: PROCEDURE Publish_To_Staffing_Managers (
720: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
721: , p_object_id IN pa_action_sets.object_id%TYPE
722: , p_action_code IN pa_action_set_lines.action_code%TYPE
723: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
724: , p_organization_id IN hr_organization_units.organization_id%TYPE
725: , p_insert_audit_flag IN VARCHAR2 := 'T'
726: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 723: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

719: PROCEDURE Publish_To_Staffing_Managers (
720: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
721: , p_object_id IN pa_action_sets.object_id%TYPE
722: , p_action_code IN pa_action_set_lines.action_code%TYPE
723: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
724: , p_organization_id IN hr_organization_units.organization_id%TYPE
725: , p_insert_audit_flag IN VARCHAR2 := 'T'
726: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
727: ) IS

Line 858: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

854: -- Purpose
855: -- Send the advertisement email to a specific email address.
856: ----------------------------------------------------------------------
857: PROCEDURE Send_Email (
858: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
859: , p_object_id IN pa_action_sets.object_id%TYPE
860: , p_action_code IN pa_action_set_lines.action_code%TYPE
861: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
862: , p_email_address IN VARCHAR2

Line 860: , p_action_code IN pa_action_set_lines.action_code%TYPE

856: ----------------------------------------------------------------------
857: PROCEDURE Send_Email (
858: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
859: , p_object_id IN pa_action_sets.object_id%TYPE
860: , p_action_code IN pa_action_set_lines.action_code%TYPE
861: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
862: , p_email_address IN VARCHAR2
863: , p_project_id IN pa_projects_all.project_id%TYPE
864: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 861: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

857: PROCEDURE Send_Email (
858: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
859: , p_object_id IN pa_action_sets.object_id%TYPE
860: , p_action_code IN pa_action_set_lines.action_code%TYPE
861: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
862: , p_email_address IN VARCHAR2
863: , p_project_id IN pa_projects_all.project_id%TYPE
864: , p_insert_audit_flag IN VARCHAR2 := 'T'
865: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 999: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

995: -- Send the advertisement notification to a specific person or role
996: -- on the project.
997: ----------------------------------------------------------------------
998: PROCEDURE Send_Notification (
999: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1000: , p_object_id IN pa_action_sets.object_id%TYPE
1001: , p_action_code IN pa_action_set_lines.action_code%TYPE
1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1003: , p_method IN VARCHAR2

Line 1001: , p_action_code IN pa_action_set_lines.action_code%TYPE

997: ----------------------------------------------------------------------
998: PROCEDURE Send_Notification (
999: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1000: , p_object_id IN pa_action_sets.object_id%TYPE
1001: , p_action_code IN pa_action_set_lines.action_code%TYPE
1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1003: , p_method IN VARCHAR2
1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

998: PROCEDURE Send_Notification (
999: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1000: , p_object_id IN pa_action_sets.object_id%TYPE
1001: , p_action_code IN pa_action_set_lines.action_code%TYPE
1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1003: , p_method IN VARCHAR2
1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
1006: , p_project_id IN pa_project_assignments.project_id%TYPE

Line 1193: p_action_code IN pa_action_set_lines.action_code%TYPE

1189: -- Purpose
1190: -- Start Workflow process to send advertisement notification
1191: ----------------------------------------------------------------------
1192: PROCEDURE Start_Adv_Notification_WF (
1193: p_action_code IN pa_action_set_lines.action_code%TYPE
1194: , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL
1195: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1196: , p_wf_user_name IN VARCHAR2 := NULL
1197: , p_wf_process IN VARCHAR2

Line 1625: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

1621: -- Purpose
1622: -- Update the staffing priority of the requirement.
1623: ----------------------------------------------------------------------
1624: PROCEDURE Update_Staffing_Priority (
1625: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1626: , p_object_id IN pa_action_sets.object_id%TYPE
1627: , p_action_code IN pa_action_set_lines.action_code%TYPE
1628: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1629: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE

Line 1627: , p_action_code IN pa_action_set_lines.action_code%TYPE

1623: ----------------------------------------------------------------------
1624: PROCEDURE Update_Staffing_Priority (
1625: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1626: , p_object_id IN pa_action_sets.object_id%TYPE
1627: , p_action_code IN pa_action_set_lines.action_code%TYPE
1628: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1629: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
1630: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE
1631: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 1628: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

1624: PROCEDURE Update_Staffing_Priority (
1625: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1626: , p_object_id IN pa_action_sets.object_id%TYPE
1627: , p_action_code IN pa_action_set_lines.action_code%TYPE
1628: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1629: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
1630: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE
1631: , p_insert_audit_flag IN VARCHAR2 := 'T'
1632: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1757: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

1753: -- Purpose
1754: -- Remove the visibility or advertisement of the requirement.
1755: ----------------------------------------------------------------------
1756: PROCEDURE Remove_Advertisement (
1757: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1758: , p_object_id IN pa_action_sets.object_id%TYPE
1759: , p_action_code IN pa_action_set_lines.action_code%TYPE
1760: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1761: , p_project_id IN pa_projects_all.project_id%TYPE

Line 1759: , p_action_code IN pa_action_set_lines.action_code%TYPE

1755: ----------------------------------------------------------------------
1756: PROCEDURE Remove_Advertisement (
1757: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1758: , p_object_id IN pa_action_sets.object_id%TYPE
1759: , p_action_code IN pa_action_set_lines.action_code%TYPE
1760: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1761: , p_project_id IN pa_projects_all.project_id%TYPE
1762: , p_insert_audit_flag IN VARCHAR2 := 'T'
1763: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1760: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

1756: PROCEDURE Remove_Advertisement (
1757: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1758: , p_object_id IN pa_action_sets.object_id%TYPE
1759: , p_action_code IN pa_action_set_lines.action_code%TYPE
1760: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1761: , p_project_id IN pa_projects_all.project_id%TYPE
1762: , p_insert_audit_flag IN VARCHAR2 := 'T'
1763: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1764: ) IS

Line 1825: pa_action_set_lines asl,

1821: -- of this Remove Advertisement line and are not deleted
1822: CURSOR get_all_reversed_lines IS
1823: SELECT asl.action_set_line_id, asl.action_code, asa.audit_attribute, asa.audit_display_attribute, 'COMPLETE'
1824: FROM pa_action_set_line_aud asa,
1825: pa_action_set_lines asl,
1826: pa_action_set_line_cond aslc
1827: WHERE asa.object_id = p_object_id
1828: AND asa.object_type = 'OPEN_ASSIGNMENT'
1829: AND asa.action_set_type_code = 'ADVERTISEMENT'