[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
705: l_responsibility_id NUMBER := fnd_global.resp_id;
706:
707: CURSOR Cur_ownerorgn_id IS
708: SELECT 1
709: FROM SYS.DUAL
710: WHERE EXISTS (SELECT 1
711: from org_access_view a, mtl_parameters b
712: where a.organization_id = b.organization_id
713: and b.organization_id = powner_orgn_id
1021: FROM gmd_vpd_security;
1022:
1023: CURSOR Cur_check_orgn_access (V_default_user_id PLS_INTEGER) IS
1024: SELECT 1
1025: FROM sys.dual
1026: WHERE EXISTS ( SELECT 1
1027: FROM gmd_security_profiles sp
1028: WHERE sp.access_type_ind = 'U'
1029: AND nvl(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1452: p_recipe_use IN NUMBER) IS
1453:
1454: CURSOR c_get_vr_id IS
1455: SELECT gmd_recipe_validity_id_s.NEXTVAL
1456: FROM FND_DUAL;
1457:
1458: CURSOR c_get_formula IS
1459: SELECT creation_date, formula_status, owner_organization_id
1460: FROM fm_form_mst_b
1680: LocalRoutRecord c_get_routing_info%ROWTYPE;
1681:
1682: CURSOR c_get_recipe_id IS
1683: SELECT gmd_recipe_id_s.NEXTVAL
1684: FROM FND_DUAL;
1685:
1686: CURSOR c_get_item_id IS
1687: SELECT inventory_item_id
1688: FROM fm_matl_dtl
2221: * Checks if the uom_code passed is valid - Return True if it exists *
2222: * *********************************************************************** */
2223: FUNCTION Validate_um(pItem_uom_code IN VARCHAR2) RETURN BOOLEAN IS
2224: Cursor Item_um_cur IS
2225: Select 1 from dual
2226: Where exists (Select 1 from mtl_units_of_measure
2227: Where uom_code = pItem_uom_code);
2228: l_dummy_cnt NUMBER;
2229: BEGIN
2594: l_exists PLS_INTEGER;
2595:
2596: CURSOR Cur_get_master_org IS
2597: SELECT 1
2598: FROM sys.dual
2599: WHERE EXISTS (SELECT 1
2600: FROM mtl_parameters
2601: WHERE master_organization_id = p_organization_id);
2602: BEGIN
2671: ORDER BY revision;
2672:
2673: CURSOR Cur_check_revision (V_revision VARCHAR2) IS
2674: SELECT 1
2675: FROM sys.dual
2676: WHERE EXISTS (SELECT 1
2677: FROM mtl_item_revisions
2678: WHERE inventory_item_id = p_inventory_item_id
2679: AND organization_id = p_organization_id