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_SETS

Line 17: p_action_set_id IN pa_action_sets.action_set_id%TYPE

13: -- or an advertisement action lines on a requirement that have been
14: -- inserted into pa_action_set_lines table.
15: ----------------------------------------------------------------------
16: PROCEDURE Order_Adv_Action_Lines (
17: p_action_set_id IN pa_action_sets.action_set_id%TYPE
18: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
19: , p_object_start_date IN DATE := NULL
20: , p_action_set_status_code IN pa_action_sets.status_code%TYPE := NULL
21: , p_action_set_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL

Line 18: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL

14: -- inserted into pa_action_set_lines table.
15: ----------------------------------------------------------------------
16: PROCEDURE Order_Adv_Action_Lines (
17: p_action_set_id IN pa_action_sets.action_set_id%TYPE
18: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
19: , p_object_start_date IN DATE := NULL
20: , p_action_set_status_code IN pa_action_sets.status_code%TYPE := NULL
21: , p_action_set_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
22: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 20: , p_action_set_status_code IN pa_action_sets.status_code%TYPE := NULL

16: PROCEDURE Order_Adv_Action_Lines (
17: p_action_set_id IN pa_action_sets.action_set_id%TYPE
18: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
19: , p_object_start_date IN DATE := NULL
20: , p_action_set_status_code IN pa_action_sets.status_code%TYPE := NULL
21: , p_action_set_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
22: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: );
24:

Line 21: , p_action_set_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL

17: p_action_set_id IN pa_action_sets.action_set_id%TYPE
18: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
19: , p_object_start_date IN DATE := NULL
20: , p_action_set_status_code IN pa_action_sets.status_code%TYPE := NULL
21: , p_action_set_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
22: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: );
24:
25: ----------------------------------------------------------------------

Line 34: , p_object_id IN pa_action_sets.object_id%TYPE

30: -- Advertise to everyone
31: ----------------------------------------------------------------------
32: PROCEDURE Publish_To_All (
33: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
34: , p_object_id IN pa_action_sets.object_id%TYPE
35: , p_action_code IN pa_action_set_lines.action_code%TYPE
36: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
37: , p_insert_audit_flag IN VARCHAR2 := 'T'
38: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 51: , p_object_id IN pa_action_sets.object_id%TYPE

47: -- organization in the organization hierarchy.
48: ----------------------------------------------------------------------
49: PROCEDURE Publish_To_Organizations (
50: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
51: , p_object_id IN pa_action_sets.object_id%TYPE
52: , p_action_code IN pa_action_set_lines.action_code%TYPE
53: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
54: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE
55: , p_starting_organization_id IN hr_organization_units.organization_id%TYPE := NULL

Line 71: , p_action_set_id IN pa_action_sets.action_set_id%TYPE

67: ----------------------------------------------------------------------
68: PROCEDURE Escalate_to_Next_Level (
69: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
70: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE
71: , p_action_set_id IN pa_action_sets.action_set_id%TYPE
72: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
73: , p_object_id IN pa_action_sets.object_id%TYPE
74: , p_action_code IN pa_action_set_lines.action_code%TYPE
75: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

Line 73: , p_object_id IN pa_action_sets.object_id%TYPE

69: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
70: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE
71: , p_action_set_id IN pa_action_sets.action_set_id%TYPE
72: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
73: , p_object_id IN pa_action_sets.object_id%TYPE
74: , p_action_code IN pa_action_set_lines.action_code%TYPE
75: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
76: , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type
77: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 90: , p_object_id IN pa_action_sets.object_id%TYPE

86: -- Advertise to staffing managers of the specified organization.
87: ----------------------------------------------------------------------
88: PROCEDURE Publish_To_Staffing_Managers (
89: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
90: , p_object_id IN pa_action_sets.object_id%TYPE
91: , p_action_code IN pa_action_set_lines.action_code%TYPE
92: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
93: , p_organization_id IN hr_organization_units.organization_id%TYPE
94: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 108: , p_object_id IN pa_action_sets.object_id%TYPE

104: -- Send the advertisement email to a specific email address.
105: ----------------------------------------------------------------------
106: PROCEDURE Send_Email (
107: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
108: , p_object_id IN pa_action_sets.object_id%TYPE
109: , p_action_code IN pa_action_set_lines.action_code%TYPE
110: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
111: , p_email_address IN VARCHAR2
112: , p_project_id IN pa_projects_all.project_id%TYPE

Line 127: , p_object_id IN pa_action_sets.object_id%TYPE

123: -- on the project.
124: ----------------------------------------------------------------------
125: PROCEDURE Send_Notification (
126: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
127: , p_object_id IN pa_action_sets.object_id%TYPE
128: , p_action_code IN pa_action_set_lines.action_code%TYPE
129: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
130: , p_method IN VARCHAR2
131: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM

Line 167: , p_object_id IN pa_action_sets.object_id%TYPE

163: -- Update the staffing priority of the requirement.
164: ----------------------------------------------------------------------
165: PROCEDURE Update_Staffing_Priority (
166: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
167: , p_object_id IN pa_action_sets.object_id%TYPE
168: , p_action_code IN pa_action_set_lines.action_code%TYPE
169: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
170: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
171: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE

Line 185: , p_object_id IN pa_action_sets.object_id%TYPE

181: -- Remove the visibility or advertisement of the requirement.
182: ----------------------------------------------------------------------
183: PROCEDURE Remove_Advertisement (
184: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
185: , p_object_id IN pa_action_sets.object_id%TYPE
186: , p_action_code IN pa_action_set_lines.action_code%TYPE
187: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
188: , p_project_id IN pa_projects_all.project_id%TYPE
189: , p_insert_audit_flag IN VARCHAR2 := 'T'