[Home] [Help]
146: v_application_id NUMBER
147: ,v_flex_field_name VARCHAR2
148: ,v_field_value VARCHAR2) IS
149: SELECT 1
150: FROM sys.DUAL
151: WHERE EXISTS ( SELECT 1
152: FROM fnd_descr_flex_contexts
153: WHERE application_id = v_application_id AND
154: descriptive_flexfield_name =
418: 'ATTRIBUTE29', p_flex_record.attribute29,
419: 'ATTRIBUTE30', p_flex_record.attribute30
420: )
421: INTO l_field_value
422: FROM sys.DUAL;
423:
424: OPEN get_desc_flex_name(UPPER(p_Table_name));
425: FETCH get_desc_flex_name INTO l_flex_name, l_appl_id;
426: IF get_desc_flex_name%FOUND THEN
702: /* Cursor Definitions. */
703: /* =================== */
704: CURSOR Cur_ownerorgn_id IS
705: SELECT 1
706: FROM SYS.DUAL
707: WHERE EXISTS (SELECT 1
708: from org_access_view a, mtl_parameters b
709: where a.organization_id = b.organization_id
710: and b.organization_id = powner_orgn_id
1018: FROM gmd_vpd_security;
1019:
1020: CURSOR Cur_check_orgn_access (V_default_user_id PLS_INTEGER) IS
1021: SELECT 1
1022: FROM sys.dual
1023: WHERE EXISTS ( SELECT 1
1024: FROM gmd_security_profiles sp
1025: WHERE sp.access_type_ind = 'U'
1026: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1446: p_recipe_use IN NUMBER) IS
1447:
1448: CURSOR c_get_vr_id IS
1449: SELECT gmd_recipe_validity_id_s.NEXTVAL
1450: FROM FND_DUAL;
1451:
1452: CURSOR c_get_formula IS
1453: SELECT creation_date, formula_status, owner_organization_id
1454: FROM fm_form_mst_b
1673: LocalRoutRecord c_get_routing_info%ROWTYPE;
1674:
1675: CURSOR c_get_recipe_id IS
1676: SELECT gmd_recipe_id_s.NEXTVAL
1677: FROM FND_DUAL;
1678:
1679: CURSOR c_get_item_id IS
1680: SELECT inventory_item_id
1681: FROM fm_matl_dtl
2201: * Checks if the uom_code passed is valid - Return True if it exists *
2202: * *********************************************************************** */
2203: FUNCTION Validate_um(pItem_uom_code IN VARCHAR2) RETURN BOOLEAN IS
2204: Cursor Item_um_cur IS
2205: Select 1 from dual
2206: Where exists (Select 1 from mtl_units_of_measure
2207: Where uom_code = pItem_uom_code);
2208: l_dummy_cnt NUMBER;
2209: BEGIN
2574: l_exists PLS_INTEGER;
2575:
2576: CURSOR Cur_get_master_org IS
2577: SELECT 1
2578: FROM sys.dual
2579: WHERE EXISTS (SELECT 1
2580: FROM mtl_parameters
2581: WHERE master_organization_id = p_organization_id);
2582: BEGIN
2651: ORDER BY revision;
2652:
2653: CURSOR Cur_check_revision (V_revision VARCHAR2) IS
2654: SELECT 1
2655: FROM sys.dual
2656: WHERE EXISTS (SELECT 1
2657: FROM mtl_item_revisions
2658: WHERE inventory_item_id = p_inventory_item_id
2659: AND organization_id = p_organization_id