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_CONTROL_ITEMS_UTILS dependencies on PA_CI_ACTIONS

Line 910: from pa_ci_actions where ci_id = p_ci_id and status_code = 'CI_ACTION_OPEN';

906: and wf_failure_status_code is not null;
907:
908: CURSOR get_open_actions IS -- Added for Bug#14267314
909: SELECT ci_action_id, ci_action_number, sign_off_required_flag
910: from pa_ci_actions where ci_id = p_ci_id and status_code = 'CI_ACTION_OPEN';
911:
912:
913: l_curr_status VARCHAR2(30);
914: l_new_status VARCHAR2(30);

Line 932: l_ci_action_id pa_ci_actions.ci_action_id%type; -- Bug#14267314 start.

928: l_submit_status VARCHAR2(30);
929: l_submit_status_flag VARCHAR2(1);
930: l_resolution_req VARCHAR2(1);
931: l_resolution_req_cls VARCHAR2(1);
932: l_ci_action_id pa_ci_actions.ci_action_id%type; -- Bug#14267314 start.
933: l_ci_action_number pa_ci_actions.ci_action_number%type;
934: l_sign_off pa_ci_actions.sign_off_required_flag%type;
935: l_process_name VARCHAR2(30);
936: l_item_key pa_wf_processes.item_key%TYPE; -- Bug#14267314 end.

Line 933: l_ci_action_number pa_ci_actions.ci_action_number%type;

929: l_submit_status_flag VARCHAR2(1);
930: l_resolution_req VARCHAR2(1);
931: l_resolution_req_cls VARCHAR2(1);
932: l_ci_action_id pa_ci_actions.ci_action_id%type; -- Bug#14267314 start.
933: l_ci_action_number pa_ci_actions.ci_action_number%type;
934: l_sign_off pa_ci_actions.sign_off_required_flag%type;
935: l_process_name VARCHAR2(30);
936: l_item_key pa_wf_processes.item_key%TYPE; -- Bug#14267314 end.
937:

Line 934: l_sign_off pa_ci_actions.sign_off_required_flag%type;

930: l_resolution_req VARCHAR2(1);
931: l_resolution_req_cls VARCHAR2(1);
932: l_ci_action_id pa_ci_actions.ci_action_id%type; -- Bug#14267314 start.
933: l_ci_action_number pa_ci_actions.ci_action_number%type;
934: l_sign_off pa_ci_actions.sign_off_required_flag%type;
935: l_process_name VARCHAR2(30);
936: l_item_key pa_wf_processes.item_key%TYPE; -- Bug#14267314 end.
937:
938: BEGIN

Line 2402: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);

2398: END IF;
2399:
2400: END IF;
2401:
2402: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2403:
2404: IF P_PA_DEBUG_MODE = 'Y' THEN
2405: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);
2406:

Line 2405: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);

2401:
2402: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2403:
2404: IF P_PA_DEBUG_MODE = 'Y' THEN
2405: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);
2406:
2407: END IF;
2408:
2409: IF l_temp = 'Y' THEN

Line 2583: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);

2579: END IF;
2580: END IF;
2581:
2582: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2583: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2584:
2585: IF l_temp = 'Y' THEN
2586: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2587: ,p_msg_name => 'PA_CI_CLOSE_INV_ACT');

Line 2787: pa_ci_actions_pvt.cancel_all_actions

2783:
2784: -- cancel open actions
2785: IF (l_curr_sys_status = 'CI_WORKING' and p_validate_only <> fnd_api.g_true AND x_return_status = 'S') then
2786:
2787: pa_ci_actions_pvt.cancel_all_actions
2788: (
2789: p_init_msg_list=> p_init_msg_list,
2790: p_commit => p_commit,
2791: p_validate_only => p_validate_only,