1 PACKAGE pay_hours_by_rate AS
2 /* $Header: payhoursbyrate.pkh 120.1 2006/04/13 14:38 ahanda noship $ */
3 /* ******************************************************************
4 * *
5 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
6 * Chertsey, England. *
7 * *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation UK Ltd, *
17 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
18 * England. *
19 * *
20 ******************************************************************
21
22 Change List
23 -----------
24 Date Name Vers Bug No Description
25 ----------- ---------- ----- ------- -----------------------------------
26 01-FEB-2005 ahanda 115.0 4118279 Created
27 13-APR-2006 ahanda 115.1 Added global variables for amount
28
29 */
30
31 gn_amt_input_value_id NUMBER;
32 gn_rate_input_value_id NUMBER;
33 gn_hour_input_value_id NUMBER;
34 gn_mult_input_value_id NUMBER;
35
36 gn_amt_result_value NUMBER;
37 gn_rate_result_value NUMBER;
38 gn_hour_result_value NUMBER;
39 gn_mult_result_value NUMBER;
40
41 gn_element_type_id NUMBER;
42 gn_run_result_id NUMBER;
43
44 /******************************************************************
45 ** Function used in the pay_hours_by_rate_v to return the value
46 ** depending on the mode i.e. Hours, Rate and Multiple
47 ******************************************************************/
48 FUNCTION get_result_value(p_run_result_id in number
49 ,p_element_type_id in number
50 ,p_mode in varchar2)
51 RETURN NUMBER;
52
53 END pay_hours_by_rate;