[Home] [Help]
PACKAGE: APPS.PAY_DK_BIK_UTILITY
Source
1 package pay_dk_bik_utility as
2 /* $Header: pydkbiku.pkh 120.0.12000000.1 2007/01/17 18:24:42 appldev noship $ */
3
4
5 function get_table_value (p_bus_group_id in number,
6 p_table_name in varchar2,
7 p_col_name in varchar2,
8 p_row_value in varchar2,
9 p_effective_date in date default null)
10 return varchar2;
11
12
13 function get_vehicle_info
14 ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
15 p_business_group_id in number,
16 p_date_earned in DATE,
17 p_vehicle_allot_id in pqp_vehicle_allocations_f.VEHICLE_ALLOCATION_ID%TYPE,
18 p_lic_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE,
19 p_buying_date OUT NOCOPY pqp_vehicle_repository_f.LAST_REGISTRATION_RENEW_DATE%TYPE,
20 p_buying_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE
21 )
22 return NUMBER;
23 --
24 --
25 END pay_dk_bik_utility;
26