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);
6768:
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);
6768:
6769:
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);
8028:
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);
8028:
8029:
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);
9285:
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);
9285:
9286: