APPS.PQP_PVD_BUS dependencies on PQP_VEHICLE_DETAILS

Line 29: , pqp_vehicle_details pvd

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pqp_vehicle_details pvd
30: where pvd.vehicle_details_id = p_vehicle_details_id
31: and pbg.business_group_id = pvd.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pqp_vehicle_details pvd

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pqp_vehicle_details pvd
90: where pvd.vehicle_details_id = p_vehicle_details_id
91: and pbg.business_group_id (+) = pvd.business_group_id;
92: --
93: -- Declare local variables

Line 489: (p_vehicle_details_id IN PQP_VEHICLE_DETAILS.Vehicle_Details_Id%TYPE,

485: -- ----------------------------------------------------------------------------
486: -- |---------------------------< check_fuel_type_code >-----------------------|
487: -- ----------------------------------------------------------------------------
488: Procedure check_fuel_type_code
489: (p_vehicle_details_id IN PQP_VEHICLE_DETAILS.Vehicle_Details_Id%TYPE,
490: p_fuel_type_code IN VARCHAR2,
491: p_effective_date IN DATE) is
492:
493: l_proc varchar2(72) := g_package||' check_fuel_type_code';

Line 520: (p_vehicle_ownership IN PQP_VEHICLE_DETAILS.Vehicle_Ownership%TYPE

516: -- ----------------------------------------------------------------------------
517: -- |-------------------------< check_vehicle_ownership >----------------------|
518: -- ----------------------------------------------------------------------------
519: Procedure check_vehicle_ownership
520: (p_vehicle_ownership IN PQP_VEHICLE_DETAILS.Vehicle_Ownership%TYPE
521: ) is
522:
523: l_proc varchar2(72) := g_package||' check_vehicle_ownership';
524:

Line 541: (p_vehicle_details_id IN PQP_VEHICLE_DETAILS.vehicle_details_id%TYPE

537: -- ----------------------------------------------------------------------------
538: -- |-------------------------< check_assignment_exists >----------------------|
539: -- ----------------------------------------------------------------------------
540: Procedure check_assignment_exists
541: (p_vehicle_details_id IN PQP_VEHICLE_DETAILS.vehicle_details_id%TYPE
542: ) is
543:
544: l_proc varchar2(72) := g_package||' check_assignment_exists';
545: CURSOR veh_cur IS

Line 574: (p_currency_code IN PQP_VEHICLE_DETAILS.currency_code%TYPE,

570: -- |-------------------------< check_currency_code >---------------------------|
571:
572: -- ----------------------------------------------------------------------------
573: Procedure check_currency_code
574: (p_currency_code IN PQP_VEHICLE_DETAILS.currency_code%TYPE,
575: p_in_business_group_id IN NUMBER
576: ) IS
577:
578: l_proc varchar2(72) := g_package||' check_currency_code';

Line 600: (p_vehicle_details_id IN PQP_VEHICLE_DETAILS.Vehicle_Details_Id%TYPE,

596: -- ----------------------------------------------------------------------------
597: -- |---------------------------< check_vehicle_type_code >--------------------|
598: -- ----------------------------------------------------------------------------
599: Procedure check_vehicle_type_code
600: (p_vehicle_details_id IN PQP_VEHICLE_DETAILS.Vehicle_Details_Id%TYPE,
601: p_vehicle_type_code IN VARCHAR2,
602: p_effective_date IN DATE) is
603:
604: l_proc varchar2(72) := g_package||' check_vehicle_type_code';