APPS.OKE_AMG_GRP dependencies on DUAL

Line 1073: select oke_k_deliverables_s.nextval into l_deliverable_id from dual;

1069: RAISE FND_API.G_EXC_ERROR ;
1070: end if;
1071:
1072: If p_action = G_CRT then
1073: select oke_k_deliverables_s.nextval into l_deliverable_id from dual;
1074: OKE_DELIVERABLES_PKG.insert_row(
1075: X_ROWID => l_row_id,
1076: X_DELIVERABLE_ID => l_deliverable_id,
1077: X_DELIVERABLE_NUMBER => p_dlv_rec.dlv_short_name,

Line 1318: into l_pa_action_id,l_pa_deliverable_id,l_action_name from dual;

1314:
1315: Select decode(p_dlv_action_type,G_SHIP,p_dlv_ship_action_rec.pa_action_id,G_REQ, p_dlv_req_action_rec.pa_action_id,NULL),
1316: decode(p_dlv_action_type,G_SHIP,p_dlv_ship_action_rec.pa_deliverable_id,G_REQ, p_dlv_req_action_rec.pa_deliverable_id,NULL),
1317: decode(p_dlv_action_type,G_SHIP,p_dlv_ship_action_rec.action_name,G_REQ, p_dlv_req_action_rec.action_name,NULL)
1318: into l_pa_action_id,l_pa_deliverable_id,l_action_name from dual;
1319:
1320: If l_pa_action_id is null then
1321: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1322: p_token1 =>'COL_NAME',

Line 1493: Select oke_k_deliverables_S.nextval into l_action_id from dual;

1489: end if;
1490:
1491: If p_action=G_CRT then
1492:
1493: Select oke_k_deliverables_S.nextval into l_action_id from dual;
1494: Insert into oke_deliverable_actions(ACTION_ID,
1495: CREATION_DATE,
1496: CREATED_BY ,
1497: LAST_UPDATE_DATE,