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_PVT dependencies on PA_CI_IMPACTS

Line 93: and Pa_ci_impacts_util.is_render_true(pl.lookup_code, pci.project_id) = 'Y'

89: where pci.ci_type_id = pcit.ci_type_id
90: and pl.lookup_type = 'PA_CI_IMPACT_TYPES'
91: and decode(pcit.impact_type_code, 'FINPLAN_COST', 'FINPLAN', 'FINPLAN_REVENUE', 'FINPLAN', pcit.impact_type_code) = pl.lookup_code
92: and pl.enabled_flag = 'Y'
93: and Pa_ci_impacts_util.is_render_true(pl.lookup_code, pci.project_id) = 'Y'
94: and ci_id = p_ci_id
95: and impact_type_code = p_impact_type_code;
96:
97:

Line 103: pa_ci_impacts

99: cursor c_check_impact_exists
100: is
101: select ci_impact_id ,status_code,description
102: from
103: pa_ci_impacts
104: where ci_id = p_ci_id
105: and impact_type_code = p_impact_type_code;
106:
107:

Line 110: l_status_code pa_ci_impacts.status_code%TYPE := null;

106:
107:
108: --Declaring local Variables
109:
110: l_status_code pa_ci_impacts.status_code%TYPE := null;
111: l_ci_id pa_control_items.ci_id%TYPE := null;
112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;

Line 112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;

108: --Declaring local Variables
109:
110: l_status_code pa_ci_impacts.status_code%TYPE := null;
111: l_ci_id pa_control_items.ci_id%TYPE := null;
112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;

Line 117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;

113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;
117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;
118: l_impact_description pa_ci_impacts.description%type;
119: l_impact_description1 pa_ci_impacts.description%type;
120:
121:

Line 118: l_impact_description pa_ci_impacts.description%type;

114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;
117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;
118: l_impact_description pa_ci_impacts.description%type;
119: l_impact_description1 pa_ci_impacts.description%type;
120:
121:
122:

Line 119: l_impact_description1 pa_ci_impacts.description%type;

115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;
117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;
118: l_impact_description pa_ci_impacts.description%type;
119: l_impact_description1 pa_ci_impacts.description%type;
120:
121:
122:
123: has_access VARCHAR2(1); --for security check

Line 272: if ('EDIT'<> pa_ci_impacts_util.get_update_impact_mode(l_ci_id, l_cr_status_code)) then

268: end if;
269:
270:
271: /*Check for the impact security -- coded as in the UI impact_icon is enabled and disabled based on ControlitemListVO query */
272: if ('EDIT'<> pa_ci_impacts_util.get_update_impact_mode(l_ci_id, l_cr_status_code)) then
273: PA_UTILS.add_Message( p_app_short_name => 'PA'
274: ,p_msg_name => 'PA_CI_NO_IMPACT_UPDATE_ACCESS');
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: if l_debug_mode = 'Y' then

Line 284: pa_debug.g_err_stage:= 'After call to pa_ci_impacts_util.get_update_impact_mode, to check for the update access';

280: raise FND_API.G_EXC_ERROR ;
281: end if;
282:
283: if l_debug_mode = 'Y' then
284: pa_debug.g_err_stage:= 'After call to pa_ci_impacts_util.get_update_impact_mode, to check for the update access';
285: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
286: end if;
287:
288:

Line 346: /Directly calling the private method in PA_CI_IMPACTS_PVT/

342: elsif p_impact_description <> G_PA_MISS_CHAR and p_impact_description is not null then
343: l_impact_description := p_impact_description;
344: end if;
345:
346: /*Directly calling the private method in PA_CI_IMPACTS_PVT*/
347: PA_CI_IMPACTS_pvt.create_ci_impact(
348: p_api_version => p_api_version_number,
349: p_init_msg_list => FND_API.G_FALSE,
350: p_commit => p_commit,

Line 347: PA_CI_IMPACTS_pvt.create_ci_impact(

343: l_impact_description := p_impact_description;
344: end if;
345:
346: /*Directly calling the private method in PA_CI_IMPACTS_PVT*/
347: PA_CI_IMPACTS_pvt.create_ci_impact(
348: p_api_version => p_api_version_number,
349: p_init_msg_list => FND_API.G_FALSE,
350: p_commit => p_commit,
351: p_validate_only => 'F',

Line 377: /calling directly the PVT method in PA_CI_IMPACTS_pvt/

373: l_impact_description := p_impact_description;
374: end if;
375:
376:
377: /*calling directly the PVT method in PA_CI_IMPACTS_pvt*/
378: PA_CI_IMPACTS_pvt.update_ci_impact(
379: p_api_version => p_api_version_number,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_commit => p_commit,

Line 378: PA_CI_IMPACTS_pvt.update_ci_impact(

374: end if;
375:
376:
377: /*calling directly the PVT method in PA_CI_IMPACTS_pvt*/
378: PA_CI_IMPACTS_pvt.update_ci_impact(
379: p_api_version => p_api_version_number,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_commit => p_commit,
382: p_validate_only => 'F',

Line 490: l_ci_impact_id pa_ci_impacts.ci_impact_id%type := NULL;

486: l_currency_name fnd_currencies_vl.Name%TYPE;
487: l_project_id pa_control_items.project_id%TYPE;
488: l_ci_type_id pa_control_items.ci_type_id%type;
489: l_change_description pa_ci_supplier_details.change_description%type;
490: l_ci_impact_id pa_ci_impacts.ci_impact_id%type := NULL;
491: l_calling_mode VARCHAR2(30);
492: l_po_line_Amount NUMBER ;
493: l_ou_name VARCHAR2(30);
494: x_rowid ROWID;

Line 627: select ci_type_id from pa_control_items a , pa_ci_impacts b

623:
624:
625: /*Cursor to check ci_id validity*/
626: /*cursor c_get_ci_type_id is
627: select ci_type_id from pa_control_items a , pa_ci_impacts b
628: where a.ci_id = b.ci_id
629: and a.ci_id = p_ci_id
630: and b.IMPACT_TYPE_CODE = 'SUPPLIER';*/
631: