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_UTILS

Line 222: l_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id

218:
219: l_action_set_id := p_action_set_id;
220:
221: IF l_action_set_id IS NULL THEN
222: l_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id
223: (p_action_set_type_code => p_action_set_type_code,
224: p_object_type => p_object_type,
225: p_object_id => p_object_id);
226: END IF;

Line 376: l_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id

372:
373: l_action_set_id := p_action_set_id;
374:
375: IF l_action_set_id IS NULL THEN
376: l_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id
377: (p_action_set_type_code => p_action_set_type_code,
378: p_object_type => p_object_type,
379: p_object_id => p_object_id);
380: END IF;

Line 472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

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
476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

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
599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 822: l_action_set_lines_tbl pa_action_set_utils.action_set_lines_tbl_type;

818: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
819: )
820: IS
821:
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;

Line 823: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;

819: )
820: IS
821:
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;

Line 961: l_action_set_lines_tbl := PA_ACTION_SET_UTILS.get_action_set_lines(p_action_set_id => p_action_set_id);

957: ,x_msg_data => l_msg_data);
958:
959:
960:
961: l_action_set_lines_tbl := PA_ACTION_SET_UTILS.get_action_set_lines(p_action_set_id => p_action_set_id);
962:
963: IF l_action_set_lines_tbl.COUNT >0 THEN
964: FOR i IN l_action_set_lines_tbl.FIRST .. l_action_set_lines_tbl.LAST LOOP
965:

Line 966: l_action_line_conditions_tbl := PA_ACTION_SET_UTILS.get_action_line_conditions

962:
963: IF l_action_set_lines_tbl.COUNT >0 THEN
964: FOR i IN l_action_set_lines_tbl.FIRST .. l_action_set_lines_tbl.LAST LOOP
965:
966: l_action_line_conditions_tbl := PA_ACTION_SET_UTILS.get_action_line_conditions
967: (p_action_set_line_id => l_action_set_lines_tbl(i).action_set_line_id);
968:
969: create_action_set_line(
970: p_action_set_id => x_new_action_set_id

Line 1111: l_current_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id

1107:
1108: l_current_action_set_id := p_current_action_set_id;
1109:
1110: IF l_current_action_set_id IS NULL THEN
1111: l_current_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id
1112: (p_action_set_type_code => p_action_set_type_code,
1113: p_object_type => p_object_type,
1114: p_object_id => p_object_id);
1115: END IF;

Line 1260: PA_ACTION_SET_UTILS.G_ERROR_EXISTS := 'N';

1256: ,x_msg => 'Beginning of Perform_Single_Action_Set pub'
1257: ,x_log_level => 5);
1258: END IF;
1259:
1260: PA_ACTION_SET_UTILS.G_ERROR_EXISTS := 'N';
1261: -- PA_ACTION_SETS_PVT.g_line_errors_tbl.DELETE;
1262:
1263: l_action_set_type_code := p_action_set_type_code;
1264:

Line 1274: l_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id

1270:
1271: l_action_set_id := p_action_set_id;
1272:
1273: IF l_action_set_id IS NULL THEN
1274: l_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id
1275: (p_action_set_type_code => l_action_set_type_code,
1276: p_object_type => p_object_type,
1277: p_object_id => p_object_id);
1278: END IF;

Line 1322: IF x_msg_count > 0 OR PA_ACTION_SET_UTILS.G_ERROR_EXISTS = 'Y' THEN

1318: -- Reset the error stack when returning to the calling program
1319: PA_DEBUG.Reset_Err_Stack;
1320: -- If any errors exist then set the x_return_status to 'E'
1321:
1322: IF x_msg_count > 0 OR PA_ACTION_SET_UTILS.G_ERROR_EXISTS = 'Y' THEN
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:
1326: -- Commit if the flag is set and there is no error

Line 1354: l_action_set_type_code_tbl pa_action_set_utils.varchar_tbl_type;

1350: p_debug_mode IN VARCHAR2,
1351: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1352: IS
1353:
1354: l_action_set_type_code_tbl pa_action_set_utils.varchar_tbl_type;
1355: l_action_set_line_id_tbl pa_action_set_utils.action_set_line_id_tbl_type;
1356: l_object_name_tbl pa_action_set_utils.object_name_tbl_type;
1357: l_project_number_tbl pa_action_set_utils.project_number_tbl_type;
1358: l_return_status VARCHAR2(1);

Line 1355: l_action_set_line_id_tbl pa_action_set_utils.action_set_line_id_tbl_type;

1351: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1352: IS
1353:
1354: l_action_set_type_code_tbl pa_action_set_utils.varchar_tbl_type;
1355: l_action_set_line_id_tbl pa_action_set_utils.action_set_line_id_tbl_type;
1356: l_object_name_tbl pa_action_set_utils.object_name_tbl_type;
1357: l_project_number_tbl pa_action_set_utils.project_number_tbl_type;
1358: l_return_status VARCHAR2(1);
1359: e_invalid_result_code EXCEPTION;

Line 1356: l_object_name_tbl pa_action_set_utils.object_name_tbl_type;

1352: IS
1353:
1354: l_action_set_type_code_tbl pa_action_set_utils.varchar_tbl_type;
1355: l_action_set_line_id_tbl pa_action_set_utils.action_set_line_id_tbl_type;
1356: l_object_name_tbl pa_action_set_utils.object_name_tbl_type;
1357: l_project_number_tbl pa_action_set_utils.project_number_tbl_type;
1358: l_return_status VARCHAR2(1);
1359: e_invalid_result_code EXCEPTION;
1360:

Line 1357: l_project_number_tbl pa_action_set_utils.project_number_tbl_type;

1353:
1354: l_action_set_type_code_tbl pa_action_set_utils.varchar_tbl_type;
1355: l_action_set_line_id_tbl pa_action_set_utils.action_set_line_id_tbl_type;
1356: l_object_name_tbl pa_action_set_utils.object_name_tbl_type;
1357: l_project_number_tbl pa_action_set_utils.project_number_tbl_type;
1358: l_return_status VARCHAR2(1);
1359: e_invalid_result_code EXCEPTION;
1360:
1361: BEGIN

Line 1509: l_condition_tbl pa_action_set_utils.action_line_cond_tbl_type;

1505: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1506: )
1507: IS
1508:
1509: l_condition_tbl pa_action_set_utils.action_line_cond_tbl_type;
1510: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
1511:
1512: BEGIN
1513:

Line 1624: l_condition_tbl pa_action_set_utils.action_line_cond_tbl_type;

1620: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1621: )
1622: IS
1623:
1624: l_condition_tbl pa_action_set_utils.action_line_cond_tbl_type;
1625: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
1626: l_action_set_id pa_action_sets.action_set_id%TYPE;
1627:
1628: BEGIN