APPS.OE_DEFAULTING_FWK_PUB dependencies on OE_AK_OBJECTS_EXT

Line 329: -- p_database_object_name => database object name stored in OE_AK_OBJECTS_EXT table

325: -- ARGUMENTS:
326: -- retcode => parameter passed to concurrent program
327: -- errbuf => parameter passed to concurrent program
328: -- p_application_id => entity application ID (for Order Entry, = 300)
329: -- p_database_object_name => database object name stored in OE_AK_OBJECTS_EXT table
330: -- (for Order Line, = 'OE_AK_ORDER_LINES_V')
331: --------------------------------------------------------------------------
332:
333: PROCEDURE Create_Entity_Def_handler

Line 411: FROM AK_FOREIGN_KEYS fk, AK_UNIQUE_KEYS uk, OE_AK_OBJECTS_EXT obj

407: ,uk.database_object_name uk_database_object_name
408: ,fk.foreign_key_name
409: ,obj.entity_code uk_entity_code
410: , obj.defaulting_enabled_flag uk_obj_defaulting_enabled
411: FROM AK_FOREIGN_KEYS fk, AK_UNIQUE_KEYS uk, OE_AK_OBJECTS_EXT obj
412: WHERE fk.database_object_name= p_database_object_name
413: AND fk.application_id= p_application_id
414: AND fk.unique_key_name = uk.unique_key_name
415: AND fk.application_id = uk.application_id

Line 540: from oe_ak_objects_ext

536: OR l_related_entity_code NOT IN ('HEADER','LINE') )
537: THEN
538:
539: select entity_id into l_entity_id
540: from oe_ak_objects_ext
541: where DATABASE_OBJECT_NAME =l_related_database_object_name;
542:
543: PUT_LINE(
544: '--------------------------------');

Line 610: from oe_ak_objects_ext

606: IF l_status = 'INVALID'
607: OR p_generate_all = 'Y'
608: THEN
609: select entity_id into l_entity_id
610: from oe_ak_objects_ext
611: where DATABASE_OBJECT_NAME =l_related_database_object_name;
612:
613: PUT_LINE(
614: '--------------------------------');

Line 662: from oe_ak_objects_ext

658: IF p_application_id <> 660
659: OR l_entity_code NOT IN ('HEADER','LINE') THEN
660:
661: select entity_id into l_entity_id
662: from oe_ak_objects_ext
663: where DATABASE_OBJECT_NAME =p_database_object_name;
664:
665: PUT_LINE(
666: '--------------------------------');

Line 773: from oe_ak_objects_ext

769: IF p_application_id = 660
770: AND l_entity_code IN ('HEADER','LINE') THEN
771:
772: select entity_id into l_entity_id
773: from oe_ak_objects_ext
774: where DATABASE_OBJECT_NAME =p_database_object_name;
775:
776: PUT_LINE(
777: '--------------------------------');

Line 1482: FROM OE_AK_OBJECTS_EXT

1478: IF l_src_type = 'RELATED_RECORD' THEN
1479:
1480: SELECT upper(entity_code)
1481: INTO l_related_entity_code
1482: FROM OE_AK_OBJECTS_EXT
1483: WHERE DATABASE_OBJECT_NAME = l_src_database_object_name;
1484:
1485: SELECT column_name
1486: INTO l_src_column_name

Line 2100: -- in OE_AK_OBJECTS_EXT table

2096: -- p_application_id: Application ID (660 for 'Oracle Order Management')
2097: -- p_database_object_name: AK base view for the related entity
2098: -- (OE_AK_SOLD_TO_ORGS_V for 'Customer')
2099: -- p_entity_code: Short entity code for the related entity stored
2100: -- in OE_AK_OBJECTS_EXT table
2101: -- (SOLD_TO_ORG for 'Customer')
2102: -- p_application_short_name: Application Short Name
2103: -- ('ONT' for 'Oracle Order Management')
2104: -- p_obj_defaulting_enabled : 'Y' if defaulting rules can be defined

Line 2312: -- oe_ak_objects_ext table

2308: New_Line;
2309:
2310: -- Following functions are NEEDED ONLY IF attributes for this object can be
2311: -- defaulted i.e. defaulting_enabled_flag = 'Y' for this entity on the
2312: -- oe_ak_objects_ext table
2313:
2314: IF upper(p_obj_defaulting_enabled) = 'Y' THEN
2315:
2316: -- FUNCTION Get_Foreign_Attr_Val_Varchar2