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: ----------------------------------------------------------------------
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 (
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: 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 (
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: ) IS
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: ) IS
24:
25:

Line 43: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;

39: l_action_line_id_tbl2 pa_action_set_utils.number_tbl_type;
40: l_condition_date_tbl2 pa_action_set_utils.date_tbl_type;
41: l_action_line_number_tbl2 pa_action_set_utils.number_tbl_type;
42: l_start_date pa_project_assignments.start_date%TYPE;
43: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
44: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
45: l_action_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
46: l_action_line_cond_id_tbl2 pa_action_set_utils.number_tbl_type;
47: l_return_status VARCHAR2(1);

Line 44: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;

40: l_condition_date_tbl2 pa_action_set_utils.date_tbl_type;
41: l_action_line_number_tbl2 pa_action_set_utils.number_tbl_type;
42: l_start_date pa_project_assignments.start_date%TYPE;
43: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
44: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
45: l_action_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
46: l_action_line_cond_id_tbl2 pa_action_set_utils.number_tbl_type;
47: l_return_status VARCHAR2(1);
48:

Line 55: pa_action_sets ast

51: SELECT pa.start_date,
52: ast.status_code,
53: ast.actual_start_date
54: FROM pa_project_assignments pa,
55: pa_action_sets ast
56: WHERE pa.assignment_id = ast.object_id
57: AND ast.action_set_id = p_action_set_id;
58:
59: BEGIN

Line 117: pa_action_sets asets,

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
120: AND asets.object_id = asets2.object_id
121: AND asets.object_type = 'OPEN_ASSIGNMENT'

Line 118: pa_action_sets asets2

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
120: AND asets.object_id = asets2.object_id
121: AND asets.object_type = 'OPEN_ASSIGNMENT'
122: AND asets.action_set_type_code = 'ADVERTISEMENT'

Line 268: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

264: --dbms_output.put_line('number of lines2: '||l_condition_date_tbl2.COUNT);
265: --dbms_output.put_line('number of lines3: '||l_action_line_id_tbl2.COUNT);
266: --dbms_output.put_line('number of lines4: '||l_action_line_number_tbl2.COUNT);
267:
268: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
269: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl2
270: ,p_condition_date_tbl => l_condition_date_tbl2
271: ,x_return_status => l_return_status
272: );

Line 278: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(

274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END IF;
277:
278: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(
279: p_action_set_line_id_tbl => l_action_line_id_tbl2
280: ,p_line_number_tbl => l_action_line_number_tbl2
281: ,x_return_status => x_return_status
282: );

Line 309: , p_object_id IN pa_action_sets.object_id%TYPE

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

Line 376: , p_object_id IN pa_action_sets.object_id%TYPE

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
380: , p_starting_organization_id IN hr_organization_units.organization_id%TYPE := NULL

Line 509: , p_action_set_id IN pa_action_sets.action_set_id%TYPE

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
513: , p_action_status_code IN pa_action_set_lines.status_code%TYPE

Line 511: , p_object_id IN pa_action_sets.object_id%TYPE

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

Line 636: PA_ACTION_SETS_PUB.Update_Action_Set_Line (

632: ELSE
633:
634: -- Update the current action line to store the new
635: -- start_organization_id and org_hierarchy_version_id
636: PA_ACTION_SETS_PUB.Update_Action_Set_Line (
637: p_action_set_line_id => p_action_set_line_id
638: ,p_action_set_line_number => p_action_set_line_number
639: ,p_record_version_number => p_action_set_line_rec_ver_num
640: ,p_action_code => p_action_code

Line 721: , p_object_id IN pa_action_sets.object_id%TYPE

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

Line 859: , p_object_id IN pa_action_sets.object_id%TYPE

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
863: , p_project_id IN pa_projects_all.project_id%TYPE

Line 1000: , p_object_id IN pa_action_sets.object_id%TYPE

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
1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM

Line 1626: , p_object_id IN pa_action_sets.object_id%TYPE

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
1630: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE

Line 1758: , p_object_id IN pa_action_sets.object_id%TYPE

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

Line 1904: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(

1900:
1901: IF l_action_set_line_id_tbl2.COUNT > 0 THEN
1902:
1903: -- Update the action line status to REVERSED
1904: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(
1905: p_action_set_line_id_tbl => l_action_set_line_id_tbl2
1906: ,p_line_status_tbl => l_line_status_tbl2
1907: ,x_return_status => l_return_status
1908: );

Line 1976: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(

1972:
1973: IF l_action_set_line_id_tbl.COUNT > 0 THEN
1974:
1975: -- update the action line status to COMPLETE
1976: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(
1977: p_action_set_line_id_tbl => l_action_set_line_id_tbl
1978: ,p_line_status_tbl => l_line_status_tbl
1979: ,x_return_status => l_return_status
1980: );