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_ACTION_SETS

Line 18: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

14: ----------------------------------------------------------------------
15: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
16:
17: PROCEDURE Validate_Action_Set_Line (
18: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
19: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
20: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
21: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22: ) IS

Line 42: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

38: -- set or action lines on the requirement are updated, or an action
39: -- set is started on a requirement.
40: ----------------------------------------------------------------------
41: PROCEDURE Process_Action_Set (
42: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
43: , p_action_set_id IN NUMBER
44: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
45: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: ) IS

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

40: ----------------------------------------------------------------------
41: PROCEDURE Process_Action_Set (
42: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
43: , p_action_set_id IN NUMBER
44: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
45: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: ) IS
47:
48: TYPE varchar_tbl IS TABLE OF VARCHAR2(30)

Line 56: l_adv_action_set_status_code pa_action_sets.status_code%TYPE := NULL;

52: TYPE date_tbl IS TABLE OF DATE
53: INDEX BY BINARY_INTEGER;
54:
55: l_start_date pa_project_assignments.start_date%TYPE := NULL;
56: l_adv_action_set_status_code pa_action_sets.status_code%TYPE := NULL;
57: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE := NULL;
58: l_pub_to_org_line_id pa_action_set_lines.action_set_line_id%TYPE := NULL;
59: l_action_code_tbl varchar_tbl;
60: l_condition_code_tbl varchar_tbl;

Line 57: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE := NULL;

53: INDEX BY BINARY_INTEGER;
54:
55: l_start_date pa_project_assignments.start_date%TYPE := NULL;
56: l_adv_action_set_status_code pa_action_sets.status_code%TYPE := NULL;
57: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE := NULL;
58: l_pub_to_org_line_id pa_action_set_lines.action_set_line_id%TYPE := NULL;
59: l_action_code_tbl varchar_tbl;
60: l_condition_code_tbl varchar_tbl;
61: l_condition_attribute1_tbl varchar_tbl;

Line 85: pa_action_sets ast

81: SELECT pa.start_date,
82: ast.status_code,
83: ast.actual_start_date
84: FROM pa_project_assignments pa,
85: pa_action_sets ast
86: WHERE pa.assignment_id = ast.object_id
87: AND ast.action_set_id = p_action_set_id;
88:
89: --cursor to get pending and complete action lines

Line 352: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

348: -- Invoked by the generic perform action set API to perform an action
349: -- line in the advertisement action set on an object.
350: ----------------------------------------------------------------------
351: PROCEDURE Perform_Action_Set_Line (
352: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
353: , p_action_set_details_rec IN pa_action_sets%ROWTYPE
354: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
355: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
356: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619

Line 353: , p_action_set_details_rec IN pa_action_sets%ROWTYPE

349: -- line in the advertisement action set on an object.
350: ----------------------------------------------------------------------
351: PROCEDURE Perform_Action_Set_Line (
352: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
353: , p_action_set_details_rec IN pa_action_sets%ROWTYPE
354: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
355: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
356: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619
357: , x_action_line_result_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 372: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;

368: l_object_id pa_project_assignments.assignment_id%TYPE;
369: l_project_id pa_project_assignments.project_id%TYPE;
370: l_start_date pa_project_assignments.start_date%TYPE;
371: l_record_version_number pa_project_assignments.record_version_number%TYPE;
372: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
373: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
374: l_return_status VARCHAR2(1);
375:
376: --cursor to get the related details of the requirement

Line 373: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;

369: l_project_id pa_project_assignments.project_id%TYPE;
370: l_start_date pa_project_assignments.start_date%TYPE;
371: l_record_version_number pa_project_assignments.record_version_number%TYPE;
372: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
373: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
374: l_return_status VARCHAR2(1);
375:
376: --cursor to get the related details of the requirement
377: CURSOR get_req_action_set_info IS

Line 383: pa_action_sets ast

379: pa.project_id,
380: pa.start_date,
381: pa.record_version_number
382: FROM pa_project_assignments pa,
383: pa_action_sets ast
384: WHERE pa.assignment_id = ast.object_id
385: AND ast.action_set_id = p_action_set_line_rec.action_set_id;
386:
387: BEGIN

Line 609: p_object_id IN pa_action_sets.object_id%TYPE

605: -- updating the statuses of the action lines based on the
606: -- condition and the new requirement start date.
607: ----------------------------------------------------------------------
608: PROCEDURE Reevaluate_Adv_Action_Set (
609: p_object_id IN pa_action_sets.object_id%TYPE
610: , p_object_type IN pa_action_sets.object_type%TYPE
611: , p_new_object_start_date IN DATE
612: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
613: , p_api_version IN NUMBER := 1.0

Line 610: , p_object_type IN pa_action_sets.object_type%TYPE

606: -- condition and the new requirement start date.
607: ----------------------------------------------------------------------
608: PROCEDURE Reevaluate_Adv_Action_Set (
609: p_object_id IN pa_action_sets.object_id%TYPE
610: , p_object_type IN pa_action_sets.object_type%TYPE
611: , p_new_object_start_date IN DATE
612: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
613: , p_api_version IN NUMBER := 1.0
614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 624: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;

620: l_msg_count NUMBER;
621: l_msg_data VARCHAR2(2000);
622: l_project_id pa_project_assignments.project_id%TYPE;
623: l_start_date pa_project_assignments.start_date%TYPE;
624: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
625: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
626: l_action_set_id pa_action_sets.action_set_id%TYPE;
627: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
628: l_action_status_code_tbl pa_action_set_utils.varchar_tbl_type;

Line 625: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;

621: l_msg_data VARCHAR2(2000);
622: l_project_id pa_project_assignments.project_id%TYPE;
623: l_start_date pa_project_assignments.start_date%TYPE;
624: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
625: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
626: l_action_set_id pa_action_sets.action_set_id%TYPE;
627: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
628: l_action_status_code_tbl pa_action_set_utils.varchar_tbl_type;
629: l_condition_date_tbl pa_action_set_utils.date_tbl_type;

Line 626: l_action_set_id pa_action_sets.action_set_id%TYPE;

622: l_project_id pa_project_assignments.project_id%TYPE;
623: l_start_date pa_project_assignments.start_date%TYPE;
624: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
625: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
626: l_action_set_id pa_action_sets.action_set_id%TYPE;
627: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
628: l_action_status_code_tbl pa_action_set_utils.varchar_tbl_type;
629: l_condition_date_tbl pa_action_set_utils.date_tbl_type;
630: l_action_line_cond_id_tbl pa_action_set_utils.number_tbl_type;

Line 643: pa_action_sets ast

639: ast.actual_start_date,
640: ast.action_set_id,
641: ast.action_set_template_flag
642: FROM pa_project_assignments pa,
643: pa_action_sets ast
644: WHERE pa.assignment_id = p_object_id
645: AND ast.object_id = p_object_id
646: AND ast.object_type = p_object_type
647: AND ast.action_set_type_code = 'ADVERTISEMENT'

Line 703: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(

699: AND asl.action_set_line_id = aslc.action_set_line_id
700: AND aslc.condition_date > SYSDATE;
701:
702: -- bulk udpate advertisement action line status and condition date
703: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(
704: p_action_set_line_id_tbl => l_action_set_line_id_tbl
705: ,p_line_status_tbl => l_action_status_code_tbl
706: ,x_return_status => l_return_status
707: );

Line 712: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

708: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711:
712: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
713: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl
714: ,p_condition_date_tbl => l_condition_date_tbl
715: ,x_return_status => l_return_status
716: );

Line 743: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(

739: AND nvl(asl.line_deleted_flag, 'N') = 'N'
740: AND asl.action_set_line_id = aslc.action_set_line_id
741: AND aslc.condition_date > SYSDATE;
742:
743: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(
744: p_action_set_line_id_tbl => l_action_set_line_id_tbl
745: ,p_line_status_tbl => l_action_status_code_tbl
746: ,x_return_status => l_return_status
747: );

Line 752: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: END IF;
751:
752: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
753: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl
754: ,p_condition_date_tbl => l_condition_date_tbl
755: ,x_return_status => l_return_status
756: );

Line 762: PA_ACTION_SETS_PUB.Perform_Single_Action_Set(

758: x_return_status := FND_API.G_RET_STS_ERROR;
759: END IF;
760:
761: -- call generic action set API to perform the action set again
762: PA_ACTION_SETS_PUB.Perform_Single_Action_Set(
763: p_action_set_id => l_action_set_id
764: ,p_action_set_type_code => 'ADVERTISEMENT'
765: ,p_object_id => p_object_id
766: ,p_object_type => 'OPEN_ASSIGNMENT'

Line 812: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

808: -- Purpose
809: -- Check if the action set should be started upon application.
810: ----------------------------------------------------------------------
811: FUNCTION Is_Action_Set_Started_On_Apply(
812: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
813: ,p_object_type IN pa_action_sets.object_type%TYPE
814: ,p_object_id IN pa_action_sets.object_id%TYPE
815: ) RETURN VARCHAR2 IS
816:

Line 813: ,p_object_type IN pa_action_sets.object_type%TYPE

809: -- Check if the action set should be started upon application.
810: ----------------------------------------------------------------------
811: FUNCTION Is_Action_Set_Started_On_Apply(
812: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
813: ,p_object_type IN pa_action_sets.object_type%TYPE
814: ,p_object_id IN pa_action_sets.object_id%TYPE
815: ) RETURN VARCHAR2 IS
816:
817: l_action_set_start_flag VARCHAR2(1);

Line 814: ,p_object_id IN pa_action_sets.object_id%TYPE

810: ----------------------------------------------------------------------
811: FUNCTION Is_Action_Set_Started_On_Apply(
812: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
813: ,p_object_type IN pa_action_sets.object_type%TYPE
814: ,p_object_id IN pa_action_sets.object_id%TYPE
815: ) RETURN VARCHAR2 IS
816:
817: l_action_set_start_flag VARCHAR2(1);
818: