APPS.PA_ACTION_SETS_PUB 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_pub AS
2: /*$Header: PARASPUB.pls 120.4 2011/06/28 05:51:19 rtalakon 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 826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;

822: l_action_set_lines_tbl pa_action_set_utils.action_set_lines_tbl_type;
823: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
824: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
825: l_action_set_name pa_action_sets.action_set_name%TYPE;
826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;

Line 1055: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL

1051:
1052:
1053: PROCEDURE replace_action_set
1054: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1055: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1056: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1057: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE

Line 1196: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL

1192:
1193:
1194: PROCEDURE perform_single_action_set
1195: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1196: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1197: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1198: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1199: ,p_api_version IN NUMBER := 1.0
1200: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 1213: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;

1209: l_msg_index_out NUMBER;
1210: l_msg_count NUMBER;
1211: l_msg_data VARCHAR2(2000);
1212: l_action_set_id pa_action_sets.action_set_id%TYPE;
1213: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
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

Line 1386: FROM pa_action_set_types;

1382: DELETE FROM pa_action_set_report_temp;
1383:
1384: IF p_action_set_type_code IS NULL THEN
1385: SELECT action_set_type_code BULK COLLECT INTO l_action_set_type_code_tbl
1386: FROM pa_action_set_types;
1387: ELSE
1388: l_action_set_type_code_tbl(1) := p_action_set_type_code;
1389: END IF;
1390: