3324: PROCEDURE pop_po_def_option_hier(p_org_id IN NUMBER,
3325: p_application_id IN NUMBER,
3326: p_return_status OUT NOCOPY VARCHAR2)
3327: IS
3328: status_flag fnd_product_installations.status%TYPE;
3329:
3330: CURSOR get_status_flag_csr(c_application_id NUMBER) IS
3331: SELECT status
3332: FROM fnd_product_installations
3328: status_flag fnd_product_installations.status%TYPE;
3329:
3330: CURSOR get_status_flag_csr(c_application_id NUMBER) IS
3331: SELECT status
3332: FROM fnd_product_installations
3333: WHERE application_id = c_application_id;
3334:
3335: CURSOR c_po_default_options (c_org_id NUMBER,
3336: c_application_id NUMBER) IS