DBA Data[Home] [Help]

APPS.PQH_PROCESS_ACADEMIC_RANK dependencies on PQH_PROCESS_ACADEMIC_RANK

Line 1: PACKAGE BODY pqh_process_academic_rank AS

1: PACKAGE BODY pqh_process_academic_rank AS
2: /* $Header: pqhusark.pkb 120.3 2006/12/05 07:41:24 rpasumar noship $*/
3:
4: --
5: --

Line 45: AND s.api_name = 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API'

41: FROM hr_api_transaction_steps s,
42: hr_api_transaction_values a
43: WHERE s.transaction_step_id = a.transaction_step_id
44: and s.transaction_step_id = p_transaction_step_id
45: AND s.api_name = 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API'
46: )
47: ) rank ;
48:
49: RETURN csr;

Line 69: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);

65: l_transaction_step_id number;
66: l_api_name hr_api_transaction_steps.api_name%TYPE;
67:
68: BEGIN
69: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);
70: --
71: l_transaction_step_id := to_number(x_transaction_step_id);
72: --
73:

Line 115: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);

111: hr_transaction_api.get_varchar2_value
112: (p_transaction_step_id => l_transaction_step_id
113: ,p_name => 'P_PERSON_EXTRA_INFO_ID');
114: --
115: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);
116: EXCEPTION
117: WHEN hr_utility.hr_error THEN
118: hr_utility.raise_error;
119: WHEN OTHERS THEN

Line 148: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API';

144: l_transaction_id number;
145: l_trans_tbl hr_transaction_ss.transaction_table;
146: l_count number;
147: l_transaction_step_id number;
148: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API';
149: l_result varchar2(100);
150: l_trns_object_version_number number;
151: l_review_proc_call VARCHAR2(30);
152: l_effective_date DATE ;

Line 155: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);

151: l_review_proc_call VARCHAR2(30);
152: l_effective_date DATE ;
153:
154: BEGIN
155: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);
156: l_review_proc_call := 'PqhAcademicRankReview';
157: l_effective_date := SYSDATE;
158: --
159: hr_transaction_api.get_transaction_step_info

Line 225: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);

221: ,p_transaction_step_id => l_transaction_step_id
222: ,p_api_name => l_api_name
223: ,p_transaction_data => l_trans_tbl );
224:
225: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);
226: commit;
227: EXCEPTION
228: WHEN hr_utility.hr_error THEN
229: hr_utility.raise_error;

Line 251: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.process_api',5);

247: l_pei_information4 VARCHAR2(255);
248: l_pei_information5 VARCHAR2(255);
249:
250: BEGIN
251: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.process_api',5);
252: --
253: savepoint process_academic_rank_details;
254: --
255:

Line 313: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.process_api',5);

309: p_object_version_number => l_ovn );
310: --
311: END IF;
312: --
313: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.process_api',5);
314: --
315: -- ns 5/19/2005: BUG 4381336: commenting commit as it is called while
316: -- resurrecting the transaction (via update action link), it is then
317: -- attempted to rollback which would fail if committed here.