DBA Data[Home] [Help]

APPS.AHL_CMP_PVT dependencies on FND_FLEX_KEY_API

Line 1413: l_fftype FND_FLEX_KEY_API.flexfield_type;

1409: TYPE t_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1410: l_task_id_tbl t_id_tbl;
1411:
1412: -- variables for locator flexfield handling
1413: l_fftype FND_FLEX_KEY_API.flexfield_type;
1414: l_ffstrctr FND_FLEX_KEY_API.structure_type;
1415: l_sprtr VARCHAR2(1);
1416:
1417: -- variable for material transfer

Line 1414: l_ffstrctr FND_FLEX_KEY_API.structure_type;

1410: l_task_id_tbl t_id_tbl;
1411:
1412: -- variables for locator flexfield handling
1413: l_fftype FND_FLEX_KEY_API.flexfield_type;
1414: l_ffstrctr FND_FLEX_KEY_API.structure_type;
1415: l_sprtr VARCHAR2(1);
1416:
1417: -- variable for material transfer
1418: l_ahl_mtlxfr_tbl Ahl_Mtlxfr_Tbl_Type;

Line 1725: FND_FLEX_KEY_API.set_session_mode('seed_data');

1721: END IF;
1722:
1723: -- get the separator defined for the locator flexfield
1724: FND_PROFILE.put('MFG_ORGANIZATION_ID', p_item_inv_org_id); -- set mfg_organization_id profile - bug# 6010795
1725: FND_FLEX_KEY_API.set_session_mode('seed_data');
1726: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type
1727: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
1728: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
1729: IF (l_log_statement >= l_log_current_level) THEN

Line 1726: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type

1722:
1723: -- get the separator defined for the locator flexfield
1724: FND_PROFILE.put('MFG_ORGANIZATION_ID', p_item_inv_org_id); -- set mfg_organization_id profile - bug# 6010795
1725: FND_FLEX_KEY_API.set_session_mode('seed_data');
1726: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type
1727: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
1728: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
1729: IF (l_log_statement >= l_log_current_level) THEN
1730: FND_LOG.string(l_log_statement, l_full_name,' l_sprtr = '||l_sprtr);

Line 1727: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type

1723: -- get the separator defined for the locator flexfield
1724: FND_PROFILE.put('MFG_ORGANIZATION_ID', p_item_inv_org_id); -- set mfg_organization_id profile - bug# 6010795
1725: FND_FLEX_KEY_API.set_session_mode('seed_data');
1726: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type
1727: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
1728: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
1729: IF (l_log_statement >= l_log_current_level) THEN
1730: FND_LOG.string(l_log_statement, l_full_name,' l_sprtr = '||l_sprtr);
1731: END IF;

Line 2300: l_fftype FND_FLEX_KEY_API.flexfield_type;

2296: TYPE t_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2297: l_task_id_tbl t_id_tbl;
2298:
2299: -- variables for locator flexfield handling
2300: l_fftype FND_FLEX_KEY_API.flexfield_type;
2301: l_ffstrctr FND_FLEX_KEY_API.structure_type;
2302: l_sprtr VARCHAR2(1);
2303:
2304: -- variable for material transfer

Line 2301: l_ffstrctr FND_FLEX_KEY_API.structure_type;

2297: l_task_id_tbl t_id_tbl;
2298:
2299: -- variables for locator flexfield handling
2300: l_fftype FND_FLEX_KEY_API.flexfield_type;
2301: l_ffstrctr FND_FLEX_KEY_API.structure_type;
2302: l_sprtr VARCHAR2(1);
2303:
2304: -- variable for material transfer
2305: l_ahl_mtlxfr_tbl Ahl_Mtlxfr_Tbl_Type;

Line 2614: FND_FLEX_KEY_API.set_session_mode('seed_data');

2610: END IF;
2611:
2612: -- get the separator defined for the locator flexfield
2613: FND_PROFILE.put('MFG_ORGANIZATION_ID', l_item_inst_det_csr.inv_organization_id); -- set mfg_organization_id profile - bug# 6010795
2614: FND_FLEX_KEY_API.set_session_mode('seed_data');
2615: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type
2616: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
2617: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
2618:

Line 2615: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type

2611:
2612: -- get the separator defined for the locator flexfield
2613: FND_PROFILE.put('MFG_ORGANIZATION_ID', l_item_inst_det_csr.inv_organization_id); -- set mfg_organization_id profile - bug# 6010795
2614: FND_FLEX_KEY_API.set_session_mode('seed_data');
2615: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type
2616: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
2617: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
2618:
2619: IF (l_log_statement >= l_log_current_level) THEN

Line 2616: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type

2612: -- get the separator defined for the locator flexfield
2613: FND_PROFILE.put('MFG_ORGANIZATION_ID', l_item_inst_det_csr.inv_organization_id); -- set mfg_organization_id profile - bug# 6010795
2614: FND_FLEX_KEY_API.set_session_mode('seed_data');
2615: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type
2616: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
2617: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
2618:
2619: IF (l_log_statement >= l_log_current_level) THEN
2620: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' l_sprtr = '||l_sprtr);