317: l_api_version NUMBER;
318: l_api_name VARCHAR2(30);
319: l_curr_sequence NUMBER;
320: l_future_sequence NUMBER;
321: l_phase_change_code EGO_LCPHASE_POLICY.ACTION_CODE%TYPE;
322: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
323: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
324: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
325: l_current_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
508: /*
509: SELECT
510: POLICY_CODE INTO x_policy_code
511: FROM
512: EGO_LCPHASE_POLICY
513: WHERE
514: PHASE_ID = p_curr_phase_id
515: AND ACTION_CODE = l_phase_change_code
516: AND LIFECYCLE_ID = p_lifecycle_id