APPS.PQP_VEHICLE_DETAILS_MAPPING dependencies on PQP_VEHICLE_DETAILS

Line 1: PACKAGE BODY PQP_VEHICLE_DETAILS_MAPPING AS

1: PACKAGE BODY PQP_VEHICLE_DETAILS_MAPPING AS
2: --$Header: pqpvhdmp.pkb 115.1 2001/04/04 11:10:25 pkm ship $
3: ---------------------------------------------------------------------------
4: -- GET_VEHICLE_DETAILS_ID --
5: ---------------------------------------------------------------------------

Line 10: l_vehicle_details_id PQP_VEHICLE_DETAILS.vehicle_details_id%TYPE;

6: FUNCTION get_vehicle_details_id
7: ( p_vehicle_details_user_key IN VARCHAR2)
8: RETURN NUMBER IS
9:
10: l_vehicle_details_id PQP_VEHICLE_DETAILS.vehicle_details_id%TYPE;
11:
12: CURSOR veh_cur IS
13: SELECT unique_key_id
14: FROM hr_pump_batch_line_user_keys

Line 39: l_vehicle_details_ovn PQP_VEHICLE_DETAILS.object_version_number%TYPE;

35: FUNCTION get_vehicle_details_ovn
36: ( p_vehicle_details_user_key IN VARCHAR2)
37: RETURN NUMBER IS
38:
39: l_vehicle_details_ovn PQP_VEHICLE_DETAILS.object_version_number%TYPE;
40: CURSOR ovn_cur(p_user_key_value IN VARCHAR2) IS
41: SELECT object_version_number
42: FROM pqp_vehicle_details pvd,
43: hr_pump_batch_line_user_keys key

Line 42: FROM pqp_vehicle_details pvd,

38:
39: l_vehicle_details_ovn PQP_VEHICLE_DETAILS.object_version_number%TYPE;
40: CURSOR ovn_cur(p_user_key_value IN VARCHAR2) IS
41: SELECT object_version_number
42: FROM pqp_vehicle_details pvd,
43: hr_pump_batch_line_user_keys key
44: WHERE key.user_key_value = p_user_key_value
45: AND pvd.vehicle_details_id = key.unique_key_id ;
46: BEGIN

Line 59: END pqp_vehicle_details_mapping;

55: p_vehicle_details_user_key);
56: RAISE;
57: END get_vehicle_details_ovn;
58:
59: END pqp_vehicle_details_mapping;