50: x_return_status := fnd_api.g_ret_sts_success ;
51:
52:
53: BEGIN
54: SELECT 'Y' into v_temp from dual
55: WHERE exists
56: (SELECT 1 from
57: po_asl_attributes paa,
58: po_approved_supplier_list pasl,
82: INTO l_sob_id
83: FROM org_organization_definitions OOD
84: WHERE OOD.organization_id = p_organization_id;
85:
86: select 'Y' INTO v_temp from dual where exists
87: (
88: select paa.asl_id
89: from
90: po_vendors pv,