DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on FND_FLEX_KEYVAL

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

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

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

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

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

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

Line 1465: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(

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

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

1479: );
1480: IF NOT L_CC_ID_RET THEN
1481: IF (l_debug = 1) THEN
1482: MYDEBUG('FETCH_COMBINATION: VALIDATE_CCID: CALL FAILED');
1483: MYDEBUG('FETCH_COMBINATION: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1484: END IF;
1485: CLEAR_GLOBAL_VARS;
1486: ELSE
1487: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;

Line 1487: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;

1483: MYDEBUG('FETCH_COMBINATION: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1484: END IF;
1485: CLEAR_GLOBAL_VARS;
1486: ELSE
1487: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1488: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1489: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1490: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1491: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);

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

1484: END IF;
1485: CLEAR_GLOBAL_VARS;
1486: ELSE
1487: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1488: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1489: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1490: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1491: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1492: END IF;

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

1485: CLEAR_GLOBAL_VARS;
1486: ELSE
1487: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1488: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1489: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1490: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1491: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1492: END IF;
1493:

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

1486: ELSE
1487: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1488: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1489: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1490: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1491: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1492: END IF;
1493:
1494: END IF; --END If g_concated_segments IS NOT NULL

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

1487: G_PHYSICAL_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1488: G_PROJECT_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_PROJECT_COLUMN);
1489: G_PROJECT_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_PROJECT_COLUMN);
1490: G_TASK_NUMBER := FND_FLEX_KEYVAL.SEGMENT_VALUE(GET_TASK_COLUMN);
1491: G_TASK_ID := FND_FLEX_KEYVAL.SEGMENT_ID(GET_TASK_COLUMN);
1492: END IF;
1493:
1494: END IF; --END If g_concated_segments IS NOT NULL
1495:

Line 1827: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(

1823: ELSE
1824: IF (l_debug = 1) THEN
1825: MYDEBUG('Using FND APIs to get locator, project and task info');
1826: END IF;
1827: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(
1828: APPL_SHORT_NAME => 'INV',
1829: KEY_FLEX_CODE => 'MTLL',
1830: STRUCTURE_NUMBER => 101,
1831: COMBINATION_ID => P_LOCATOR_ID,

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

1841: );
1842: IF NOT L_CC_ID_RET THEN
1843: IF (l_debug = 1) THEN
1844: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: CALL FAILED');
1845: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1846: END IF;
1847: ELSE
1848: G_CONCATENATED_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1849: END IF;

Line 1848: G_CONCATENATED_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;

1844: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: CALL FAILED');
1845: MYDEBUG('GET_LOCATOR: VALIDATE_CCID: '||FND_FLEX_KEYVAL.ERROR_MESSAGE);
1846: END IF;
1847: ELSE
1848: G_CONCATENATED_LOCATOR := FND_FLEX_KEYVAL.CONCATENATED_VALUES;
1849: END IF;
1850:
1851: END IF; --END If g_concated_segments IS NOT NULL
1852: IF (l_debug = 1) THEN