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_ACTION_SETS_PVT dependencies on PA_ACTION_SET_LINES

Line 484: ,p_description IN pa_action_set_lines.description%TYPE := NULL

480:
481: PROCEDURE create_action_set_line
482: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
483: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
484: ,p_description IN pa_action_set_lines.description%TYPE := NULL
485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
486: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL

Line 485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL

481: PROCEDURE create_action_set_line
482: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
483: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
484: ,p_description IN pa_action_set_lines.description%TYPE := NULL
485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
486: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL

Line 486: ,p_action_code IN pa_action_set_lines.action_code%TYPE

482: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
483: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
484: ,p_description IN pa_action_set_lines.description%TYPE := NULL
485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
486: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL

Line 487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL

483: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
484: ,p_description IN pa_action_set_lines.description%TYPE := NULL
485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
486: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL

Line 488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL

484: ,p_description IN pa_action_set_lines.description%TYPE := NULL
485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
486: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL

Line 489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL

485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
486: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL

Line 490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL

486: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL

Line 491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL

487: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL

Line 492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL

488: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
496: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL

Line 493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL

489: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
496: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
497: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

Line 494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL

490: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
496: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
497: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
498: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL

491: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
496: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
497: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
498: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
499: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 496: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL

492: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
496: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
497: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
498: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
499: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
500: )

Line 505: l_action_set_line_rec pa_action_set_lines%ROWTYPE;

501: IS
502:
503: l_return_status VARCHAR2(1);
504: l_msg_index_out NUMBER;
505: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
506: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
507: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
508: l_action_set_line_id NUMBER;
509: l_action_line_condition_id NUMBER;

Line 574: PA_ACTION_SET_LINES_PKG.Insert_Row

570: END IF;
571:
572: IF FND_MSG_PUB.Count_Msg = 0 THEN
573:
574: PA_ACTION_SET_LINES_PKG.Insert_Row
575: (p_action_set_id => p_action_set_id
576: ,p_action_set_line_number => p_action_set_line_number
577: ,p_description => p_description
578: ,p_status_code => 'PENDING'

Line 638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

634: END Create_Action_Set_Line;
635:
636:
637: PROCEDURE update_action_set_line
638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR

Line 639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE

635:
636:
637: PROCEDURE update_action_set_line
638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

Line 640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM

636:
637: PROCEDURE update_action_set_line
638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

Line 641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

637: PROCEDURE update_action_set_line
638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR

638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

Line 643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl

Line 650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
654: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
654: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
655: )

Line 652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
654: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
655: )
656: IS

Line 660: l_current_line_status pa_action_set_lines.status_code%TYPE;

656: IS
657:
658: l_return_status VARCHAR2(1);
659: l_record_version_number NUMBER;
660: l_current_line_status pa_action_set_lines.status_code%TYPE;
661: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
662: l_action_set_id pa_action_sets.action_set_id%TYPE;
663: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
664: l_action_set_template_flag VARCHAR2(1);

Line 663: l_action_set_line_rec pa_action_set_lines%ROWTYPE;

659: l_record_version_number NUMBER;
660: l_current_line_status pa_action_set_lines.status_code%TYPE;
661: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
662: l_action_set_id pa_action_sets.action_set_id%TYPE;
663: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
664: l_action_set_template_flag VARCHAR2(1);
665: l_debug_mode VARCHAR2(20) := 'N';
666:
667: BEGIN

Line 691: pa_action_set_lines lines

687: l_action_set_id,
688: l_action_set_template_flag,
689: l_current_line_status
690: FROM pa_action_sets sets,
691: pa_action_set_lines lines
692: WHERE lines.action_set_line_id = p_action_set_line_id
693: AND sets.action_set_id = lines.action_set_id;
694:
695: IF l_current_line_status = 'ACTIVE' OR l_current_line_status='COMPLETE' THEN

Line 724: PA_ACTION_SET_LINES_PKG.Update_Row

720:
721:
722: IF FND_MSG_PUB.Count_Msg = 0 THEN
723:
724: PA_ACTION_SET_LINES_PKG.Update_Row
725: (p_action_set_line_id => p_action_set_line_id
726: ,p_action_set_line_number => p_action_set_line_number
727: ,p_description => p_description
728: ,p_action_code => p_action_code

Line 787: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE

783:
784:
785: PROCEDURE delete_action_set_line
786: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
787: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
788: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
789: )
790: IS
791:

Line 796: l_current_line_status pa_action_set_lines.status_code%TYPE;

792: l_return_status VARCHAR2(1);
793: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
794: l_action_set_id pa_action_sets.action_set_id%TYPE;
795: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
796: l_current_line_status pa_action_set_lines.status_code%TYPE;
797: l_do_audit_lines_exist VARCHAR2(1);
798: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
799: l_debug_mode VARCHAR2(20) := 'N';
800:

Line 825: pa_action_set_lines lines

821: l_action_set_id,
822: l_action_set_template_flag,
823: l_current_line_status
824: FROM pa_action_sets sets,
825: pa_action_set_lines lines
826: WHERE lines.action_set_line_id = p_action_set_line_id
827: AND sets.action_set_id = lines.action_set_id;
828:
829: IF l_current_line_status = 'REVERSE_PENDING' OR l_current_line_status = 'UPDATE_PENDING' THEN

Line 843: PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id => p_action_set_line_id,

839: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
840: WHERE action_set_id = l_action_set_id;
841: END IF;
842:
843: PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id => p_action_set_line_id,
844: p_line_deleted_flag => 'Y',
845: x_return_status => l_return_status);
846:
847: ELSE

Line 874: PA_ACTION_SET_LINES_PKG.delete_row

870: (p_action_set_line_condition_id => l_action_line_conditions_tbl(i).action_set_line_condition_id,
871: p_record_version_number => p_record_version_number,
872: x_return_status => l_return_status);
873: END LOOP;
874: PA_ACTION_SET_LINES_PKG.delete_row
875: (p_action_set_line_id => p_action_set_line_id,
876: p_record_version_number => p_record_version_number,
877: x_return_status => l_return_status);
878: ELSE

Line 879: PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id => p_action_set_line_id,

875: (p_action_set_line_id => p_action_set_line_id,
876: p_record_version_number => p_record_version_number,
877: x_return_status => l_return_status);
878: ELSE
879: PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id => p_action_set_line_id,
880: p_record_version_number => p_record_version_number,
881: p_status_code => 'REVERSE_PENDING',
882: p_line_deleted_flag => 'Y',
883: x_return_status => l_return_status);

Line 904: PA_ACTION_SET_LINES_PKG.delete_row

900: x_return_status => l_return_status);
901:
902: END LOOP;
903:
904: PA_ACTION_SET_LINES_PKG.delete_row
905: (p_action_set_line_id => p_action_set_line_id,
906: p_record_version_number => p_record_version_number,
907: x_return_status => l_return_status);
908:

Line 911: PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id => p_action_set_line_id,

907: x_return_status => l_return_status);
908:
909: ELSE
910:
911: PA_ACTION_SET_LINES_PKG.update_row(p_action_set_line_id => p_action_set_line_id,
912: p_record_version_number => p_record_version_number,
913: p_status_code => 'REVERSE_PENDING',
914: p_line_deleted_flag => 'Y',
915: x_return_status => l_return_status);

Line 939: FUNCTION get_def_reverse_audit_lines(p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,

935:
936: END Delete_Action_Set_Line;
937:
938:
939: FUNCTION get_def_reverse_audit_lines(p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
940: p_reason IN VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_type
941: IS
942:
943: l_action_set_details_rec pa_action_sets%ROWTYPE;

Line 997: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,

993: END;
994:
995:
996: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
997: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
998: p_object_type IN pa_action_sets.object_type%TYPE,
999: p_object_id IN pa_action_sets.object_id%TYPE,
1000: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
1001: p_status_code IN VARCHAR2,

Line 1120: FROM pa_action_set_lines

1116:
1117: FOR i IN p_action_set_line_id_tbl.FIRST .. p_action_set_line_id_tbl.LAST LOOP
1118:
1119: SELECT rowid INTO l_rowid_tbl(i)
1120: FROM pa_action_set_lines
1121: WHERE action_set_line_id = p_action_set_line_id_tbl(i)
1122: FOR UPDATE NOWAIT;
1123:
1124: END LOOP;

Line 1127: UPDATE pa_action_set_lines

1123:
1124: END LOOP;
1125:
1126: FORALL i IN l_rowid_tbl.FIRST .. l_rowid_tbl.LAST
1127: UPDATE pa_action_set_lines
1128: SET action_set_line_number = p_line_number_tbl(i)
1129: WHERE rowid = l_rowid_tbl(i);
1130:
1131: END IF;

Line 1218: FROM pa_action_set_lines

1214:
1215: FOR i IN p_action_set_line_id_tbl.FIRST .. p_action_set_line_id_tbl.LAST LOOP
1216:
1217: SELECT rowid INTO l_rowid_tbl(i)
1218: FROM pa_action_set_lines
1219: WHERE action_set_line_id = p_action_set_line_id_tbl(i)
1220: FOR UPDATE NOWAIT;
1221:
1222: END LOOP;

Line 1225: UPDATE pa_action_set_lines

1221:
1222: END LOOP;
1223:
1224: FORALL i IN l_rowid_tbl.FIRST .. l_rowid_tbl.LAST
1225: UPDATE pa_action_set_lines
1226: SET status_code = p_line_status_tbl(i)
1227: WHERE rowid = l_rowid_tbl(i);
1228:
1229: END IF;

Line 1255: l_action_set_line_rec pa_action_set_lines%ROWTYPE;

1251: )
1252: IS
1253:
1254: l_return_status VARCHAR2(1);
1255: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
1256: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
1257: l_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1258: l_action_line_complete_flag VARCHAR2(1);
1259: l_action_line_result_code VARCHAR2(240);

Line 1370: PA_ACTION_SET_LINES_PKG.update_row

1366:
1367: IF l_action_line_result_code <> PA_ACTION_SET_UTILS.G_NOT_PERFORMED THEN
1368:
1369:
1370: PA_ACTION_SET_LINES_PKG.update_row
1371: (p_action_set_line_id => p_action_set_line_id,
1372: p_status_code => l_new_line_status_code,
1373: -- p_line_deleted_flag => l_line_deleted_flag,
1374: x_return_status => l_return_status);

Line 1398: FROM pa_action_set_lines

1394: ,p_msg_index_out => l_msg_index_out
1395: );
1396:
1397: SELECT action_set_line_number INTO l_action_set_line_number
1398: FROM pa_action_set_lines
1399: WHERE action_set_line_id = p_action_set_line_id;
1400:
1401: g_line_number_msg_tbl.EXTEND();
1402: g_info_msg_tbl.EXTEND();