APPS.CZ_BOM_SYNCH dependencies on CZ_EXV_APC_PROPERTIES

Line 588: l_database_column cz_exv_apc_properties.database_column%TYPE;

584: l_flag PLS_INTEGER;
585: position NUMBER;
586: l_src_application_id cz_properties.src_application_id%TYPE;
587: l_item_catalog_group_id cz_exv_item_master.item_catalog_group_id%TYPE;
588: l_database_column cz_exv_apc_properties.database_column%TYPE;
589: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;
590: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
591:
592: BEGIN

Line 589: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;

585: position NUMBER;
586: l_src_application_id cz_properties.src_application_id%TYPE;
587: l_item_catalog_group_id cz_exv_item_master.item_catalog_group_id%TYPE;
588: l_database_column cz_exv_apc_properties.database_column%TYPE;
589: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;
590: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
591:
592: BEGIN
593: FOR c_prop IN (SELECT name, data_type, property_value, property_num_value , p.src_application_id

Line 590: l_attr_id cz_exv_apc_properties.attr_id%TYPE;

586: l_src_application_id cz_properties.src_application_id%TYPE;
587: l_item_catalog_group_id cz_exv_item_master.item_catalog_group_id%TYPE;
588: l_database_column cz_exv_apc_properties.database_column%TYPE;
589: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;
590: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
591:
592: BEGIN
593: FOR c_prop IN (SELECT name, data_type, property_value, property_num_value , p.src_application_id
594: FROM cz_properties p, cz_item_property_values v

Line 635: ' FROM cz_exv_apc_properties'|| targetLinkName ||

631: position := INSTR(c_prop.name,'.');
632:
633: EXECUTE IMMEDIATE
634: 'SELECT distinct database_column, attr_group_id, attr_id'||
635: ' FROM cz_exv_apc_properties'|| targetLinkName ||
636: ' WHERE application_id = :1 '||
637: ' AND attr_group_name = :2 '||
638: ' AND attr_name = :3 '||
639: ' AND item_catalog_group_id IN (SELECT item_catalog_group_id '||

Line 656: ' FROM cz_exv_apc_properties'|| targetLinkName ||

652:
653: IF elementValue IS NULL THEN
654: EXECUTE IMMEDIATE
655: 'SELECT default_value '||
656: ' FROM cz_exv_apc_properties'|| targetLinkName ||
657: ' WHERE application_id = :1 '||
658: ' AND attr_group_id = :2 '||
659: ' AND attr_id = :3 '
660: INTO elementValue