APPS.PQP_PCV_BUS dependencies on PQP_CONFIGURATION_TYPES

Line 563: -- pqp_configuration_types table

559: -- ----------------------------------------------------------------------------
560: -- |------------------------< chk_mandatory_fields >------------------------|
561: -- ----------------------------------------------------------------------------
562: --Checking each segment value sequencialy based on total_unique_columns count in
563: -- pqp_configuration_types table
564: PROCEDURE chk_mandatory_fields
565: (p_rec IN pqp_pcv_shd.g_rec_type
566: ,p_flag IN VARCHAR2
567: ) IS

Line 572: from pqp_configuration_types

568:
569: --Declare the cursor to get the registration number count
570: CURSOR config_unique_col_cursor IS
571: Select total_unique_columns
572: from pqp_configuration_types
573: where configuration_type =p_rec.pcv_information_category;
574:
575: --Declare local variable
576: l_count number;

Line 789: FROM pqp_configuration_types

785: IS
786: SELECT multiple_occurences_flag
787: ,description
788: ,total_unique_columns
789: FROM pqp_configuration_types
790: WHERE configuration_type = c_config_type
791: AND (
792: (legislation_code IS NOT NULL AND
793: legislation_code = c_legislation_code

Line 816: l_mult_occurrence pqp_configuration_types.multiple_occurences_flag%TYPE;

812: AND NVL(business_group_id, hr_api.g_number) = NVL(c_business_group_id, hr_api.g_number)
813: AND NVL(legislation_code, hr_api.g_varchar2) = NVL(c_legislation_code, hr_api.g_varchar2);
814:
815: l_legislation_code per_business_groups.legislation_code%TYPE;
816: l_mult_occurrence pqp_configuration_types.multiple_occurences_flag%TYPE;
817: l_exists NUMBER;
818: l_config_desc pqp_configuration_types.description%TYPE;
819: l_total_uniq_cols NUMBER;
820:

Line 818: l_config_desc pqp_configuration_types.description%TYPE;

814:
815: l_legislation_code per_business_groups.legislation_code%TYPE;
816: l_mult_occurrence pqp_configuration_types.multiple_occurences_flag%TYPE;
817: l_exists NUMBER;
818: l_config_desc pqp_configuration_types.description%TYPE;
819: l_total_uniq_cols NUMBER;
820:
821: --
822: Begin