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_VRE_BUS dependencies on PQP_VEHICLE_REPOSITORY_F

Line 31: , pqp_vehicle_repository_f vre

27: CURSOR csr_sec_grp IS
28: SELECT pbg.security_group_id,
29: pbg.legislation_code
30: FROM per_business_groups_perf pbg
31: , pqp_vehicle_repository_f vre
32: WHERE vre.vehicle_repository_id = p_vehicle_repository_id
33: AND pbg.business_group_id = vre.business_group_id;
34:
35: --

Line 102: ,pqp_vehicle_repository_f vre

98: --
99: CURSOR csr_leg_code IS
100: SELECT pbg.legislation_code
101: FROM per_business_groups_perf pbg
102: ,pqp_vehicle_repository_f vre
103: WHERE vre.vehicle_repository_id = p_vehicle_repository_id
104: AND pbg.business_group_id = vre.business_group_id;
105: --
106: -- Declare local variables

Line 682: FROM pqp_vehicle_repository_f pvr

678:
679: --Declare the cursor to get the registration number count
680: CURSOR c_iden_exist_cursor IS
681: SELECT COUNT(pvr.vehicle_id_number)
682: FROM pqp_vehicle_repository_f pvr
683: WHERE pvr.vehicle_id_number=p_rec.vehicle_id_number
684: AND pvr.business_group_id=p_rec.business_group_id
685: AND (p_effective_date BETWEEN pvr.effective_start_date
686: AND pvr.effective_end_date

Line 692: FROM pqp_vehicle_repository_f pvr

688:
689: --Cursor to get the previous vehicle_id_number
690: CURSOR c_chk_previous_value_cur IS
691: SELECT pvr.vehicle_id_number
692: FROM pqp_vehicle_repository_f pvr
693: WHERE pvr.registration_number=p_rec.registration_number
694: AND pvr.business_group_id=p_rec.business_group_id
695: AND (p_effective_date BETWEEN pvr.effective_start_date
696: AND pvr.effective_end_date

Line 702: l_previous_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;

698:
699:
700: --Declare local variable
701: l_count number;
702: l_previous_id_number pqp_vehicle_repository_f.vehicle_id_number%TYPE;
703: BEGIN
704: IF p_update_flag = 'Y' THEN
705: OPEN c_chk_previous_value_cur;
706: FETCH c_chk_previous_value_cur INTO l_previous_id_number;

Line 748: FROM pqp_vehicle_repository_f pvr

744:
745: --Declare the cursor to get the registration number count
746: CURSOR reg_exist_cursor IS
747: SELECT COUNT(pvr.registration_number)
748: FROM pqp_vehicle_repository_f pvr
749: WHERE pvr.registration_number=p_rec.registration_number
750: AND pvr.business_group_id=p_rec.business_group_id
751: AND (p_effective_date BETWEEN pvr.effective_start_date
752: AND pvr.effective_end_date

Line 1132: FROM PQP_VEHICLE_ALLOCATIONS_F pva,pqp_vehicle_repository_f pvr

1128: ) RETURN NUMBER IS
1129: --Getting the vehicle allocation count for repositoryId
1130: CURSOR c_alloc_count_cursor IS
1131: SELECT pvr.vehicle_status ,1 test
1132: FROM PQP_VEHICLE_ALLOCATIONS_F pva,pqp_vehicle_repository_f pvr
1133: WHERE pva.vehicle_repository_id= p_vehicle_repository_id
1134: AND pva.vehicle_repository_id =pvr.vehicle_repository_id
1135: AND pva.business_group_id = pvr.business_group_id
1136: AND (p_effective_date between pva.effective_start_date

Line 1145: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%TYPE;

1141: OR p_effective_date <= pvr.effective_start_date)
1142: AND pva.business_group_id = p_business_group_id;
1143:
1144: --Declare local variables
1145: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%TYPE;
1146: l_test_number NUMBER;
1147:
1148: BEGIN
1149: OPEN c_alloc_count_cursor;

Line 1476: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;

1472: --
1473: l_proc varchar2(72) := g_package||'insert_validate';
1474: l_return_status NUMBER ;
1475: l_message VARCHAR2(2500) ;
1476: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
1477: l_share_conf_value pqp_vehicle_repository_f.shared_vehicle%TYPE;
1478: l_legislation_code varchar2(150);
1479: --
1480:

Line 1477: l_share_conf_value pqp_vehicle_repository_f.shared_vehicle%TYPE;

1473: l_proc varchar2(72) := g_package||'insert_validate';
1474: l_return_status NUMBER ;
1475: l_message VARCHAR2(2500) ;
1476: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
1477: l_share_conf_value pqp_vehicle_repository_f.shared_vehicle%TYPE;
1478: l_legislation_code varchar2(150);
1479: --
1480:
1481: BEGIN

Line 1846: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;

1842: --
1843: l_proc VARCHAR2(72) := g_package||'update_validate';
1844: l_return_status NUMBER ;
1845: l_message VARCHAR2(2500) ;
1846: l_currency_code pqp_vehicle_repository_f.currency_code%TYPE;
1847: l_legislation_code varchar2(150);
1848: l_return_message varchar2(2000);
1849:
1850: --