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_CONTROL_ITEMS_S

Line 115: l_cr_status_code pa_control_items.status_code%type;

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;
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;

Line 1749: l_summary pa_control_items.summary%type;

1745:
1746:
1747: l_any_err_occured_flg VARCHAR2(1);
1748:
1749: l_summary pa_control_items.summary%type;
1750: l_description pa_control_items.description%type;
1751: l_status_code pa_project_statuses.project_status_code%type;
1752: l_status_name pa_project_statuses.project_status_name%type;
1753: l_system_status_code pa_project_statuses.project_system_status_code%type;

Line 1794: l_source_type_code pa_control_items.source_type_code%type;

1790: l_attribute15 pa_control_items.attribute1%type;
1791:
1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;

Line 1795: l_source_number pa_control_items.source_number%type;

1791:
1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;

Line 1796: l_source_comment pa_control_items.source_comment%type;

1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;

Line 1797: l_source_date_received pa_control_items.source_date_received%type;

1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;
1801: begin

Line 1798: l_source_organization pa_control_items.source_organization%type;

1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;
1801: begin
1802: -- initialize the return status to success

Line 1799: l_source_person pa_control_items.source_person%type;

1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;
1801: begin
1802: -- initialize the return status to success
1803: x_return_status := fnd_api.g_ret_sts_success;

Line 2215: select pa_control_items_s.nextval

2211: l_attribute15 := p_attribute15;
2212:
2213: /* if we reach here in code then all the attributes have been validated.
2214: So get the next value from the sequence which will be used as the ci_id*/
2215: select pa_control_items_s.nextval
2216: into l_ci_id
2217: from dual;
2218:
2219: /* now generate the ci_number;*/

Line 2798: l_ci_status_code pa_control_items.status_code%type;

2794: l_any_err_occured_flg VARCHAR2(1);
2795: l_return_status VARCHAR2(1);
2796:
2797: l_action_status_code pa_project_statuses.project_status_code%type;
2798: l_ci_status_code pa_control_items.status_code%type;
2799: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;
2800: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;
2801: chk_valid_src_ci_action_id_rec check_valid_src_ci_action_id%rowtype;
2802: