APPS.EGO_PUB_FWK_PK dependencies on DUAL

Line 1643: FROM dual

1639: select inner_name into l_struct_name
1640: from (
1641: SELECT bom_globals.retrieve_message('BOM', 'BOM_PRIMARY') displayname,
1642: 'PRIMARY' inner_name
1643: FROM dual
1644: UNION
1645: SELECT bad.display_name displayname,
1646: bad.alternate_designator_code inner_name
1647: FROM bom_alternate_designators_vl bad

Line 2700: select MTL_BUSINESS_EVENTS_S.nextval into l_event_key from dual;

2696: ,p_message => 'prepare evt params');
2697:
2698: -- invoke business event
2699: -- get key from sequence MTL_BUSINESS_EVENTS_S
2700: select MTL_BUSINESS_EVENTS_S.nextval into l_event_key from dual;
2701: -- params: batch_id, $pub_params, workspace_name, auto_release
2702: if (p_batch_type = C_BATCH_ENTITY_ITEM) THEN
2703: select CASE WHEN (CHAR_VALUE IS NULL) THEN 'N' ELSE 'Y' END
2704: into l_struct_flag

Line 3085: select EGO_PUB_BAT_HDR_S1.nextVal into l_batch_id from dual;

3081: ,p_message => 'x_return_status ' || x_return_status);
3082:
3083: -- insert data into batch tables
3084: -- header, params, entities, target systems, status(entities*systems)
3085: select EGO_PUB_BAT_HDR_S1.nextVal into l_batch_id from dual;
3086: -- insert batch header with batch_name and batch_type, batch doesn't has tl tables
3087: insert into EGO_PUB_BAT_HDR_B (
3088: BATCH_ID,
3089: BATCH_NAME,

Line 3120: select EGO_PUB_BAT_PARAMS_S1.NEXTVAL into l_type_param_id from dual;

3116: -- insert batch params with pub_params and batch_id (mapping to type_id)
3117: For i in 1..l_pub_params.count Loop
3118: debugBatchParam(l_module_name, l_pub_params(i));
3119:
3120: select EGO_PUB_BAT_PARAMS_S1.NEXTVAL into l_type_param_id from dual;
3121: insert into EGO_PUB_BAT_PARAMS_B (
3122: TYPE_PARAM_ID,
3123: TYPE_ID,
3124: TYPE,

Line 3167: select EGO_PUB_BAT_ENT_OBJS_S1.NEXTVAL into l_ent_obj_id from dual;

3163: || ', pk4:' || nvl(l_batch_entities(i).pk4_value, 'null')
3164: || ', pk5:' || nvl(l_batch_entities(i).pk5_value, 'null')
3165: || ', user_entered:' || nvl(l_batch_entities(i).user_entered, 'null')
3166: );
3167: select EGO_PUB_BAT_ENT_OBJS_S1.NEXTVAL into l_ent_obj_id from dual;
3168: insert into EGO_PUB_BAT_ENT_OBJS_B (
3169: batch_entity_object_id,
3170: batch_id,
3171: entity_type_id,