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

Line 4456: from pa_ci_actions

4452:
4453: cursor get_action_attrs(p_action_id number)
4454: is
4455: select sign_off_required_flag, record_version_number, date_required, ci_id, status_code
4456: from pa_ci_actions
4457: where ci_action_id = p_action_id;
4458:
4459: cursor close_notification(p_action_id number)
4460: is

Line 4483: l_action_id pa_ci_actions.ci_action_id%type;

4479: l_data VARCHAR2(2000);
4480: l_msg_data VARCHAR2(2000);
4481: l_msg_index_out NUMBER;
4482: l_module_name VARCHAR2(200);
4483: l_action_id pa_ci_actions.ci_action_id%type;
4484: l_party_id NUMBER := 0;
4485: l_user_id NUMBER := 0;
4486: l_assignee_id NUMBER := null;
4487: l_perform_action VARCHAR2(1) := null;

Line 4492: l_required_by_date pa_ci_actions.date_required%type;

4488: l_ci_comment_id pa_ci_comments.ci_comment_id%type;
4489: l_sign_off_flag VARCHAR2(1);
4490: l_response_text pa_ci_comments.comment_text%type;
4491: l_reassign_request_text pa_ci_comments.comment_text%type;
4492: l_required_by_date pa_ci_actions.date_required%type;
4493: l_reassign_to_id pa_ci_actions.assigned_to%type;
4494: l_project_id pa_control_items.project_id%TYPE;
4495:
4496: begin

Line 4493: l_reassign_to_id pa_ci_actions.assigned_to%type;

4489: l_sign_off_flag VARCHAR2(1);
4490: l_response_text pa_ci_comments.comment_text%type;
4491: l_reassign_request_text pa_ci_comments.comment_text%type;
4492: l_required_by_date pa_ci_actions.date_required%type;
4493: l_reassign_to_id pa_ci_actions.assigned_to%type;
4494: l_project_id pa_control_items.project_id%TYPE;
4495:
4496: begin
4497:

Line 4647: pa_ci_actions_pvt.close_ci_action(

4643: else
4644: l_response_text := p_response_text;
4645: end if;--if (p_response_text = G_PA_MISS_CHAR) then
4646:
4647: pa_ci_actions_pvt.close_ci_action(
4648: p_validate_only => fnd_api.g_false,
4649: p_ci_action_id => l_action_id,
4650: p_sign_off_flag => l_sign_off_flag,
4651: p_record_version_number => get_action_attrs_rec.record_version_number,

Line 4784: /*need to add a context in the pa_ci_actions_pvt.reassign_ci_action so tht we dont perform the check that

4780: end if;
4781: raise fnd_api.g_exc_error;
4782: end if;
4783:
4784: /*need to add a context in the pa_ci_actions_pvt.reassign_ci_action so tht we dont perform the check that
4785: required by date cannot be before the system date*/
4786: pa_ci_actions_pvt.reassign_ci_action(
4787: p_validate_only => fnd_api.g_false,
4788: p_ci_action_id => l_action_id,

Line 4786: pa_ci_actions_pvt.reassign_ci_action(

4782: end if;
4783:
4784: /*need to add a context in the pa_ci_actions_pvt.reassign_ci_action so tht we dont perform the check that
4785: required by date cannot be before the system date*/
4786: pa_ci_actions_pvt.reassign_ci_action(
4787: p_validate_only => fnd_api.g_false,
4788: p_ci_action_id => l_action_id,
4789: p_sign_off_flag => l_sign_off_flag,
4790: p_record_version_number => get_action_attrs_rec.record_version_number,

Line 4854: pa_ci_actions_pvt.add_ci_comment(

4850: else
4851: l_response_text := p_response_text;
4852: end if;--if (p_response_text = G_PA_MISS_CHAR) then
4853:
4854: pa_ci_actions_pvt.add_ci_comment(
4855: p_validate_only => fnd_api.g_false,
4856: p_ci_comment_id => l_ci_comment_id,
4857: p_ci_id => get_action_attrs_rec.ci_id,
4858: p_type_code => 'UNSOLICITED',

Line 5020: from pa_ci_actions

5016:
5017: cursor c_get_ci_id (c_action_id number)
5018: is --status_code is added to check only open action can be closed
5019: select ci_id , record_version_number, created_by , status_code
5020: from pa_ci_actions
5021: where ci_action_id = c_action_id;
5022:
5023:
5024:

Line 5032: l_action_id pa_ci_actions.ci_action_id%type;

5028: l_msg_index_out NUMBER;
5029: l_module_name VARCHAR2(200):= 'PA_CONTROL_API_PUB.Cancel_Action';
5030: l_assignee_id NUMBER := null;
5031: l_user_id NUMBER := 0;
5032: l_action_id pa_ci_actions.ci_action_id%type;
5033: l_ci_id pa_control_items.ci_id%type;
5034: l_record_version_number pa_ci_actions.record_version_number%type;
5035: l_status_code pa_ci_actions.status_code%type;
5036: check_s VARCHAR2(1);

Line 5034: l_record_version_number pa_ci_actions.record_version_number%type;

5030: l_assignee_id NUMBER := null;
5031: l_user_id NUMBER := 0;
5032: l_action_id pa_ci_actions.ci_action_id%type;
5033: l_ci_id pa_control_items.ci_id%type;
5034: l_record_version_number pa_ci_actions.record_version_number%type;
5035: l_status_code pa_ci_actions.status_code%type;
5036: check_s VARCHAR2(1);
5037: l_created_by NUMBER;
5038: l_project_id pa_control_items.project_id%TYPE;

Line 5035: l_status_code pa_ci_actions.status_code%type;

5031: l_user_id NUMBER := 0;
5032: l_action_id pa_ci_actions.ci_action_id%type;
5033: l_ci_id pa_control_items.ci_id%type;
5034: l_record_version_number pa_ci_actions.record_version_number%type;
5035: l_status_code pa_ci_actions.status_code%type;
5036: check_s VARCHAR2(1);
5037: l_created_by NUMBER;
5038: l_project_id pa_control_items.project_id%TYPE;
5039:

Line 5146: pa_debug.g_err_stage:= 'Before calling the pa_ci_actions_pvt.cancel_ci_action';

5142: --------------------------------------------------------------
5143: /*Need to chck for the open notification details cancelling*/
5144: -------------------------------------------------------------
5145: if l_debug_mode = 'Y' then
5146: pa_debug.g_err_stage:= 'Before calling the pa_ci_actions_pvt.cancel_ci_action';
5147: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
5148: end if;
5149:
5150: if x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 5152: pa_ci_actions_pvt.cancel_ci_action(

5148: end if;
5149:
5150: if x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5151:
5152: pa_ci_actions_pvt.cancel_ci_action(
5153: p_api_version => 1.0,
5154: p_init_msg_list => FND_API.G_FALSE,
5155: p_commit => p_commit,
5156: p_validate_only => 'F',

Line 5811: pa_debug.g_err_stage:= 'Before Calling PA_CI_ACTIONS_PUB.Add_CI_Comment in a for loop';

5807: -- he would be able to see the Control Item on the UI.
5808: IF (PA_CI_SECURITY_PKG.Check_View_Access (p_Ci_Id, l_ProjectId, l_StatusCode, l_CiTypeClassCode) = 'T') THEN
5809: -- For each Comment in the passed in array, insert it.
5810: if l_debug_mode = 'Y' then
5811: pa_debug.g_err_stage:= 'Before Calling PA_CI_ACTIONS_PUB.Add_CI_Comment in a for loop';
5812: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
5813: end if;
5814: FOR i IN 1..p_Comments_Tbl.COUNT LOOP
5815: PA_CI_ACTIONS_PUB.Add_CI_Comment (

Line 5815: PA_CI_ACTIONS_PUB.Add_CI_Comment (

5811: pa_debug.g_err_stage:= 'Before Calling PA_CI_ACTIONS_PUB.Add_CI_Comment in a for loop';
5812: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
5813: end if;
5814: FOR i IN 1..p_Comments_Tbl.COUNT LOOP
5815: PA_CI_ACTIONS_PUB.Add_CI_Comment (
5816: p_Api_Version => p_Api_Version_Number
5817: , p_Init_Msg_List => 'F'
5818: , p_Commit => 'F'
5819: , p_Validate_Only => 'F'