eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PVD_BUS dependencies on PQP_PVD_BUS

Line 1: Package Body pqp_pvd_bus as

1: Package Body pqp_pvd_bus as
2: /* $Header: pqpvdrhi.pkb 115.6 2003/02/17 22:14:43 tmehra noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pqp_pvd_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqp_pvd_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 110: if ( nvl(pqp_pvd_bus.g_vehicle_details_id, hr_api.g_number)

106: ,p_argument => 'vehicle_details_id'
107: ,p_argument_value => p_vehicle_details_id
108: );
109: --
110: if ( nvl(pqp_pvd_bus.g_vehicle_details_id, hr_api.g_number)
111: = p_vehicle_details_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 117: l_legislation_code := pqp_pvd_bus.g_legislation_code;

113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := pqp_pvd_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function

Line 141: pqp_pvd_bus.g_vehicle_details_id:= p_vehicle_details_id;

137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: pqp_pvd_bus.g_vehicle_details_id:= p_vehicle_details_id;
142: pqp_pvd_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;

Line 142: pqp_pvd_bus.g_legislation_code := l_legislation_code;

138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: pqp_pvd_bus.g_vehicle_details_id:= p_vehicle_details_id;
142: pqp_pvd_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;

Line 677: pqp_pvd_bus.check_fuel_type_code(p_rec.vehicle_details_id,

673: -- Remove this comment when the edit has been completed.
674: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
675: --
676: -- Check for the validity of the fuel code
677: pqp_pvd_bus.check_fuel_type_code(p_rec.vehicle_details_id,
678: p_rec.fuel_type,
679: p_effective_date );
680: -- Check for the validity of the vehicle type code
681: pqp_pvd_bus.check_vehicle_type_code(p_rec.vehicle_details_id,

Line 681: pqp_pvd_bus.check_vehicle_type_code(p_rec.vehicle_details_id,

677: pqp_pvd_bus.check_fuel_type_code(p_rec.vehicle_details_id,
678: p_rec.fuel_type,
679: p_effective_date );
680: -- Check for the validity of the vehicle type code
681: pqp_pvd_bus.check_vehicle_type_code(p_rec.vehicle_details_id,
682: p_rec.vehicle_type,
683: p_effective_date );
684:
685: -- These are checks for values that cannot be negative

Line 686: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);

682: p_rec.vehicle_type,
683: p_effective_date );
684:
685: -- These are checks for values that cannot be negative
686: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
687: pqp_pvd_bus.check_negative(p_rec.list_price);
688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);

Line 687: pqp_pvd_bus.check_negative(p_rec.list_price);

683: p_effective_date );
684:
685: -- These are checks for values that cannot be negative
686: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
687: pqp_pvd_bus.check_negative(p_rec.list_price);
688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
691: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);

Line 688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);

684:
685: -- These are checks for values that cannot be negative
686: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
687: pqp_pvd_bus.check_negative(p_rec.list_price);
688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
691: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
692: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);

Line 689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);

685: -- These are checks for values that cannot be negative
686: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
687: pqp_pvd_bus.check_negative(p_rec.list_price);
688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
691: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
692: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
693:

Line 690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);

686: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
687: pqp_pvd_bus.check_negative(p_rec.list_price);
688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
691: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
692: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
693:
694: -- Vehicle Ownership check

Line 691: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);

687: pqp_pvd_bus.check_negative(p_rec.list_price);
688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
691: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
692: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
693:
694: -- Vehicle Ownership check
695: IF p_rec.vehicle_ownership IS NOT NULL THEN

Line 692: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);

688: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
689: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
690: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
691: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
692: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
693:
694: -- Vehicle Ownership check
695: IF p_rec.vehicle_ownership IS NOT NULL THEN
696: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);

Line 696: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);

692: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
693:
694: -- Vehicle Ownership check
695: IF p_rec.vehicle_ownership IS NOT NULL THEN
696: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);
697: END IF;
698: -- Check if the Input Currency matches the BG Currency
699: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);
700: --

Line 699: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);

695: IF p_rec.vehicle_ownership IS NOT NULL THEN
696: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);
697: END IF;
698: -- Check if the Input Currency matches the BG Currency
699: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);
700: --
701: pqp_pvd_bus.chk_ddf(p_rec);
702: --
703: pqp_pvd_bus.chk_df(p_rec);

Line 701: pqp_pvd_bus.chk_ddf(p_rec);

697: END IF;
698: -- Check if the Input Currency matches the BG Currency
699: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);
700: --
701: pqp_pvd_bus.chk_ddf(p_rec);
702: --
703: pqp_pvd_bus.chk_df(p_rec);
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 703: pqp_pvd_bus.chk_df(p_rec);

699: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);
700: --
701: pqp_pvd_bus.chk_ddf(p_rec);
702: --
703: pqp_pvd_bus.chk_df(p_rec);
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: End insert_validate;
707: --

Line 740: pqp_pvd_bus.check_fuel_type_code(p_rec.vehicle_details_id,

736: -- Remove this comment when the edit has been completed.
737: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
738: --
739: --Validate FUEL_TYPE
740: pqp_pvd_bus.check_fuel_type_code(p_rec.vehicle_details_id,
741: p_rec.fuel_type,
742: p_effective_date);
743:
744: -- Check for the validity of the vehicle type code

Line 745: pqp_pvd_bus.check_vehicle_type_code(p_rec.vehicle_details_id,

741: p_rec.fuel_type,
742: p_effective_date);
743:
744: -- Check for the validity of the vehicle type code
745: pqp_pvd_bus.check_vehicle_type_code(p_rec.vehicle_details_id,
746: p_rec.vehicle_type,
747: p_effective_date );
748: -- These are checks for values that cannot be negative
749: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);

Line 749: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);

745: pqp_pvd_bus.check_vehicle_type_code(p_rec.vehicle_details_id,
746: p_rec.vehicle_type,
747: p_effective_date );
748: -- These are checks for values that cannot be negative
749: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
750: pqp_pvd_bus.check_negative(p_rec.list_price);
751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);

Line 750: pqp_pvd_bus.check_negative(p_rec.list_price);

746: p_rec.vehicle_type,
747: p_effective_date );
748: -- These are checks for values that cannot be negative
749: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
750: pqp_pvd_bus.check_negative(p_rec.list_price);
751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);

Line 751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);

747: p_effective_date );
748: -- These are checks for values that cannot be negative
749: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
750: pqp_pvd_bus.check_negative(p_rec.list_price);
751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
755: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);

Line 752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);

748: -- These are checks for values that cannot be negative
749: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
750: pqp_pvd_bus.check_negative(p_rec.list_price);
751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
755: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
756: -- Vehicle Ownership check

Line 753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);

749: pqp_pvd_bus.check_negative(p_rec.engine_capacity_in_cc);
750: pqp_pvd_bus.check_negative(p_rec.list_price);
751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
755: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
756: -- Vehicle Ownership check
757: IF p_rec.vehicle_ownership IS NOT NULL THEN

Line 754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);

750: pqp_pvd_bus.check_negative(p_rec.list_price);
751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
755: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
756: -- Vehicle Ownership check
757: IF p_rec.vehicle_ownership IS NOT NULL THEN
758: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);

Line 755: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);

751: pqp_pvd_bus.check_negative(p_rec.accessory_value_at_startdate);
752: pqp_pvd_bus.check_negative(p_rec.accessory_value_added_later);
753: --pqp_pvd_bus.check_negative(p_rec.capital_contributions);
754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
755: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
756: -- Vehicle Ownership check
757: IF p_rec.vehicle_ownership IS NOT NULL THEN
758: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);
759: END IF;

Line 758: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);

754: --pqp_pvd_bus.check_negative(p_rec.private_use_contributions);
755: pqp_pvd_bus.check_negative(p_rec.market_value_classic_car);
756: -- Vehicle Ownership check
757: IF p_rec.vehicle_ownership IS NOT NULL THEN
758: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);
759: END IF;
760: -- Check if the Input currency matches the BG currency
761: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);
762: --

Line 761: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);

757: IF p_rec.vehicle_ownership IS NOT NULL THEN
758: pqp_pvd_bus.check_vehicle_ownership(p_rec.vehicle_ownership);
759: END IF;
760: -- Check if the Input currency matches the BG currency
761: pqp_pvd_bus.check_currency_code(p_rec.currency_code,p_rec.business_group_id);
762: --
763: chk_non_updateable_args
764: (p_effective_date => p_effective_date
765: ,p_rec => p_rec

Line 769: pqp_pvd_bus.chk_ddf(p_rec);

765: ,p_rec => p_rec
766: );
767: --
768: --
769: pqp_pvd_bus.chk_ddf(p_rec);
770: --
771: pqp_pvd_bus.chk_df(p_rec);
772: --
773: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 771: pqp_pvd_bus.chk_df(p_rec);

767: --
768: --
769: pqp_pvd_bus.chk_ddf(p_rec);
770: --
771: pqp_pvd_bus.chk_df(p_rec);
772: --
773: hr_utility.set_location(' Leaving:'||l_proc, 10);
774: End update_validate;
775: --

Line 790: pqp_pvd_bus.check_assignment_exists(p_rec.vehicle_details_id);

786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788: -- Call all supporting business operations
789: --
790: pqp_pvd_bus.check_assignment_exists(p_rec.vehicle_details_id);
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 10);
793: End delete_validate;
794: --

Line 795: end pqp_pvd_bus;

791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 10);
793: End delete_validate;
794: --
795: end pqp_pvd_bus;