DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on FND_FLEX_KEYVAL

Line 1375: * Use FND_FLEX_KEYVAL to fetch the Concatenated segment values, Project Id, Task Id,

1371: * Query MTL_ITEM_LOCATIONS to fetch concatenated physical locator segments, project Id
1372: * and Task Id for the passed locator Id/Org Id. Call get_project_number and get_task_number
1373: * to get Project Number and Task Number.
1374: * else
1375: * Use FND_FLEX_KEYVAL to fetch the Concatenated segment values, Project Id, Task Id,
1376: * Project Number and Task Number for the passed LocatorId/OrgId combination.
1377: * FND_FLEX_KEYVAL.CONCATENATED_SEGMENTS -- Concatenated display values
1378: * FND_FLEX_KEYVAL.SEGMENT_VALUES -- Table of Segment Values
1379: * The fetched values are stored in Package variables,

Line 1377: * FND_FLEX_KEYVAL.CONCATENATED_SEGMENTS -- Concatenated display values

1373: * to get Project Number and Task Number.
1374: * else
1375: * Use FND_FLEX_KEYVAL to fetch the Concatenated segment values, Project Id, Task Id,
1376: * Project Number and Task Number for the passed LocatorId/OrgId combination.
1377: * FND_FLEX_KEYVAL.CONCATENATED_SEGMENTS -- Concatenated display values
1378: * FND_FLEX_KEYVAL.SEGMENT_VALUES -- Table of Segment Values
1379: * The fetched values are stored in Package variables,
1380: */
1381: PROCEDURE FETCH_COMBINATION(P_LOCATOR_ID IN NUMBER,

Line 1378: * FND_FLEX_KEYVAL.SEGMENT_VALUES -- Table of Segment Values

1374: * else
1375: * Use FND_FLEX_KEYVAL to fetch the Concatenated segment values, Project Id, Task Id,
1376: * Project Number and Task Number for the passed LocatorId/OrgId combination.
1377: * FND_FLEX_KEYVAL.CONCATENATED_SEGMENTS -- Concatenated display values
1378: * FND_FLEX_KEYVAL.SEGMENT_VALUES -- Table of Segment Values
1379: * The fetched values are stored in Package variables,
1380: */
1381: PROCEDURE FETCH_COMBINATION(P_LOCATOR_ID IN NUMBER,
1382: P_ORG_ID IN NUMBER) IS

Line 1460: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(

1456: ELSE
1457: IF (l_debug = 1) THEN
1458: MYDEBUG('Using FND APIs to get locator, project and task info');
1459: END IF;
1460: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(
1461: APPL_SHORT_NAME => 'INV',
1462: KEY_FLEX_CODE => 'MTLL',
1463: STRUCTURE_NUMBER => 101,
1464: COMBINATION_ID => P_LOCATOR_ID,

Line 1478: MYDEBUG('FETCH_COMBINATION: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);

1474: );
1475: IF NOT L_CC_ID_RET THEN
1476: IF (l_debug = 1) THEN
1477: MYDEBUG('FETCH_COMBINATION: VALIDATE_CCID: CALL FAILED');
1478: MYDEBUG('FETCH_COMBINATION: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1479: END IF;
1480: CLEAR_GLOBAL_VARS;
1481: ELSE
1482: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;

Line 1482: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;

1478: MYDEBUG('FETCH_COMBINATION: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1479: END IF;
1480: CLEAR_GLOBAL_VARS;
1481: ELSE
1482: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1483: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1484: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1485: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1486: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);

Line 1483: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);

1479: END IF;
1480: CLEAR_GLOBAL_VARS;
1481: ELSE
1482: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1483: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1484: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1485: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1486: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1487: END IF;

Line 1484: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);

1480: CLEAR_GLOBAL_VARS;
1481: ELSE
1482: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1483: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1484: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1485: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1486: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1487: END IF;
1488:

Line 1485: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);

1481: ELSE
1482: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1483: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1484: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1485: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1486: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1487: END IF;
1488:
1489: END IF; --END If g_concated_segments IS NOT NULL

Line 1486: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);

1482: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1483: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1484: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1485: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1486: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1487: END IF;
1488:
1489: END IF; --END If g_concated_segments IS NOT NULL
1490:

Line 1797: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(

1793: ELSE
1794: IF (l_debug = 1) THEN
1795: MYDEBUG('Using FND APIs to get locator, project and task info');
1796: END IF;
1797: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(
1798: APPL_SHORT_NAME => 'INV',
1799: KEY_FLEX_CODE => 'MTLL',
1800: STRUCTURE_NUMBER => 101,
1801: COMBINATION_ID => P_LOCATOR_ID,

Line 1815: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);

1811: );
1812: IF NOT L_CC_ID_RET THEN
1813: IF (l_debug = 1) THEN
1814: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: CALL FAILED');
1815: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1816: END IF;
1817: ELSE
1818: G_CONCATENATED_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1819: END IF;

Line 1818: G_CONCATENATED_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;

1814: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: CALL FAILED');
1815: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1816: END IF;
1817: ELSE
1818: G_CONCATENATED_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1819: END IF;
1820:
1821: END IF; --END If g_concated_segments IS NOT NULL
1822: IF (l_debug = 1) THEN