APPS.PQH_PROCESS_EMP_REVIEW dependencies on HR_API_TRANSACTION_STEPS

Line 97: FROM hr_api_transaction_steps s,

93: decode(a.name, 'P_COMMENTS' , a.varchar2_value ,null) Comments,
94: decode(a.name, 'P_ASSIGNMENT_ID' , a.varchar2_value ,null) Assignment_Id,
95: decode(a.name, 'P_NOTIFY_FLAG' , a.varchar2_value ,null) Notify_Flag,
96: decode(a.name, 'P_BUSINESS_GROUP_ID' , a.varchar2_value ,null) Business_Group_Id
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'

Line 166: l_api_name hr_api_transaction_steps.api_name%TYPE;

162: ) IS
163: ----
164:
165: l_transaction_step_id number;
166: l_api_name hr_api_transaction_steps.api_name%TYPE;
167:
168:
169: BEGIN
170:

Line 322: l_api_name hr_api_transaction_steps.api_name%TYPE;

318: ) IS
319:
320:
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: --

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 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 749: from hr_api_transaction_steps

745:
746: --
747: cursor c_empName is
748: select wf_engine.GetItemAttrText(item_type, item_key, 'CURRENT_PERSON_DISPLAY_NAME')
749: from hr_api_transaction_steps
750: where transaction_step_id = p_transaction_step_id;
751:
752: reviewer_csr REF_CURSOR;
753: empReviewCsr REF_CURSOR;