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 14: -- inserted into pa_action_set_lines table.

10: --
11: -- Purpose
12: -- Order the action lines of an advertisement action set
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

Line 33: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

29: -- Purpose
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'

Line 35: , p_action_code IN pa_action_set_lines.action_code%TYPE

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
39: );

Line 36: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

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
39: );
40:

Line 50: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

46: -- Advertise to all resources in organizations under the starting
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

Line 52: , p_action_code IN pa_action_set_lines.action_code%TYPE

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
56: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 53: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

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
56: , p_insert_audit_flag IN VARCHAR2 := 'T'
57: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 69: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

65: -- Advertise to all resources in organizations under a higher starting
66: -- organization in the organization hierarchy.
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

Line 70: , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE

66: -- organization in the organization hierarchy.
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

Line 72: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE

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
76: , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type

Line 74: , p_action_code IN pa_action_set_lines.action_code%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'
78: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 75: , p_action_status_code IN pa_action_set_lines.status_code%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'
78: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
79: );

Line 89: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

85: -- Purpose
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

Line 91: , p_action_code IN pa_action_set_lines.action_code%TYPE

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'
95: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 92: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

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'
95: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: );

Line 107: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

103: -- Purpose
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

Line 109: , p_action_code IN pa_action_set_lines.action_code%TYPE

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
113: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 110: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

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
113: , p_insert_audit_flag IN VARCHAR2 := 'T'
114: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 126: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

122: -- Send the advertisement notification to a specific person or role
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

Line 128: , p_action_code IN pa_action_set_lines.action_code%TYPE

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
132: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 129: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

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
132: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
133: , p_project_id IN pa_project_assignments.project_id%TYPE

Line 146: p_action_code IN pa_action_set_lines.action_code%TYPE

142: -- Purpose
143: -- Start Workflow process to send advertisement notification
144: ----------------------------------------------------------------------
145: PROCEDURE Start_Adv_Notification_WF (
146: p_action_code IN pa_action_set_lines.action_code%TYPE
147: , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL
148: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
149: , p_wf_user_name IN VARCHAR2 := NULL
150: , p_wf_process IN VARCHAR2

Line 166: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

162: -- Purpose
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

Line 168: , p_action_code IN pa_action_set_lines.action_code%TYPE

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
172: , p_insert_audit_flag IN VARCHAR2 := 'T'

Line 169: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

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
172: , p_insert_audit_flag IN VARCHAR2 := 'T'
173: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 184: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

180: -- Purpose
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

Line 186: , p_action_code IN pa_action_set_lines.action_code%TYPE

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'
190: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 187: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

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'
190: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191: );