APPS.CZ_BOM_SYNCH dependencies on CZ_EXV_APC_PROPERTIES

Line 587: elementValue cz_exv_apc_properties.default_value%TYPE; --bug 10207827;

583:
584: PROCEDURE verify_item_properties(j IN PLS_INTEGER) IS
585:
586: TL_TEXT_TYPE CONSTANT NUMBER := 8;
587: elementValue cz_exv_apc_properties.default_value%TYPE; --bug 10207827;
588: l_val VARCHAR2(4000);
589: l_flag PLS_INTEGER;
590: position NUMBER;
591: l_src_application_id cz_properties.src_application_id%TYPE;

Line 593: l_database_column cz_exv_apc_properties.database_column%TYPE;

589: l_flag PLS_INTEGER;
590: position NUMBER;
591: l_src_application_id cz_properties.src_application_id%TYPE;
592: l_item_catalog_group_id cz_exv_item_master.item_catalog_group_id%TYPE;
593: l_database_column cz_exv_apc_properties.database_column%TYPE;
594: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;
595: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
596:
597: BEGIN

Line 594: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;

590: position NUMBER;
591: l_src_application_id cz_properties.src_application_id%TYPE;
592: l_item_catalog_group_id cz_exv_item_master.item_catalog_group_id%TYPE;
593: l_database_column cz_exv_apc_properties.database_column%TYPE;
594: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;
595: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
596:
597: BEGIN
598: FOR c_prop IN (SELECT name, data_type, property_value, property_num_value , p.src_application_id

Line 595: l_attr_id cz_exv_apc_properties.attr_id%TYPE;

591: l_src_application_id cz_properties.src_application_id%TYPE;
592: l_item_catalog_group_id cz_exv_item_master.item_catalog_group_id%TYPE;
593: l_database_column cz_exv_apc_properties.database_column%TYPE;
594: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;
595: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
596:
597: BEGIN
598: FOR c_prop IN (SELECT name, data_type, property_value, property_num_value , p.src_application_id
599: FROM cz_properties p, cz_item_property_values v

Line 641: ' FROM cz_exv_apc_properties'|| targetLinkName ||

637: position := INSTR(c_prop.name,'.');
638:
639: EXECUTE IMMEDIATE
640: 'SELECT distinct database_column, attr_group_id, attr_id'||
641: ' FROM cz_exv_apc_properties'|| targetLinkName ||
642: ' WHERE application_id = :1 '||
643: ' AND attr_group_name = :2 '||
644: ' AND attr_name = :3 '||
645: ' AND item_catalog_group_id IN (SELECT item_catalog_group_id '||

Line 662: ' FROM cz_exv_apc_properties'|| targetLinkName ||

658:
659: IF elementValue IS NULL THEN
660: EXECUTE IMMEDIATE
661: 'SELECT default_value '||
662: ' FROM cz_exv_apc_properties'|| targetLinkName ||
663: ' WHERE application_id = :1 '||
664: ' AND attr_group_id = :2 '||
665: ' AND attr_id = :3 '
666: INTO elementValue