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_SET_UTILS

Line 20: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

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
23:
24: BEGIN

Line 355: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

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
358: ) IS
359:

Line 356: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619

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
358: ) IS
359:
360: TYPE varchar_tbl IS TABLE OF VARCHAR2(30)

Line 543: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;

539: -- Set the Result Code to be returned to generic API
540: --
541: IF p_action_set_line_rec.status_code = 'PENDING' THEN
542:
543: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;
544:
545: ELSIF p_action_set_line_rec.status_code = 'REVERSE_PENDING' THEN
546:
547: IF p_action_set_line_rec.action_code = 'ADVERTISEMENT_REMOVE_ADV' OR

Line 549: x_action_line_result_code := pa_action_set_utils.G_REVERSED_CUSTOM_AUDIT;

545: ELSIF p_action_set_line_rec.status_code = 'REVERSE_PENDING' THEN
546:
547: IF p_action_set_line_rec.action_code = 'ADVERTISEMENT_REMOVE_ADV' OR
548: p_action_set_line_rec.action_code = 'ADVERTISEMENT_UPDATE_SP' THEN
549: x_action_line_result_code := pa_action_set_utils.G_REVERSED_CUSTOM_AUDIT;
550: ELSIF (p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_EMAIL' OR
551: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' OR
552: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
553: AND l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 554: x_action_line_result_code := pa_action_set_utils.G_REVERSED_CUSTOM_AUDIT;

550: ELSIF (p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_EMAIL' OR
551: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' OR
552: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
553: AND l_return_status = FND_API.G_RET_STS_ERROR THEN
554: x_action_line_result_code := pa_action_set_utils.G_REVERSED_CUSTOM_AUDIT;
555: ELSE
556: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;
557: END IF;
558:

Line 556: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;

552: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
553: AND l_return_status = FND_API.G_RET_STS_ERROR THEN
554: x_action_line_result_code := pa_action_set_utils.G_REVERSED_CUSTOM_AUDIT;
555: ELSE
556: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;
557: END IF;
558:
559: ELSE -- update pending
560:

Line 563: x_action_line_result_code := pa_action_set_utils.G_UPDATED_CUSTOM_AUDIT;

559: ELSE -- update pending
560:
561: IF p_action_set_line_rec.action_code = 'ADVERTISEMENT_REMOVE_ADV' OR
562: p_action_set_line_rec.action_code = 'ADVERTISEMENT_UPDATE_SP' THEN
563: x_action_line_result_code := pa_action_set_utils.G_UPDATED_CUSTOM_AUDIT;
564: ELSIF (p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_EMAIL' OR
565: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' OR
566: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
567: AND l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 568: x_action_line_result_code := pa_action_set_utils.G_UPDATED_CUSTOM_AUDIT;

564: ELSIF (p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_EMAIL' OR
565: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' OR
566: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
567: AND l_return_status = FND_API.G_RET_STS_ERROR THEN
568: x_action_line_result_code := pa_action_set_utils.G_UPDATED_CUSTOM_AUDIT;
569: ELSE
570: x_action_line_result_code := pa_action_set_utils.G_UPDATED_DEFAULT_AUDIT;
571: END IF;
572:

Line 570: x_action_line_result_code := pa_action_set_utils.G_UPDATED_DEFAULT_AUDIT;

566: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
567: AND l_return_status = FND_API.G_RET_STS_ERROR THEN
568: x_action_line_result_code := pa_action_set_utils.G_UPDATED_CUSTOM_AUDIT;
569: ELSE
570: x_action_line_result_code := pa_action_set_utils.G_UPDATED_DEFAULT_AUDIT;
571: END IF;
572:
573: END IF; -- action line status
574:

Line 576: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;

572:
573: END IF; -- action line status
574:
575: ELSE -- condition met
576: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
577: END IF;
578:
579: x_action_line_audit_tbl := g_action_line_audit_tbl;
580:

Line 593: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;

589: -- Set the excetption Message and the stack
590: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set'
591: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
592:
593: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
594: RAISE; -- This is optional depending on the needs
595:
596: END Perform_Action_Set_Line;
597:

Line 627: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_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;
631: l_action_set_template_flag VARCHAR2(1);

Line 628: l_action_status_code_tbl pa_action_set_utils.varchar_tbl_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;
631: l_action_set_template_flag VARCHAR2(1);
632: l_msg_index_out NUMBER;

Line 629: l_condition_date_tbl pa_action_set_utils.date_tbl_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;
631: l_action_set_template_flag VARCHAR2(1);
632: l_msg_index_out NUMBER;
633:

Line 630: l_action_line_cond_id_tbl pa_action_set_utils.number_tbl_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;
631: l_action_set_template_flag VARCHAR2(1);
632: l_msg_index_out NUMBER;
633:
634: --cursor to get the related details of the requirement