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.PQH_PROCESS_EMP_REVIEW dependencies on PQH_PROCESS_EMP_REVIEW

Line 1: PACKAGE BODY pqh_process_emp_review AS

1: PACKAGE BODY pqh_process_emp_review AS
2: /* $Header: pqrewpkg.pkb 120.3 2011/02/11 09:53:19 apjaiswa ship $ */
3: --
4: Cursor getUserName(p_person_id in Number) is
5: Select user_name

Line 101: AND s.api_name = 'PQH_PROCESS_EMP_REVIEW.PROCESS_API'

97: FROM hr_api_transaction_steps s,
98: hr_api_transaction_values a
99: WHERE s.transaction_step_id = a.transaction_step_id
100: AND s.transaction_step_id = p_transaction_step_id
101: AND s.api_name = 'PQH_PROCESS_EMP_REVIEW.PROCESS_API'
102: )
103: ) review ,
104: hr_lookups hl,
105: hr_locations loc

Line 171: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',5);

167:
168:
169: BEGIN
170:
171: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',5);
172: --
173: l_transaction_step_id := to_number(x_transaction_step_id);
174: --
175:

Line 238: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',10);

234: p_name => 'P_PERSON_ID' );
235:
236: */
237:
238: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',10);
239: EXCEPTION
240: WHEN hr_utility.hr_error THEN
241: hr_utility.raise_error;
242: WHEN OTHERS THEN

Line 325: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',5);

321: l_transaction_step_id number;
322: l_api_name hr_api_transaction_steps.api_name%TYPE;
323:
324: BEGIN
325: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',5);
326: --
327: l_transaction_step_id := to_number(x_transaction_step_id);
328: --
329:

Line 369: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',10);

365: p_name => 'P_PERSON_ID'||x_row_number );
366:
367:
368: hr_utility.set_location('x_person_id'||x_person_id,10);
369: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',10);
370: EXCEPTION
371: WHEN hr_utility.hr_error THEN
372: hr_utility.raise_error;
373: WHEN OTHERS THEN

Line 411: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_EMP_REVIEW.PROCESS_API';

407: l_transaction_id number;
408: l_trans_tbl hr_transaction_ss.transaction_table;
409: l_count number;
410: l_transaction_step_id number;
411: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_EMP_REVIEW.PROCESS_API';
412: l_result varchar2(100);
413: l_trns_object_version_number number;
414: l_review_proc_call VARCHAR2(30);
415: l_effective_date DATE ;

Line 418: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',5);

414: l_review_proc_call VARCHAR2(30);
415: l_effective_date DATE ;
416:
417: BEGIN
418: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',5);
419: l_review_proc_call := 'PqhEmployeeReview';
420: l_effective_date := SYSDATE;
421: --
422:

Line 520: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);

516: ,p_login_person_id => x_login_person_id
517: ,p_transaction_step_id => l_transaction_step_id
518: ,p_api_name => l_api_name
519: ,p_transaction_data => l_trans_tbl );
520: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);
521:
522: commit;
523: --- Saving the Transaction Step Id ,
524: --- With the same step-id Reviewers details also being saved.

Line 557: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_EMP_REVIEW.PROCESS_API';

553: l_transaction_id number;
554: l_trans_tbl hr_transaction_ss.transaction_table;
555: l_count number;
556: l_transaction_step_id number;
557: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_EMP_REVIEW.PROCESS_API';
558: l_result varchar2(100);
559: l_trns_object_version_number number;
560: l_review_proc_call VARCHAR2(30);
561: l_effective_date DATE ;

Line 564: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_reviewer_details',5);

560: l_review_proc_call VARCHAR2(30);
561: l_effective_date DATE ;
562:
563: BEGIN
564: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_reviewer_details',5);
565: --
566: l_review_proc_call := 'PqhEmployeeReview';
567: l_effective_date := SYSDATE;
568:

Line 633: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);

629: ,p_login_person_id => x_login_person_id
630: ,p_transaction_step_id => l_transaction_step_id
631: ,p_api_name => l_api_name
632: ,p_transaction_data => l_trans_tbl );
633: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);
634:
635: commit;
636:
637: EXCEPTION

Line 766: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_api',5);

762: l_attach_status varchar2(80);
763:
764: BEGIN
765:
766: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_api',5);
767: --
768: savepoint process_emp_review_details;
769: --
770: empReviewCsr := get_employee_review(p_transaction_step_id);

Line 953: hr_utility.set_location('merge_attachments Start : l_person_id = ' || l_person_id || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API', 7);

949: --
950: --
951: close reviewer_csr ;
952:
953: hr_utility.set_location('merge_attachments Start : l_person_id = ' || l_person_id || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API', 7);
954:
955: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
956: ,p_dest_pk1_value => l_person_id
957: ,p_return_status => l_attach_status);

Line 959: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',9);

955: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
956: ,p_dest_pk1_value => l_person_id
957: ,p_return_status => l_attach_status);
958:
959: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',9);
960:
961: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);
962: EXCEPTION
963: WHEN hr_utility.hr_error THEN

Line 961: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);

957: ,p_return_status => l_attach_status);
958:
959: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',9);
960:
961: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);
962: EXCEPTION
963: WHEN hr_utility.hr_error THEN
964: ROLLBACK TO process_emp_review_details;
965: RAISE;

Line 1008: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',5);

1004: where person_id = x_Person_Id and event_Id = x_Event_Id;
1005:
1006: Begin
1007: --
1008: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',5);
1009: --
1010: savepoint process_emp_reviewers_details;
1011: --
1012: hr_utility.set_location('p_personId '||p_personId||'Delete Place'||p_status,10);

Line 1113: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_reviewers_api',10);

1109: -- resurrecting the transaction (via update action link), it is then
1110: -- attempted to rollback which would fail if committed here.
1111: -- commit;
1112:
1113: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_reviewers_api',10);
1114: EXCEPTION
1115: WHEN hr_utility.hr_error THEN
1116: ROLLBACK TO process_emp_reviewers_details;
1117: RAISE;