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

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

455:
456: PROCEDURE create_action_set_line
457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
458: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
459: ,p_description IN pa_action_set_lines.description%TYPE := NULL
460: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL

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

456: PROCEDURE create_action_set_line
457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
458: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
459: ,p_description IN pa_action_set_lines.description%TYPE := NULL
460: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL

Line 461: ,p_action_code IN pa_action_set_lines.action_code%TYPE

457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
458: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
459: ,p_description IN pa_action_set_lines.description%TYPE := NULL
460: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL

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

458: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
459: ,p_description IN pa_action_set_lines.description%TYPE := NULL
460: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL

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

459: ,p_description IN pa_action_set_lines.description%TYPE := NULL
460: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL

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

460: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL

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

461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
469: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL

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

462: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
469: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL

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

463: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
469: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL

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

464: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
469: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

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

465: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
469: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0

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

466: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
469: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

467: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
468: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
469: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

575: END Create_Action_Set_Line;
576:
577:
578: PROCEDURE update_action_set_line
579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

Line 580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE

576:
577:
578: PROCEDURE update_action_set_line
579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR

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

577:
578: PROCEDURE update_action_set_line
579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

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

579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

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

580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

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

581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

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

582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

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

583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

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

584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

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

585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

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

586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

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

587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

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

588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0

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

589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 703: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL

699:
700:
701: PROCEDURE delete_action_set_line
702: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
703: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
704: ,p_api_version IN NUMBER := 1.0
705: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
706: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 752: FROM pa_action_set_lines

748:
749: BEGIN
750:
751: SELECT record_version_number INTO l_record_version_number
752: FROM pa_action_set_lines
753: WHERE action_set_line_id = p_action_set_line_id
754: AND record_version_number = p_record_version_number;
755:
756: EXCEPTION

Line 1218: FROM pa_action_set_lines l,

1214: e_invalid_result_code EXCEPTION;
1215:
1216: CURSOR get_action_set_lines(p_action_set_id IN NUMBER) IS
1217: SELECT action_set_line_id
1218: FROM pa_action_set_lines l,
1219: pa_action_sets s
1220: WHERE s.action_set_id = p_action_set_id
1221: AND s.action_set_id = l.action_set_id
1222: AND s.status_code IN ('STARTED','RESUMED')

Line 1369: from pa_action_set_lines;

1365: INSERT INTO pa_action_set_report_temp(action_set_line_id,
1366: project_number,
1367: object_name)
1368: select action_set_line_id, 'OBJ NAME', 'PROJ NAME'
1369: from pa_action_set_lines;
1370: */
1371:
1372: IF p_debug_mode = 'Y' THEN
1373:

Line 1473: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL

1469:
1470: PROCEDURE create_line_single_cond
1471: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
1472: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
1473: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
1474: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL

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

1470: PROCEDURE create_line_single_cond
1471: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
1472: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
1473: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
1474: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL

Line 1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE

1471: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
1472: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
1473: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
1474: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL

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

1472: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
1473: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
1474: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL

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

1473: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
1474: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL

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

1474: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL

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

1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
1483: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL

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

1476: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
1483: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
1484: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL

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

1477: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
1483: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
1484: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
1485: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL

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

1478: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
1483: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
1484: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
1485: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
1486: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := NULL

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

1479: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
1483: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
1484: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
1485: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
1486: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := NULL
1487: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE

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

1480: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
1483: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
1484: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
1485: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
1486: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := NULL
1487: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1488: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := NULL

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

1481: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
1482: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
1483: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
1484: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
1485: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
1486: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := NULL
1487: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1488: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := NULL
1489: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := NULL

Line 1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

1586:
1587: PROCEDURE update_line_single_cond
1588: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE

1587: PROCEDURE update_line_single_cond
1588: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

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

1588: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

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

1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

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

1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

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

1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

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

1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

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

1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

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

1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR

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

1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE

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

1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR

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

1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR

Line 1683: FROM pa_action_sets s, pa_action_set_lines l

1679: -- a line is performed.
1680: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1681: SELECT s.action_set_template_flag, s.action_set_id
1682: INTO l_action_set_template_flag, l_action_set_id
1683: FROM pa_action_sets s, pa_action_set_lines l
1684: WHERE l.action_set_line_id = p_action_set_line_id
1685: AND s.action_set_id = l.action_set_id;
1686:
1687: IF l_action_set_template_flag = 'N' THEN