1562: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
1563: THEN
1564: SELECT NVL( p_id, vea_packages_s.NEXTVAL )
1565: INTO l_package_id
1566: FROM DUAL;
1567: ELSE
1568: SELECT vea_packages_s.NEXTVAL
1569: INTO l_package_id
1570: FROM DUAL;
1566: FROM DUAL;
1567: ELSE
1568: SELECT vea_packages_s.NEXTVAL
1569: INTO l_package_id
1570: FROM DUAL;
1571: END IF;
1572: --
1573: --
1574: --