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_COMMENTS

Line 2245: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */

2241: IF l_debug_mode = 'Y' THEN
2242: pa_debug.write(l_module_name, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
2243: END IF;
2244:
2245: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
2246:
2247: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
2248: ,p_object_id => p_ci_id
2249: ,p_type_code => 'CHANGE_STATUS'

Line 4488: l_ci_comment_id pa_ci_comments.ci_comment_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;
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;

Line 4490: l_response_text pa_ci_comments.comment_text%type;

4486: l_assignee_id NUMBER := null;
4487: l_perform_action VARCHAR2(1) := null;
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;

Line 4491: l_reassign_request_text pa_ci_comments.comment_text%type;

4487: l_perform_action VARCHAR2(1) := null;
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:

Line 4640: --a new record gets created in pa_ci_comments with response text if response text is passed.

4636: /*if sign_off_required_flag is not Y then sign_off flag would be N*/
4637: l_sign_off_flag := 'N';
4638: end if; -- if(get_action_attrs_rec.sign_off_required_flag = 'Y') then
4639:
4640: --a new record gets created in pa_ci_comments with response text if response text is passed.
4641: if (p_response_text = G_PA_MISS_CHAR or p_response_text is null ) then
4642: l_response_text := null;
4643: else
4644: l_response_text := p_response_text;

Line 6762: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;

6758: l_resolution_req VARCHAR2(10) := 'N';
6759: l_resolution_req_cls VARCHAR2(10) := 'N';
6760: l_to_status_flag VARCHAR2(10) := 'Y';
6761:
6762: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;
6763: l_comment_text pa_ci_comments.comment_text%TYPE;
6764: l_owner_name per_all_people_f.full_name%TYPE;
6765: l_curr_owner_name per_all_people_f.full_name%TYPE;
6766: l_chgowner_allowed VARCHAR2(1);

Line 6763: l_comment_text pa_ci_comments.comment_text%TYPE;

6759: l_resolution_req_cls VARCHAR2(10) := 'N';
6760: l_to_status_flag VARCHAR2(10) := 'Y';
6761:
6762: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;
6763: l_comment_text pa_ci_comments.comment_text%TYPE;
6764: l_owner_name per_all_people_f.full_name%TYPE;
6765: l_curr_owner_name per_all_people_f.full_name%TYPE;
6766: l_chgowner_allowed VARCHAR2(1);
6767: l_to_owner_allowed VARCHAR2(1);

Line 7099: pa_ci_comments_pkg.insert_row(

7095: fnd_message.set_token('NEXT_OWNER', l_owner_name);
7096: fnd_message.set_token('COMMENT', p_owner_comment);
7097: l_comment_text := fnd_message.get;
7098:
7099: pa_ci_comments_pkg.insert_row(
7100: p_ci_comment_id => l_ci_comment_id,
7101: p_ci_id => p_ci_id,
7102: p_type_code => 'CHANGE_OWNER',
7103: p_comment_text => l_comment_text,

Line 7663: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */

7659: IF l_debug_mode = 'Y' THEN
7660: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
7661: END IF;
7662:
7663: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
7664:
7665: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
7666: ,p_object_id => p_ci_id
7667: ,p_type_code => 'CHANGE_STATUS'

Line 8022: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;

8018: l_resolution_req VARCHAR2(10) := 'N';
8019: l_resolution_req_cls VARCHAR2(10) := 'N';
8020: l_to_status_flag VARCHAR2(10) := 'Y';
8021:
8022: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;
8023: l_comment_text pa_ci_comments.comment_text%TYPE;
8024: l_owner_name per_all_people_f.full_name%TYPE;
8025: l_curr_owner_name per_all_people_f.full_name%TYPE;
8026: l_chgowner_allowed VARCHAR2(1);

Line 8023: l_comment_text pa_ci_comments.comment_text%TYPE;

8019: l_resolution_req_cls VARCHAR2(10) := 'N';
8020: l_to_status_flag VARCHAR2(10) := 'Y';
8021:
8022: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;
8023: l_comment_text pa_ci_comments.comment_text%TYPE;
8024: l_owner_name per_all_people_f.full_name%TYPE;
8025: l_curr_owner_name per_all_people_f.full_name%TYPE;
8026: l_chgowner_allowed VARCHAR2(1);
8027: l_to_owner_allowed VARCHAR2(1);

Line 8348: pa_ci_comments_pkg.insert_row(

8344: fnd_message.set_token('NEXT_OWNER', l_owner_name);
8345: fnd_message.set_token('COMMENT', p_owner_comment);
8346: l_comment_text := fnd_message.get;
8347:
8348: pa_ci_comments_pkg.insert_row(
8349: p_ci_comment_id => l_ci_comment_id,
8350: p_ci_id => p_ci_id,
8351: p_type_code => 'CHANGE_OWNER',
8352: p_comment_text => l_comment_text,

Line 8916: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */

8912: END IF;
8913:
8914: IF (l_status_change_flag = 'Y' AND l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
8915:
8916: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
8917:
8918: IF l_debug_mode = 'Y' THEN
8919: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8920: END IF;

Line 9279: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;

9275: l_resolution_req VARCHAR2(10) := 'N';
9276: l_resolution_req_cls VARCHAR2(10) := 'N';
9277: l_to_status_flag VARCHAR2(10) := 'Y';
9278:
9279: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;
9280: l_comment_text pa_ci_comments.comment_text%TYPE;
9281: l_owner_name per_all_people_f.full_name%TYPE;
9282: l_curr_owner_name per_all_people_f.full_name%TYPE;
9283: l_chgowner_allowed VARCHAR2(1);

Line 9280: l_comment_text pa_ci_comments.comment_text%TYPE;

9276: l_resolution_req_cls VARCHAR2(10) := 'N';
9277: l_to_status_flag VARCHAR2(10) := 'Y';
9278:
9279: l_ci_comment_id pa_ci_comments.ci_comment_id%TYPE;
9280: l_comment_text pa_ci_comments.comment_text%TYPE;
9281: l_owner_name per_all_people_f.full_name%TYPE;
9282: l_curr_owner_name per_all_people_f.full_name%TYPE;
9283: l_chgowner_allowed VARCHAR2(1);
9284: l_to_owner_allowed VARCHAR2(1);

Line 9605: pa_ci_comments_pkg.insert_row(

9601: fnd_message.set_token('NEXT_OWNER', l_owner_name);
9602: fnd_message.set_token('COMMENT', p_owner_comment);
9603: l_comment_text := fnd_message.get;
9604:
9605: pa_ci_comments_pkg.insert_row(
9606: p_ci_comment_id => l_ci_comment_id,
9607: p_ci_id => p_ci_id,
9608: p_type_code => 'CHANGE_OWNER',
9609: p_comment_text => l_comment_text,

Line 10174: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */

10170: END IF;
10171:
10172: IF (l_status_change_flag = 'Y' AND l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
10173:
10174: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
10175:
10176: IF l_debug_mode = 'Y' THEN
10177: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10178: END IF;