DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PVT dependencies on FND_DFLEX

Line 1392: -- REFERENCE FROM FND_DFLEX specification

1388: ,x_return_status OUT NOCOPY VARCHAR2
1389: ,x_msg_count OUT NOCOPY NUMBER
1390: ,x_msg_data OUT NOCOPY VARCHAR2
1391: ) IS
1392: -- REFERENCE FROM FND_DFLEX specification
1393: -- TYPE dflex_r IS RECORD
1394: -- (application_id fnd_application.application_id%TYPE,
1395: -- flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE);
1396: l_dflex_r fnd_dflex.dflex_r;

Line 1396: l_dflex_r fnd_dflex.dflex_r;

1392: -- REFERENCE FROM FND_DFLEX specification
1393: -- TYPE dflex_r IS RECORD
1394: -- (application_id fnd_application.application_id%TYPE,
1395: -- flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE);
1396: l_dflex_r fnd_dflex.dflex_r;
1397:
1398: -- REFERENCE FROM FND_DFLEX specification
1399: -- TYPE dflex_dr IS RECORD
1400: -- (title fnd_descriptive_flexs_vl.title%TYPE,

Line 1398: -- REFERENCE FROM FND_DFLEX specification

1394: -- (application_id fnd_application.application_id%TYPE,
1395: -- flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE);
1396: l_dflex_r fnd_dflex.dflex_r;
1397:
1398: -- REFERENCE FROM FND_DFLEX specification
1399: -- TYPE dflex_dr IS RECORD
1400: -- (title fnd_descriptive_flexs_vl.title%TYPE,
1401: -- table_name fnd_descriptive_flexs_vl.application_table_name%TYPE,
1402: -- table_app fnd_application.application_short_name%TYPE,

Line 1410: l_dflex_dr fnd_dflex.dflex_dr;

1406: -- default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
1407: -- protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
1408: -- form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
1409: -- context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE);
1410: l_dflex_dr fnd_dflex.dflex_dr;
1411:
1412: -- REFERENCE FROM FND_DFLEX specification
1413: -- TYPE context_r IS RECORD
1414: -- (flexfield dflex_r

Line 1412: -- REFERENCE FROM FND_DFLEX specification

1408: -- form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
1409: -- context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE);
1410: l_dflex_dr fnd_dflex.dflex_dr;
1411:
1412: -- REFERENCE FROM FND_DFLEX specification
1413: -- TYPE context_r IS RECORD
1414: -- (flexfield dflex_r
1415: -- ,context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE);
1416: l_global_ctx_r fnd_dflex.context_r;

Line 1416: l_global_ctx_r fnd_dflex.context_r;

1412: -- REFERENCE FROM FND_DFLEX specification
1413: -- TYPE context_r IS RECORD
1414: -- (flexfield dflex_r
1415: -- ,context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE);
1416: l_global_ctx_r fnd_dflex.context_r;
1417: l_dff_ctx_r fnd_dflex.context_r;
1418:
1419: -- REFERENCE FROM FND_DFLEX specification
1420: -- TYPE context_code_a IS TABLE OF

Line 1417: l_dff_ctx_r fnd_dflex.context_r;

1413: -- TYPE context_r IS RECORD
1414: -- (flexfield dflex_r
1415: -- ,context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE);
1416: l_global_ctx_r fnd_dflex.context_r;
1417: l_dff_ctx_r fnd_dflex.context_r;
1418:
1419: -- REFERENCE FROM FND_DFLEX specification
1420: -- TYPE context_code_a IS TABLE OF
1421: -- fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE

Line 1419: -- REFERENCE FROM FND_DFLEX specification

1415: -- ,context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE);
1416: l_global_ctx_r fnd_dflex.context_r;
1417: l_dff_ctx_r fnd_dflex.context_r;
1418:
1419: -- REFERENCE FROM FND_DFLEX specification
1420: -- TYPE context_code_a IS TABLE OF
1421: -- fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
1422: -- INDEX BY BINARY_INTEGER;
1423: -- TYPE context_name_a IS TABLE OF

Line 1432: l_tbl_ctx_code fnd_dflex.context_code_a;

1428: -- INDEX BY BINARY_INTEGER;
1429: -- TYPE boolean_a IS TABLE OF
1430: -- BOOLEAN
1431: -- INDEX BY BINARY_INTEGER;
1432: l_tbl_ctx_code fnd_dflex.context_code_a;
1433: l_tbl_ctx_is_global fnd_dflex.boolean_a;
1434: -- REFERENCE FROM FND_DFLEX specification
1435: -- TYPE contexts_dr IS RECORD
1436: -- (ncontexts BINARY_INTEGER,

Line 1433: l_tbl_ctx_is_global fnd_dflex.boolean_a;

1429: -- TYPE boolean_a IS TABLE OF
1430: -- BOOLEAN
1431: -- INDEX BY BINARY_INTEGER;
1432: l_tbl_ctx_code fnd_dflex.context_code_a;
1433: l_tbl_ctx_is_global fnd_dflex.boolean_a;
1434: -- REFERENCE FROM FND_DFLEX specification
1435: -- TYPE contexts_dr IS RECORD
1436: -- (ncontexts BINARY_INTEGER,
1437: -- global_context BINARY_INTEGER,

Line 1434: -- REFERENCE FROM FND_DFLEX specification

1430: -- BOOLEAN
1431: -- INDEX BY BINARY_INTEGER;
1432: l_tbl_ctx_code fnd_dflex.context_code_a;
1433: l_tbl_ctx_is_global fnd_dflex.boolean_a;
1434: -- REFERENCE FROM FND_DFLEX specification
1435: -- TYPE contexts_dr IS RECORD
1436: -- (ncontexts BINARY_INTEGER,
1437: -- global_context BINARY_INTEGER,
1438: -- context_code context_code_a,

Line 1443: l_ctx_dr fnd_dflex.contexts_dr;

1439: -- context_name context_name_a,
1440: -- context_description context_description_a,
1441: -- is_enabled boolean_a,
1442: -- is_global boolean_a);
1443: l_ctx_dr fnd_dflex.contexts_dr;
1444:
1445: -- REFERENCE FROM FND_DFLEX specification
1446: -- TYPE segment_description_a IS TABLE OF
1447: -- fnd_descr_flex_col_usage_vl.description%TYPE

Line 1445: -- REFERENCE FROM FND_DFLEX specification

1441: -- is_enabled boolean_a,
1442: -- is_global boolean_a);
1443: l_ctx_dr fnd_dflex.contexts_dr;
1444:
1445: -- REFERENCE FROM FND_DFLEX specification
1446: -- TYPE segment_description_a IS TABLE OF
1447: -- fnd_descr_flex_col_usage_vl.description%TYPE
1448: -- INDEX BY BINARY_INTEGER;
1449: -- TYPE application_column_name_a IS TABLE OF

Line 1477: -- REFERENCE FROM FND_DFLEX specification

1473: -- TYPE default_value_a IS TABLE OF
1474: -- fnd_descr_flex_col_usage_vl.default_value%TYPE
1475: -- INDEX BY BINARY_INTEGER;
1476:
1477: -- REFERENCE FROM FND_DFLEX specification
1478: -- TYPE segments_dr IS RECORD
1479: -- (nsegments BINARY_INTEGER,
1480: -- application_column_name application_column_name_a,
1481: -- segment_name segment_name_a,

Line 1493: l_global_seg_dr fnd_dflex.segments_dr;

1489: -- description segment_description_a,
1490: -- value_set value_set_a,
1491: -- default_type default_type_a,
1492: -- default_value default_value_a);
1493: l_global_seg_dr fnd_dflex.segments_dr;
1494: l_dff_seg_dr fnd_dflex.segments_dr;
1495:
1496: l_std_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
1497: l_dff_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

Line 1494: l_dff_seg_dr fnd_dflex.segments_dr;

1490: -- value_set value_set_a,
1491: -- default_type default_type_a,
1492: -- default_value default_value_a);
1493: l_global_seg_dr fnd_dflex.segments_dr;
1494: l_dff_seg_dr fnd_dflex.segments_dr;
1495:
1496: l_std_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
1497: l_dff_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
1498:

Line 1560: FND_DFLEX.get_flexfield

1556: OR attribute15 IS NOT NULL
1557: );
1558: IF l_count <> 0 THEN
1559: -- validate the flex field
1560: FND_DFLEX.get_flexfield
1561: (appl_short_name => 'INV'
1562: ,flexfield_name => 'MTL_MFG_PART_NUMBERS'
1563: ,flexfield => l_dflex_r
1564: ,flexinfo => l_dflex_dr

Line 1568: ,p_message => 'Call to FND_DFLEX.get_flexfield complete'

1564: ,flexinfo => l_dflex_dr
1565: );
1566: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
1567: ,p_module => l_api_name
1568: ,p_message => 'Call to FND_DFLEX.get_flexfield complete'
1569: );
1570: --
1571: -- get the contexts defined for the flex field.
1572: --

Line 1573: FND_DFLEX.get_contexts

1569: );
1570: --
1571: -- get the contexts defined for the flex field.
1572: --
1573: FND_DFLEX.get_contexts
1574: (flexfield => l_dflex_r
1575: ,contexts => l_ctx_dr
1576: );
1577: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 1579: ,p_message => 'Call to FND_DFLEX.get_contexts complete'

1575: ,contexts => l_ctx_dr
1576: );
1577: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
1578: ,p_module => l_api_name
1579: ,p_message => 'Call to FND_DFLEX.get_contexts complete'
1580: );
1581: resetDFFFieldUsage (p_dff_usage_record => l_dff_fields_used);
1582: l_tbl_ctx_is_global := l_ctx_dr.is_global;
1583: IF (l_tbl_ctx_is_global.COUNT > 0) THEN

Line 1602: FND_DFLEX.get_segments

1598: l_global_ctx_r.context_code := l_ctx_dr.context_code(l_global_ctx_index);
1599: l_last_attribute_category := l_global_ctx_r.context_code;
1600: l_global_data_elements := l_global_ctx_r.context_code;
1601:
1602: FND_DFLEX.get_segments
1603: (context => l_global_ctx_r
1604: ,segments => l_global_seg_dr
1605: ,enabled_only => TRUE
1606: );

Line 1622: FND_DFLEX.get_segments

1618: FOR i IN l_tbl_ctx_code.FIRST .. l_tbl_ctx_code.LAST LOOP
1619: IF l_tbl_ctx_code(i) = cr.attribute_category THEN
1620: l_last_attribute_category := cr.attribute_category;
1621: l_dff_ctx_r.context_code := cr.attribute_category;
1622: FND_DFLEX.get_segments
1623: (context => l_dff_ctx_r
1624: ,segments => l_dff_seg_dr
1625: ,enabled_only => TRUE
1626: );