PACKAGE: APPS.PAY_DK_BIK_UTILITY

Source

1 package pay_dk_bik_utility AUTHID CURRENT_USER as
2 /* $Header: pydkbiku.pkh 120.3 2012/01/19 09:00:27 rpahune ship $ */
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   p_green_environment_fee OUT NOCOPY number -- 9676720 fix
22 )
23 return NUMBER;
24 --
25 --
26 END pay_dk_bik_utility;
27