APPS.PA_ACTION_SETS_PVT dependencies on PA_ACTION_SET_TYPES

Line 5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE

1: PACKAGE BODY pa_action_sets_pvt AS
2: /*$Header: PARASPVB.pls 120.4 2008/02/28 11:50:39 jcgeorge ship $*/
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL

Line 224: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;

220: l_previous_status pa_action_sets.status_code%TYPE;
221: l_status_code pa_action_sets.status_code%TYPE;
222: l_unique VARCHAR2(1);
223: l_actual_start_date DATE := FND_API.G_MISS_DATE;
224: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
225: l_action_set_template_flag VARCHAR2(1);
226: l_msg_count NUMBER;
227: l_msg_data VARCHAR2(2000);
228: l_debug_mode VARCHAR2(20) := 'N';

Line 506: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;

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;
510: l_debug_mode VARCHAR2(20) := 'N';

Line 661: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;

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);
665: l_debug_mode VARCHAR2(20) := 'N';

Line 793: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;

789: )
790: IS
791:
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);

Line 1248: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE

1244: END;
1245:
1246:
1247: PROCEDURE perform_action_set_line
1248: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
1249: ,p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1250: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1251: )
1252: IS