APPS.PQH_PROCESS_TENURE_STATUS dependencies on PQH_PROCESS_TENURE_STATUS

Line 1: PACKAGE BODY pqh_process_tenure_status AS

1: PACKAGE BODY pqh_process_tenure_status AS
2: /* $Header: pqhusten.pkb 120.0 2005/05/29 02:08:35 appldev noship $*/
3:
4: PROCEDURE rollback_transaction(
5: itemType IN VARCHAR2,

Line 81: AND s.api_name = 'PQH_PROCESS_TENURE_STATUS.PROCESS_API'

77: FROM hr_api_transaction_steps s,
78: hr_api_transaction_values a
79: WHERE s.transaction_step_id = a.transaction_step_id
80: and s.transaction_step_id = p_transaction_step_id
81: AND s.api_name = 'PQH_PROCESS_TENURE_STATUS.PROCESS_API'
82: )
83: ) tenure ,
84: hr_lookups hl
85: where hl.lookup_type = 'PQH_TENURE_STATUS'

Line 193: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_TENURE_STATUS.PROCESS_API';

189: l_transaction_id number;
190: l_trans_tbl hr_transaction_ss.transaction_table;
191: l_count number;
192: l_transaction_step_id number;
193: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_TENURE_STATUS.PROCESS_API';
194: l_result varchar2(100);
195: l_trns_object_version_number number;
196: l_review_proc_call VARCHAR2(30);
197: l_effective_date DATE ;

Line 413: END pqh_process_tenure_status;

409: --
410: END self_or_subordinate;
411: --
412:
413: END pqh_process_tenure_status;