2730: PROCEDURE pop_po_def_option_hier(p_org_id IN NUMBER,
2731: p_application_id IN NUMBER,
2732: p_return_status OUT NOCOPY VARCHAR2)
2733: IS
2734: status_flag fnd_product_installations.status%TYPE;
2735:
2736: CURSOR get_status_flag_csr(c_application_id NUMBER) IS
2737: SELECT status
2738: FROM fnd_product_installations
2734: status_flag fnd_product_installations.status%TYPE;
2735:
2736: CURSOR get_status_flag_csr(c_application_id NUMBER) IS
2737: SELECT status
2738: FROM fnd_product_installations
2739: WHERE application_id = c_application_id;
2740:
2741: CURSOR c_po_default_options (c_org_id NUMBER,
2742: c_application_id NUMBER) IS